Question

C# 的NPOI导出的Excel乱码，版本是NPOI 2.2.0.0怎么办

我是直接给单元格一个字符串
T_Customer[] customer = T_CustomerBLL.GetAll();
HSSFWorkbook workbook = new HSSFWorkbook();
ISheet sheet = workbook.CreateSheet("客户信息(" + DateTime.Now.ToString("yyyy-MM-dd") + ")");
IRow headerRow = sheet.CreateRow(0);
/////直接填字符串

headerRow.CreateCell(0, CellType.String).SetCellValue("姓名");

Answer 1

Your problem is the mis-match of these two lines
XSSFWorkbook workbook = new XSSFWorkbook();

and
response.setContentType("application/vnd.ms-excel");

If you really want to generate a .xls older-style Excel workbook, you need to change the first line to be HSSFWorkbook rather than XSSFWorkbook
If you do mean to generate a .xlsx Excel workbook, then the content type on the second line needs to be the correct .xlsx one, which would be:
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

追问

不太懂