Skip to content
This repository has been archived by the owner on Nov 24, 2020. It is now read-only.

Cannot "change" excel file #179

Open
astorDev opened this issue Aug 12, 2020 · 0 comments
Open

Cannot "change" excel file #179

astorDev opened this issue Aug 12, 2020 · 0 comments

Comments

@astorDev
Copy link

astorDev commented Aug 12, 2020

I created the file helloWorld.xlsx, filled first row with "Hello".
Then executed the following:

using (var file = File.Open($"helloWorld.xlsx", FileMode.Open, FileAccess.ReadWrite))
{
    var workbook = WorkbookFactory.Create(file);
    var sheet = workbook[0];
    var helloCell = sheet.GetRow(0).GetCell(0);
    Console.WriteLine(helloCell.StringCellValue);
    var row = sheet.CreateRow(1);
    var worldCell = row.CreateCell(0);
    worldCell.SetCellValue("World"
    workbook.Write(file);
}

So after the execution I expect file to have two filled cells filled with "Hello" and "World", but in reality it stays as it was before the execution (With "Hello" only)

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant