static DataTable TestExcelRead(string file, string sheetName) { DataTable dt = new DataTable(); try { using (ExcelHelper excelHelper = new ExcelHelper(file)) dt = excelHelper.ExcelToDataTable(sheetName, true); return dt; } catch (Exception ex) { Console.WriteLine("Exception: " + ex.Message); return null; } }
static void TestExcelWrite(DataTable data, string fileName, string sheetName) { try { using (ExcelHelper excelHelper = new ExcelHelper(fileName)) { int count = excelHelper.DataTableToExcel(data, sheetName, true); if (count > 0) Console.WriteLine("Number of imported data is {0} ", count); } } catch (Exception ex) { Console.WriteLine("Exception: " + ex.Message); } }