using NPOI.SS.UserModel
using NPOI.HSSF.UserModel
HSSFWorkbook hssfworkbook = new HSSFWorkbook()
ISheet sheet = hssfworkbook.CreateSheet("Sheet1")
hssfworkbook.CreateSheet("Sheet2")
hssfworkbook.CreateSheet("Sheet3")
IRow row = sheet.CreateRow(0)
ICell cell = row.CreateCell(0)
cell.SetCellValue(title)
// 设置单元格字体
ICellStyle style = hssfworkbook.CreateCellStyle()
style.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center
IFont font = hssfworkbook.CreateFont()
font.FontHeight = 20 * 20
style.SetFont(font)
cell.CellStyle = style
// 合并第0列到第4列的内容
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0,0,0,4))
FileStream</span> file = new FileStream(filePath, FileMode.Create);
hssfworkbook.Write(file);
file.Close();
NPOI.SS.Util.CellRangeAddress cellRangeAddress
cellRangeAddress = new CellRangeAddress(beginrow, endrow,begincell, endcell)
sheet.AddMergedRegion(cellRangeAddress)
((HSSFSheet)sheet).SetEnclosedBorderOfRegion(cellRangeAddress, NPOI.SS.UserModel.BorderStyle.Thin, 0)