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(); }