public void WriteTableNoTitle(DataTable dt, string filepath)
{
XSSFWorkbook xssfworkbook = new XSSFWorkbook();
ISheet sheet = xssfworkbook.CreateSheet(dt.TableName == "" ? FILE_NAME : dt.TableName);
CalculateTool.WriteBody(sheet, dt);
using (MemoryStream ms = new MemoryStream())
{
xssfworkbook.Write(ms);
var buf = ms.ToArray();
using (FileStream fs = new FileStream(filepath, FileMode.Create, FileAccess.Write))
{
fs.Write(buf, 0, buf.Length);
fs.Flush();
}
}
}
public override void WriteTable(DataTable dt, string filepath)
{
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
ISheet sheet = hssfworkbook.CreateSheet(dt.TableName == "" ? FILE_NAME : dt.TableName);
IRow header = sheet.CreateRow(0);
CalculateTool.WriteHeader(header, dt);
CalculateTool.WriteBody(sheet, dt);
using (MemoryStream stream = new MemoryStream())
{
hssfworkbook.Write(stream);
var buf = stream.ToArray();
using (FileStream fs = new FileStream(filepath, FileMode.Create, FileAccess.Write))
{
fs.Write(buf, 0, buf.Length);
fs.Flush();
}
}
}
