/// <summary> /// 创建excel表头 /// </summary> /// <param name="dgv"></param> /// <param name="excelSheet"></param> protected static void CreateHeader(NPOI.SS.UserModel.ISheet excelSheet, HSSFWorkbook excelWorkbook) { int cellIndex = 0; NPOI.SS.UserModel.IRow row1 = excelSheet.CreateRow(0); NPOI.SS.UserModel.ICellStyle cellStyle = excelWorkbook.CreateCellStyle(); cellStyle.FillForegroundColor = NPOI.HSSF.Util.HSSFColor.WHITE.index; //cellStyle.FillPattern = HSSFCellStyle.SQUARES; cellStyle.FillBackgroundColor = NPOI.HSSF.Util.HSSFColor.BLACK.index; //循环导出列 foreach (System.Collections.DictionaryEntry de in _listColumnsName) { NPOI.SS.UserModel.ICell cell = row1.CreateCell(cellIndex); cell.CellStyle = cellStyle; string cellName = de.Value.ToString().Trim(); cell.SetCellValue(cellName); excelSheet.SetColumnWidth(cellIndex, 15 * 256); cellIndex++; } }