public void Write(Stream stream, string templatePath, DataSet ds, ExcelExtendType extendType = ExcelExtendType.XLSX)
{
TemplateConfig config = new TemplateConfig();
config.Load(templatePath);
TTemplate template = config.GetTemplate();
Write(stream, template, ds);
}
/// <summary>
/// WriteFile
/// </summary>
/// <param name="outputFilePath"></param>
/// <param name="ds"></param>
/// <param name="templateName"></param>
/// <returns></returns>
public bool WriteFile(string outputFilePath, DataSet ds, string templateName)
{
POIStream stream = new POIStream();
stream.AllowClose = false;
ExcelExtendType extendType = outputFilePath.IndexOf(".xlsx") > 0 ? ExcelExtendType.XLSX : ExcelExtendType.XLS;
TemplateConfig templateConfig = new TemplateConfig();
templateConfig.Load(templateName);
TTemplate template = templateConfig.GetTemplate();
if (template == null)
{
Write(stream, ds, extendType);
}
else
{
Write(stream, template, ds, extendType);
}
bool result = WriteFile(outputFilePath, stream);
return(result);
}