Hi,
Hi,
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET v8.2.0.2 and let us know your feedback.
I used the Aspose.Cells.dll version 8.2.0.2 as provided in the link. I was able to run the sample code without generating an error. Opening the newly created document I received the same “Excel found unreadable content” error.
Hi,
Thanks for your feedback and using Aspose.Cells.
We were able to replicate this issue after executing the following code using the latest version: Aspose.Cells
for .NET v8.2.0.2. The output file does not open fine and shows “Excel found unreadable content…” error.
But if we change the maximum rows to 100, then it works fine and generates correct file.
I have attached the output xlsx file which is corrupt and generated by the following code for a reference.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-42964 - “Excel found unreadable content…” error while generating Hyperlinks
VB.NET
Dim WORKBOOK As New Aspose.Cells.Workbook(FileFormatType.Xlsx)
Dim SHEET1 = WORKBOOK.Worksheets.Item(0)
Dim SHEET2 = WORKBOOK.Worksheets.Item(WORKBOOK.Worksheets.Add())
For ROWCTR = 0 To 1284
For COLCTR = 0 To 50
Call SHEET1.Hyperlinks.Add(SHEET1.Cells(ROWCTR, COLCTR).Name, 1, 1, “='” & SHEET2.Name & “'!” & SHEET2.Cells(ROWCTR, COLCTR).Name)
Call SHEET2.Hyperlinks.Add(SHEET2.Cells(ROWCTR, COLCTR).Name, 1, 1, “='” & SHEET1.Name & “'!” & SHEET1.Cells(ROWCTR, COLCTR).Name)
Next COLCTR
Next ROWCTR
WORKBOOK.Save(“Sample.xlsx”, Aspose.Cells.SaveFormat.Xlsx)
"using the following sample code"
Hi Don,
Thanks for your feedback and using Aspose.Cells.
We were able to reproduce this issue already and logged it in our database for a fix. Once, the issue is fixed or we have some other update for you, we will let you know asap.
Please refer to the above post: 570215.
Hi,
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET v8.2.0.3 and let us know your feedback.
The newest fix Aspose Cells for .NET v8.2.0.3 correctly throws an Aspose.Cells.CellsException with the message text “The count of Hyperlinks cannot be larger than 66530.” Thank you for this fix.
Hi,
The issues you have found earlier (filed as CELLSNET-42964;CELLSNET-42943) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Just want to let you all know that there is a typo in your error message. You say can’t have more than 66530 hyperlinks, when the real max is 65530 as you all stated earlier in this post
- CELLSNET-45370 - Exception Message is Wrong - The count of Hyperlinks cannot be larger than 66530
The issues you have found earlier (filed as CELLSNET-45370) have been fixed in Aspose.Cells for .NET 17.6.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.