NPOI读取Excel模板并向其中写入数据

HSSFWorkbook hssfworkbookDown;

//读入刚复制的要导出的excel文件

using (FileStream file = new FileStream(modelExlPath, FileMode.Open, FileAccess.Read))

{

hssfworkbookDown = new HSSFWorkbook(file);

file.Close();

}

HSSFSheet sheet1 = (HSSFSheet)hssfworkbookDown.GetSheetAt(0);

//取模板excel中第二行第二列的单元格样式

HSSFCellStyle cellstyle = (HSSFCellStyle)hssfworkbookDown.CreateCellStyle();

//开始向excel表格中写入数据

HSSFCell cell = (HSSFCell)sheet1.GetRow(2).CreateCell(1);

cell.CellStyle = cellstyle;

cell.CellStyle.Alignment = NPOI.SS.UserModel.HorizontalAlignment.CENTER;

cell.SetCellValue("TestWriting");

//创建文件

FileStream files = new FileStream(downExlPath, FileMode.Create);

hssfworkbookDown.Write(files);

files.Close();