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