search

EPPlusSoftware / EPPlus

EPPlus-Excel spreadsheets for .NET
https://epplussoftware.com
Other
1.8k stars 274 forks source link

Incompatibility between QXlsx (Qt) and EPPlus? #328

Closed TwnKey closed 3 years ago

TwnKey commented 3 years ago

Hi, I've been working on a tool which decompiles the script files from a game in the form of XLSX spreadsheets. It is using the QXlsx library for Qt. The generated files can be read from QXlsx, as well as opened in Excel without incident.

A C# programmer wanted to use EPPlus library to read such a file, and most of the time (especially when the file is big), the reading fails (EPPlus gets stuck at the line "excel.Workbook.Worksheets["Sheet1"]").

Here, two examples: one which is working (EPPlus can read it) and one which is not working (stuck).

One thing to note is that when saving the broken file in Excel (without doing anything), EPPlus will then be able to read it.

I actually don't know if this problem concerns more EPPlus or QXlsx so I decided to start asking here.

JanKallman commented 3 years ago

This seems to be a bug when reading the worksheet xml in this specific case. I will provide a fix shortly so you can try on your other workbooks.

TwnKey commented 3 years ago

Hi, thank you very much for reacting quickly. I've tried it on all my sheets and it doesn't get stuck anymore now.

One of the problem I'm facing though is that it seems to be detecting the wrong number of rows. For example for this sheet: tk_sara.xlsx, "worksheet.Dimension.Rows" returns 6 (when there are 1826).

JanKallman commented 3 years ago

Fixed in version 5.6