erueur when use Qxlnt libray

[ChrisW67]

@Teyeb23 This is not a library that is part of Qt.

You have a corrupt XLSX file or a file that qxlnt/xlnt cannot handle. If the file exists, is valid, and only uses supported features then you should approach either Qxlnt or Xlnt projects for assistance.

[piervalli]

@Teyeb23
Have you open the file with Libre office?

[Teyeb23]

@piervalli the file is open but in version repair
My goal to edit the xlsx file using Qxlnt without coruped the file

[JonB]

@Teyeb23 said in erueur when use Qxlnt libray:

@piervalli the file is open but in version repair

What does this mean? If the file is corrupted/needs repairing you must do that first, like @ChrisW67 said your library is not going to that.

[Teyeb23]

@JonB when repared the file l fine the modification is add in the file successfully
Waht the probleme for corupted the file
So but the libray Qxlnt for manipulation of Xlsx file

[ChrisW67]

@Teyeb23 How can we know how your modified file has become corrupt? We cannot see it, how it started, or what you tried to do to it. An XLSX file is just a zipped up collection of other files, perhaps you can start by verifying the zip file integrity.

[piervalli]

@Teyeb23
First start with empty sheets and write a cell.
Is it corrupted?

[Teyeb23]

@piervalli why we start with the sheet empty

[piervalli]

@Teyeb23
Because sheets should be complex with complex formula chart etc...
If you start with easy file you can test the library.

[SimonSchroeder]

I have use xlnt (which Qxlnt is based on) before. What I found is that when you enter an equation and then pull it over several cells xlnt is not able to open that file anymore. There is a fix which hasn't been released yet (last time I checked) which will not crash when you try to open the file, but will corrupt it if you write back to it. So, unless every cell has been entered individually (or imported), don't use Qxlnt/xlnt to work with Excel files. Or help improve the library.