NPOI导出Excel文件，对单元格的一些设置

HSSFWorkbook book = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
ISheet sheet = book.CreateSheet("sheet1");
ICellStyle cellStyle = book.CreateCellStyle();

// 首列
NPOI.SS.UserModel.IRow row1 = sheet.CreateRow(0);
row1.CreateCell(0).SetCellValue(System.DateTime.Now.Year+"年XXXX");
//设置单元格的样式：水平对齐居中
row1.Cells[0].CellStyle.VerticalAlignment = VerticalAlignment.Justify;//垂直对齐(默认应该为center，如果center无效则用justify)
row1.Cells[0].CellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;//水平对齐
CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 0, 0, 8);//开始行的索引,结束行的索引,开始列的索引,结束列的索引

sheet.AddMergedRegion(cellRangeAddress);//要合并单元格所在的sheet

参考网址：http://www.jb51.net/article/36002.htm

  NPOI.SS.UserModel.IRow row = sheet.CreateRow(1);
            row.CreateCell(0).SetCellValue("序号");
            row.CreateCell(1).SetCellValue("单位");
            row.CreateCell(2).SetCellValue("姓名");
            row.CreateCell(3).SetCellValue("性别");
            row.CreateCell(4).SetCellValue("年龄");
            row.CreateCell(5).SetCellValue("民族");
            row.CreateCell(6).SetCellValue("培训班名称");
            row.CreateCell(7).SetCellValue("电报号");
            row.CreateCell(8).SetCellValue("培训时间");
            sheet.SetColumnWidth(1, 30 * 256);//设置列宽
            sheet.SetColumnWidth(6, 30*256);
            sheet.SetColumnWidth(7, 30 * 256);
            sheet.SetColumnWidth(8, 50*256);

参考网址：http://www.jb51.net/article/55407.htm