我已经使用C#和NPOI库编写了以下代码来编辑Excel文件。虽然没有错误,但在运行代码后,如果我打开文件,则单元格的值未被编辑。我错在哪里了?
namespace Project37
{
class Class1
{
public static void Main()
{
string pathSource = @"C:\Users\mvmurthy\Downloads\VOExportTemplate.xlsx";
FileStream fs = new FileStream(pathSource, FileMode.Open, FileAccess.ReadWrite);
HSSFWorkbook templateWorkbook = new HSSFWorkbook(fs, true);
HSSFSheet sheet = (HSSFSheet)templateWorkbook.GetSheet("ImportTemplate");
HSSFRow dataRow = (HSSFRow)sheet.GetRow(4);
dataRow.GetCell(1).SetCellValue("foo");
MemoryStream ms = new MemoryStream();
templateWorkbook.Write(ms);
}
}
}