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
}
}
List <ExcelCalculatorModel> ComputeData(List <ExcelSheetModel> list, BackgroundWorker worker, DoWorkEventArgs e)
{
Excel.Application xlap = new Excel.Application();
Excel.Workbook xbook = xlap.Workbooks.Open(txtPath.Text);
int i = 1;
foreach (var dto in list)
{
if (worker.CancellationPending == true)
{
e.Cancel = true;
break;
}
else
{
Excel.Worksheet xsheet = xbook.Sheets[dto.SheetName];
//var dtoCalculator = CommonOfficeExcel.LoadExcelSheet(txtPath.Text, dto.SheetName, dto.ColumnIndex);
var dtoCalculator = CommonOfficeExcel.LoadExcelSheetExt(xlap, xsheet, dto.ColumnIndex);
listCalculator.Add(dtoCalculator);
int percentComplete = (int)((float)i / (float)list.Count * 100);
worker.ReportProgress(percentComplete);
i++;
}
}
xbook.Close(true, null, null);
xlap.Quit();
return(listCalculator);
}
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());
}
}
private void btnOpenFile_Click(object sender, EventArgs e)
{
txtPathFile.Text = CommonOfficeExcel.openFile();
}
