public static void DoUpdateLog(OracleConnection conn)
{
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Open("ABBank_LOS_Tổng hợp kết quả import.xlsx");
WorksheetImpl worksheet = (WorksheetImpl)workbook.Worksheets[0];
for (int i = 1; i <= worksheet.LastRow; i++)
{
FilterValue(conn, worksheet.Range[$"D{i}"]);
}
for (int i = 1; i <= worksheet.LastRow; i++)
{
FilterValue(conn, worksheet.Range[$"E{i}"]);
}
////Shifts cells towards Left after deletion
//worksheet.Range["A1:E1"].Clear(ExcelMoveDirection.MoveLeft);
////Shifts cells toward Up after deletion
//worksheet.Range["A1:A6"].Clear(ExcelMoveDirection.MoveUp);
workbook.SaveAs($"ABBank_LOS_Tổng hợp kết quả import_{DateTime.Now.ToString("yyyyMMdd")}.xlsx");
//Process.Start("EXCEL.EXE", "Book1.xlsx");
}
}
private static void DoFillDataIntoWorksheet(WorksheetImpl worksheet, OracleConnection conn)
{
try
{
using (var cmd = new OracleCommand(worksheet.Range[$"A1"].Text, conn))
{
DataTable table = new DataTable();
OracleDataAdapter da = new OracleDataAdapter(cmd);
da.Fill(table);
DataView view = table.DefaultView;
worksheet.ImportDataView(view, true, 1, 1);
}
}
catch
{
}
}
