加载文件流,并使用NPOI替换excel中的关键字。
代码:
#region 替换关键字
FileStream fs = null;
HSSFWorkbook workbook = null;
try
{
//加载可读可写文件流
fs = new FileStream(sourcefile, FileMode.Open, FileAccess.ReadWrite);
workbook = new HSSFWorkbook(fs);
fs.Close();
ISheet sheet = workbook.GetSheetAt(0);
IRow row = null;
ICell cell = null;
for (int i = sheet.FirstRowNum; i <= sheet.LastRowNum; i++)
{
row = sheet.GetRow(i);
for (int j = row.FirstCellNum; j < row.LastCellNum; j++)
{
cell = row.GetCell(j);
if (cell.StringCellValue == "<%=date%>") //<%=date%> 、