private void btnReadFile_Click(object sender, EventArgs e)
{
String sheetName = txtSheetName.Text;
String filePath = txtPathFile.Text; //get the path of the file
String fileExt = Path.GetExtension(filePath); //get the file extension
if (fileExt.CompareTo(".xls") == 0 || fileExt.CompareTo(".xlsx") == 0)
{
try
{
DataTable dtExcel = new DataTable();
dtExcel = CommonOfficeExcel.ReadExcel(filePath, fileExt, sheetName); //read excel file
dataGrid.Visible = true;
dataGrid.DataSource = dtExcel;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
else
{
MessageBox.Show("Please choose .xls or .xlsx file only.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error); //custom messageBox to show error
}
}
