Error in Reading the xlsx file

Aspose.Cells Product Family
1

Hi Team,

We are using Workbook inputExcel= new Workbook(“path of xlsx file”) so add CustomDocumentProperties and save it. Please find the code snippet
com.aspose.cells.Workbook inputExcel= new Workbook(“path of xlsx file”);
inputExcel.getWorksheets().getCustomDocumentProperties().add(“sample”,“123”);
inputExcel.save(inputExcel.getFileName());

But, when are trying read this file we get exception mention below
java.lang.IllegalArgumentException: Invalid UTC time value: []. Required format: yyyy-MM-ddTHH:mm:ss with optional tailing ‘.S’ pattern and character ‘Z’

    at com.aspose.cells.a.a.zk.c(Unknown Source)

    at com.aspose.cells.a.a.zk.a(Unknown Source)

    at com.aspose.cells.zarh.b(Unknown Source)

    at com.aspose.cells.zarh.a(Unknown Source)

    at com.aspose.cells.ze.a(Unknown Source)

    at com.aspose.cells.ze.f(Unknown Source)

    at com.aspose.cells.ze.s(Unknown Source)

Please find the code snippet
com.aspose.cells.Workbook wb = new Workbook(“path of xlsx file”);

Please find attached file for reference.

Please help to check issue.

Note: Please don’t save the xlsx file manually. Otherwise you will not able to replicate issue.

Thanks
issue_sample.zip (2.1 MB)

2

@forasposeissues,
Thank you for providing the details and zipped archive. I attempted to extract the file(s) from the archive, but was unable to extract the Excel file. Based on the screenshot provided, it appears that either the zip file is corrupt or my zip tool (WinRar) does not support the encryption used in your archive.
sc_shot1.png (14.0 KB)

Although the folder was extracted, it was empty and did not contain the Excel file. Could you please re-zip the Excel file and attach it again so that I can extract it properly?

Thank you for your cooperation.

3

issue_sample1.zip (2.1 MB)

4

@forasposeissues,

We were able to reproduce the issue you mentioned by loading the XLSX template file. We encountered an exception “java.lang.IllegalArgumentException” while using the Aspose.Cells for Java API. It is possible that this issue is caused by a custom document property that you added, but we need to further evaluate it.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-45513

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@forasposeissues,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v23.8) that we plan to release in the first half of August 2023. You will be notified when the next version is released.

6

The issues you have found earlier (filed as CELLSJAVA-45513) have been fixed in Aspose.Cells for Java 23.8.