使用代码:
IWorkbook workbook;
using (FileStream file = new FileStream(textBox1.Text, FileMode.Open, FileAccess.Read))
{
workbook = new XSSFWorkbook(file);
}
ISheet sheet = workbook.GetSheetAt(0);
IRow r = sheet.GetRow(0) ?? sheet.CreateRow(0);
ICell c = r.GetCell(1) ?? r.CreateCell(1);
c.SetCellValue("TEST!!!!!!!!!!!");
using (FileStream file = new FileStream(textBox1.Text, FileMode.Open, FileAccess.Write))
{
workbook.Write(file);
workbook.Close();
}
修改后:
IWorkbook workbook;
using (FileStream file = new FileStream(textBox1.Text, FileMode.Open, FileAccess.Read))
{
workbook = new XSSFWorkbook(file);
}
ISheet sheet = workbook.GetSheetAt(0);
IRow r = sheet.GetRow(0) ?? sheet.CreateRow(0);
ICell c = r.GetCell(1) ?? r.CreateCell(1);
c.SetCellValue("TEST!!!!!!!!!!!");
FileStream file = File.Create(textBox1.Text);
workbook.Write(file);
workbook.Close();
file.Close();
疑问:
使用了修改后代码去编辑xlsx文件后,再去使用之前代码编辑xlsx,就不会有这个错误???