/// <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++;
}
}
