NPOI EXCEL创建

HSSFWorkbook hssfworkbook = new HSSFWorkbook();  ISheet sheet = hssfworkbook.CreateSheet("Sheet1");  hssfworkbook.CreateSheet("Sheet2");  hssfworkbook.CreateSheet("Sheet3");  //Title  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();