SaveAsByTemplate - Excel Dimension Xml is null

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)

https://www.nuget.org/packages/MiniExcel/

Apache License 2.0

2.78k stars 337 forks source link

SaveAsByTemplate - Excel Dimension Xml is null #459

Open BacelarIvanildo opened 1 year ago

BacelarIvanildo commented 1 year ago

Excel Type

[x] XLSX
[ ] XLSM
[ ] CSV
[ ] OTHER

MiniExcel Version: 1.30.0

Description:

I used the same example from the documentation, however the described ( Excel Dimension Xml is null )error occurs. The .net core version is 6.0

laboua commented 1 year ago

I have the same error "Excel Dimension Xml is null"

Paul-Wil commented 1 year ago

I have this issue if I use an xlsx file created with google sheets. It works if its saved with Excel. The reason is that the xml file is missing dimensions.

https://user-images.githubusercontent.com/12729184/114507911-5dd88400-9c66-11eb-94c6-82ed7bdb5aab.png

https://github.dev/mini-software/MiniExcel/blob/645a7cf87a4d3a6cf5d13526fa36579d160f692f/src/MiniExcel/OpenXml/ExcelOpenXmlTemplate.Impl.cs#L779