Error read CellXfs about qtxlsxwriter HOT 11 CLOSED

Can you provide a simple code which shows this issue and the excel sheet or a stripped version of your xls?

from qtxlsxwriter.

Perhaps load the format class and (or) others?

#include "xlsxdocument.h"
#include "xlsxconditionalformatting.h"
#include "xlsxglobal.h"
#include "xlsxrichstring.h"
#include "xlsxworksheet.h"
#include "xlsxworkbook.h"
#include "xlsxcell.h"
#include "xlsxcellrange.h"
#include "xlsxformat.h"
#include "xlsxdatavalidation.h"

from qtxlsxwriter.

Hi,

Thanks for your reply !
No, even with all others includes, it's still failure.

Please find in attachment source code, xlsx file and reporting of the error.

Thanks in advance,
Lionel

2013/12/19 CCi-BClark [email protected]

Perhaps load the format class and (or) others?

#include "xlsxdocument.h"
#include "xlsxconditionalformatting.h"
#include "xlsxglobal.h"
#include "xlsxrichstring.h"
#include "xlsxworksheet.h"
#include "xlsxworkbook.h"
#include "xlsxcell.h"
#include "xlsxcellrange.h"
#include "xlsxformat.h"
#include "xlsxdatavalidation.h"

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/14#issuecomment-30965172
.

from qtxlsxwriter.

I don't believe you can attach files though here. I suggest post you code to a repo or with the ``` braces in your reply.

from qtxlsxwriter.

Hi, thanks for you feedback, you can send your .xlsx file to me directly through email.

from qtxlsxwriter.

I put all files to a dropbox link. Hope that it will work now.
https://www.dropbox.com/s/i8cxqlwtc7hhn5r/QtXlsxWriter.zip

Since else, have you thought about referencing your application(s) under http://inqlude.org/ ?
Just my 2 cents.

from qtxlsxwriter.

You open the sheet "Feuil1" with xlsx.setSheetName("Feuil1") and want to read from it.
But in your XLS there is no sheet with name Feuil1.
The function setSheetName renames the current sheet (Rename current worksheet to new name. Returns true if the name defined successful.)
I think, you want to select a sheet. It is done with setCurrentWorksheet("abc").

Is this correct?

from qtxlsxwriter.

Yes, that's correct (i tested with an another example, sorry for the bad example). I used the bad method to access the worksheet. Since setCurrentWorksheet has no return type, i thought the other one was much correct.

Warning messages at startup have misled me. But now, everything is perfect. Great, thank you !
One great feature would be to calc expression inside cells but it's already a very good library.

By then pass I wish you an happy end of year !

from qtxlsxwriter.

Hi, FYI, I just push a new commit to eliminate the warnings

9067bbf

Feel free to add a link to http://inqlude.org/, Thanks

from qtxlsxwriter.

Thanks ! OK for inqlude, i will do that new year !

from qtxlsxwriter.

Hi, FYI, I have marked both setSheetName() and setCurrentWorksheet() DEPRECATED in the dev branch. At the same time, new api renameWorksheet() and selectWorksheet() can be used in such cases instead.

from qtxlsxwriter.