private void btnReadFileExcel_Click(object sender, EventArgs e)
{
try
{
Excel.Application xlap = new Excel.Application();
Excel.Workbook xbook = xlap.Workbooks.Open(txtPath.Text);
//listSheet = CommonOfficeExcel.LoadExcel(filePath);
listSheet = CommonOfficeExcel.LoadExcelExt(xbook);
dgvListSheet.DataSource = listSheet;
xbook.Close(true, null, null);
xlap.Quit();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
