/// <summary>
/// Open an existing Excel file
/// </summary>
/// <param name="ExcelFileName"></param>
/// <param name="firstRow"></param>
/// <param name="lastRow"></param>
/// <param name="activeWorksheetNumber"></param>
/// <returns></returns>
protected bool InitExcelFile(string ExcelFileName, int firstRow = 1, int lastRow = int.MaxValue, int activeWorksheetNumber = 1)
{
FileInfo fi = new FileInfo(ExcelFileName);
if (null != ExcelFileName && fi.Exists)
{
excelSource = new BaseExcelInteropReport(ExcelOpenType.OpenExistingTemplateFile, ExcelFileName, false);
activeWorksheet = excelSource.getWorksheet(activeWorksheetNumber);
row2Begin = firstRow;
row2Finish = lastRow;
}
else
{
return(false);
}
return(true);
}
/// <summary>
/// Creates a new Excel Report
/// </summary>
/// <param name="ExcelFileName">The File Name</param>
/// <param name="firstRow"></param>
/// <param name="lastRow"></param>
/// <param name="activeWorksheetNumber"></param>
/// <returns></returns>
protected bool InitNewExcelFile(string ExcelFileName, int firstRow = 1, int lastRow = int.MaxValue, int activeWorksheetNumber = 1)
{
FileInfo fi = new FileInfo(ExcelFileName);
//ExcelCapabilitiesModel theModel = new ExcelCapabilitiesModel();
if (null != ExcelFileName && !fi.Exists)
{
excelSource = new BaseExcelInteropReport(ExcelOpenType.CreateNewFile, ExcelFileName, true);
activeWorksheet = excelSource.getWorksheet(1);
activeWorksheet.Name = "report-on-" + DateTime.Now.ToString("yyyy-MM-dd");
row2Begin = firstRow;
row2Finish = lastRow;
}
else
{
return(false);
}
return(true);
}
