public static void Create(string fileName, string sheetName)
{
IWorkbook workbook = WorkbookHelper.Create(fileName);
if (workbook == null)
{
throw new Exception("Cannot create IWorkbook object!");
}
workbook.CreateSheet(sheetName);
Create(workbook, fileName);
}
public static void Create(string templateFileName, string fileName, string sheetName, DataTable table)
{
if (!File.Exists(templateFileName))
{
throw new Exception("Template file not found!");
}
if (File.Exists(fileName))
{
throw new Exception("File exists!");
}
IWorkbook templateWorkbook = WorkbookHelper.CreateInputWorkbook(templateFileName);
if (templateWorkbook == null)
{
throw new Exception("Cannot create IWorkbook object!");
}
IWorkbook workbook = WorkbookHelper.Append(templateWorkbook, sheetName, table);
Create(workbook, fileName);
}
public static void Append(string fileName, string sheetName, DataTable dt)
{
WorkbookHelper.Append(fileName, sheetName, dt);
}
public static void Append(string fileName, DataSet ds)
{
WorkbookHelper.Append(fileName, ds);
}