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