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