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();