Worksheets containing Charts only are not exported

[wolfgang.colsman]

Worksheets containing charts are not exported. Same is true for empty sheets.

Code: Select all

workbook = Workbook()
workbook.LoadFromFile(filename)
print(workbook.Worksheets.Count)
# Expected: 2
-> 1


[William.Zhang]

Hello,

Thanks for you inquiry.
Sorry, the document you uploaded is empty, please upload it again.

Sincerely,
William
E-iceblue support team

[wolfgang.colsman]

New file uploaded

[William.Zhang]

Hello,

Thanks for your file.
Kindly note that the sheet named "G(THF-H2O)" in your document is actually a Chartsheet. Unlike ordinary worksheets, a Chartsheet does not contain any cells or data. Its main function is to display charts. Our product will not count it in the total number of Worksheets. Sorry, our Spire.Xls for Python does not support getting the chart sheet in the Excle file yet. I have added this to our update list with ticket SPIREXLS-5319 and our deve team will further implement it. I will notify you as soon as it is implemented.

Sincerely,
William
E-iceblue support team

[wolfgang.colsman]

Can you provide an ETA? Thank you

[William.Zhang]

Hello,

Thank you for your follow-up.
Your issue has entered the testing phase. I will notify you as soon as the official version is available.

Sincerely,
William
E-iceblue support team

[wolfgang.colsman]

Thank you for the status update

[wolfgang.colsman]

Can you provide an ETA?

Sorry for pushing, this is impacting our production system.

Thank you

[William.Zhang]

Hello，

Thanks for your following up.
Sorry, this issue did not pass the test. We are re-adjusting the code. I will notify you as soon as the official version is available. Sorry for the inconvenience.

Sincerely,
William
E-iceblue support team

[wolfgang.colsman]

Any update please?

[William.Zhang]

Hello,

Thank you for your follow-up.
We plan to release a fix for your issue this month. I will notify you as soon as the official version is available.

Sincerely,
William
E-iceblue support team