NpoiExcelHelper nopi = new NpoiExcelHelper();
DataTable table = nopi.ListToDataTable(list); --list是IList类型
nopi.Write(table, "", "sheetName", strFieldsName, strFieldsTitle, --strFieldsName是list的对象名,strFieldsTitle是表头
tj, '',"导出.xls",maintainStaffNameDic); --tj是用来sheet2的统计信息的,maintainStaffNameDic是用来sheet2的信息之一.
public void Write(DataTable table, string headerText, string sheetName,
string[] columnName, string[] columnTitle, MalfunctionHandleTJ tj,
string headerText1, string fileName, Dictionary<string, int> maintainStaffNameDic)
{
HttpContext context = HttpContext.Current;
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(fileName, Encoding.UTF8)));
context.Response.Clear();
HSSFWorkbook hssfworkbook = GenerateData(table, headerText, sheetName,
columnName, columnTitle, tj, headerText1, maintainStaffNameDic);
context.Response.BinaryWrite(WriteToStream(hssfworkbook).GetBuffer());
context.Response.End();
}
现在我有另外一个页面也需要导出列表到excel,同样也是调用对应的方法. 但是问题来了,执行完之后,没报错,数据也填充好了,表头和list对象名,list的数据内容都没问题的..
但是却导不出excel(360没弹出框,谷歌也没有自动下载).
NpoiExcelHelper nopi = new NpoiExcelHelper();
DataTable table = nopi.ListToDataTable(list);
nopi.Write(table, "", "sheetName", strFieldsName, strFieldsTitle, "导出.xls");
public void Write(DataTable table, string headerText, string sheetName,
string[] columnName, string[] columnTitle, string fileName)
{
HttpContext context = HttpContext.Current;
context.Response.ContentType = "application/vnd.ms-excel";
context.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(fileName, Encoding.UTF8)));
context.Response.Clear();
HSSFWorkbook hssfworkbook = null;
hssfworkbook = GenerateData(table, headerText, sheetName,
columnName, columnTitle);
context.Response.BinaryWrite(WriteToStream(hssfworkbook).GetBuffer());
context.Response.End();
}
两份填充数据的代码都是一样的,调用的方法也是一样的.
