//添加列头
IRow dataRow = sheet.CreateRow(headStartIndex);
for (j = 0; j < data.Columns.Count; ++j)
{
dataRow.CreateCell(j).SetCellValue(data.Columns[j].ColumnName);
dataRow.GetCell(j).CellStyle = ColumnTitleStyle;
}
ICellStyle ColumnStyle = workbook.CreateCellStyle();
IFont ColumnFont = workbook.CreateFont();
ColumnFont.FontName = "宋体";
ColumnFont.FontHeightInPoints = 12;
ColumnStyle.SetFont(ColumnFont);
ColumnStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center; //居中对齐
ColumnStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
ColumnStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;