NPOI讀取模版導(dǎo)出excel(合并單元格)

1、/生成excel表格/publicvoidOutPwd(System.Data.DataTabledtData,stringfileName,stringgetDate)trystringfilePath=AppDomain.CurrentDomain.BaseDirectory+MainPageDataServicePublicPublicExcelFileExcel+fileName+.xls;stringmodelPath=AppDomain.CurrentDomain.BaseDirectory+MainPageDataServicePublicPublicExcelModelExce

2、lJXCBGFWCModel.xls;#regionNPOI導(dǎo)出ExcelFileStreamfile=newFileStream(modelPath,FileMode.Open,FileAccess.Read);HSSFWorkbookhssfworkbook=newHSSFWorkbook(file);HSSFSheetsheet1=hssfworkbook.GetSheet(Sheet1);HSSFRowdr1=sheet1.CreateRow(0);HSSFCellcell=dr1.CreateCell(0);stringymd=getDate.Split(-);cell.SetCel

3、lValue(ymd0+年+ymd1+月+ymd2+日快消通進(jìn)銷存分析表);HSSFCellStylestyle=hssfworkbook.CreateCellStyle();style.Alignment=HSSFCellStyle.ALIGN_CENTER;HSSFFontfont=hssfworkbook.CreateFont();font.FontHeightInPoints=12;font.Color=HSSFColor.BLACK.index;font.FontHeight=20*20;font.Boldweight=HSSFFont.BOLDWEIGHT_BOLD;style.S

4、etFont(font);cell.CellStyle=style;for(inti=0;idtData.Rows.Count;i+)HSSFRowdr=sheet1.CreateRow(i+4);for(intj=0;jdtData.Columns.Count;j+)dr.CreateCell(j).SetCellValue(dtData.Rowsij.ToString()sheet1.ForceFormulaRecalculation=true;/合并for(intm=0;m2;m+)for(intn=4;ndtData.Rows.Count+3;n+)if(sheet1.GetRow(n

5、).GetCell(m).ToString()=sheet1.GetRow(n+1).GetCell(m).ToString()&!string.IsNullOrEmpty(sheet1.GetRow(n).GetCell(m).ToString()sheet1.AddMergedRegion(newRegion(n,m,n+1,m);elseif(sheet1.GetRow(n).GetCell(m).ToString()=sheet1.GetRow(n).GetCell(m+1).ToString()sheet1.AddMergedRegion(newRegion(n,m,n,m+1);s

6、heet1.AddMergedRegion(newRegion(dtData.Rows.Count+3,0,dtData.Rows.Count+3,3);/sheet1.AddMergedRegion(newRegion(0,0,0,5);file=newFileStream(filePath,FileMode.Create);hssfworkbook.Write(file);file.Close();if(!string.IsNullOrEmpty(fileUpPath)stringupPath=AppDomain.CurrentDomain.BaseDirectory+MainPageDataServicePublicPublicExcelFileExcel+fileUpPath+.xls;if(System.IO.File.Exists(upPath