protected override void ExportCore(Stream stream, TBodyList tList)
{
workBook = NPOIExtension.CreateWorkbook(exportSetting.XlsFormat);
//----set summary
//DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
//dsi.Company = "BlackEyes";
//workBook.DocumentSummaryInformation = dsi;
//SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
//si.Subject = "HKH.Exchange.ExcelExport";
//workBook.SummaryInformation = si;
//----end
//----create dateformat
dateFormat = workBook.CreateDataFormat().GetFormat(dateFormatString);
//----end
sheet = workBook.CreateSheet(exportSetting.Sheet);
CustomPageHeader(sheet.Header);
CustomTableHeader(sheet);
WriteBody(tList);
CustomTableFooter(sheet);
workBook.Write(stream);
}
public void Fill <THeader>(string templateFile, Stream targetStream, TBodyList tList, THeader tHeader)
{
if (string.IsNullOrEmpty(templateFile) || !File.Exists(templateFile))
{
throw Error.ArgumentNotValid("templateFile");
}
using (Stream stream = File.Open(templateFile, FileMode.Open, FileAccess.ReadWrite))
{
workBook = NPOIExtension.CreateWorkbook(XlsFormat.Auto, stream);
Fill(tList, tHeader);
}
workBook.Write(targetStream);
Reset();
}
/// <summary>
/// Load the excel file to NPOI worksheet
/// </summary>
/// <param name="xlsFile"></param>
/// <param name="sheetName"></param>
protected override void PrepareWorkSheet(Import import, string xlsFile, string sheetName)
{
using (Stream stream = File.Open(xlsFile, FileMode.Open, FileAccess.ReadWrite))
{
workBook = NPOIExtension.CreateWorkbook(import.XlsFormat, stream);
//looks as sheet index if it is Integer, otherwise TableName
int sheetIndex = 0;
if (int.TryParse(sheetName, out sheetIndex))
{
sheet = workBook.GetSheetAt(sheetIndex);
}
else
{
sheet = workBook.GetSheet(sheetName);
}
stream.Close();
}
}
