报表数据导出Excel,很常见的需求,然而每次都能忘了,今天再次遇到了,总结一下。..."计划开始时间" }, { "EndTime", "计划结束时间" }, { "Transactor", "处理人" }, { "Status", "工单状态" }, { "WorkClass", "班次...+)
{ //设置列宽度,256*字符数,因为单位是1/256个字符 sheet.SetColumnWidth(i, 256 * columnWidth[i]); }
把生成的Excel...发送到客户端
MemoryStream ms = new MemoryStream();
wb.Write(ms);
Response.AddHeader..."计划开始时间" }, { "EndTime", "计划结束时间" }, { "Transactor", "处理人" }, { "Status", "工单状态" }, { "WorkClass", "班次