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