npoi导出文件不保存在服务器,NPOI导出EXCEL报_服务器无法在发送 HTTP 标头之后追加标头...

///

///EXCEL帮助类

泛型类

泛型类集合

public class ExcelHelp where TCollection : List{static ExcelHelp instance = new ExcelHelp();//获取httpResponse对象原位置，放在这里不知道会报错：服务器无法在发送 HTTP 标头之后追加标头可能是这里拿到的httpResponse对象不是最新请求的对象导致的，将其放到方法内部即可HttpResponse baseResponse = HttpContext.Current.Response;

将数据导出EXCEL

键值对集合(键：列名，值：每列数据集合)

void ExportExcelData(Dictionary>columnNameAndShowNameDic)

{

IWorkbook workbook= newHSSFWorkbook();

ISheet worksheet= workbook.CreateSheet("sheet1");

List columnNameList =columnNameAndShowNameDic.Keys.ToList();设置首列显示

IRow row1 = worksheet.CreateRow(0);

ICell cell= null;

ICellStyle cellHeadStyle=workbook.CreateCellStyle();设置首行字体加粗

IFont font =workbook.CreateFont();

font.Boldweight= short.MaxValue;

cellHeadStyle.SetFont(font);for (var i = 0; i < columnNameList.Count; i++)

{

cell=row1.CreateCell(i);

cell.SetCellValue(columnNameList[i]);

cell.CellStyle=cellHeadStyle;

}var raws = columnNameAndShowNameDic[columnNameList[]].Count;int i = )

{int j = 0; j < raws; j++)

{if (i == )

{

row1= worksheet.CreateRow(j + 1);

}else{

row1= worksheet.GetRow(j + );

}

cell=row1.CreateCell(i);

cell.SetCellValue(columnNameAndShowNameDic[columnNameList[i]][j]);

}设置行宽度自适应

worksheet.AutoSizeColumn(i,true);worksheet.SetColumnWidth(i,columnWidth * 200);

}http请求Response对象-这里httpResponse对象要在方法内获取，否则可能会出现：无法再response发送表头后添加header的问题

HttpResponse baseResponse =HttpContext.Current.Response;

baseResponse.Clear();

baseResponse.Buffer= ;

baseResponse.ContentEncoding=System.Text.Encoding.UTF8;

baseResponse.ContentType= application/vnd.ms-excel;设置导出文件名

baseResponse.AppendHeader(content-disposition",attachment;filename=zhilian.xls);

MemoryStream ms= MemoryStream();

workbook.Write(ms);byte[] buffer =ms.ToArray();

baseResponse.AddHeader(Content-Length,buffer.Length.ToString());

baseResponse.BinaryWrite(buffer);

baseResponse.Flush();

baseResponse.End();

}

}