protected override HSSFWorkbook InternalGenerate() { var workbook = new HSSFWorkbook(new MemoryStream(Templates.ExceptionSchedule)); styles = new StandardCellStyles(workbook); AddDataToReport(workbook.GetSheetAt(0), GetDefaultExceptionScheduleData()); AddDataToReport(workbook.GetSheetAt(1), GetServiceExceptionScheduleData(), false); return workbook; }
protected override HSSFWorkbook InternalGenerate() { var data = GetData(); var workbook = new HSSFWorkbook(new MemoryStream(Templates.ClientRequest)); var worksheet = workbook.GetSheetAt(0); styles = new StandardCellStyles(workbook); int rowIndex = worksheet.LastRowNum + 1; var row = worksheet.CreateRow(0); WriteCell(row, 0, c => c.SetCellValue(data.Title), styles[StandardCellStyles.BoldStyle]); foreach (var item in data.Items) { row = worksheet.CreateRow(rowIndex++); WriteCell(row, 0, c => c.SetCellValue(item.CreateDate.ToString())); WriteCell(row, 1, c => c.SetCellValue(item.Message)); }; return workbook; }