Hi there
When I open an existing xls and then just save it back out, it loses all the column, row sizes that have been set in the spreadsheet. It defaults back to default cell sizes.
Workbook excel = new Workbook();
excel.LoadData(@"C:\ParsingTestFiles\Export.xls");
excel.Save(@"C:\ParsingTestFiles\Export_New.xls");
I need to edit the format styles of this doc but I need to retain the sizes that were set by our data team. We've just updated our license so I hope we can find a resolution.
Kind Regards
Chris