Im getting "Index was outside the bounds of the array" in aspose cells

Aspose.Cells Product Family
1

Hi,

I need to convert aspose cells to PDF. I am using aspose cells V4.8.0.4.
And i am facing one issue with aspose cells while im saving a file to xlm file with fileformattype.asosepdf. Error Message: “Index was outside the bounds of the array.“
Herewith i have attached the sample file.

Dim xmlFile As String = designerFile & “.xml”
Dim wb As Aspose.Cells.Workbook = New Aspose.Cells.Workbook

If (designerFile.ToLower().EndsWith(”.xlsx”) = True) Then
wb.Open(designerFile, FileFormatType.Excel2007Xlsx, “”)
Else
wb.Open(designerFile)
End If
wb.Save(xmlFile, FileFormatType.AsposePdf) <== Error in this line
Dim pdf As Aspose.Pdf.Pdf = New Aspose.Pdf.Pdf
pdf.BindXML(xmlFile, Nothing)
pdf.Save(pdfFile)

Regards,
Karthik
2

Hi Karthik,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon.

Thank You & Best Regards,

3

Hi,

After further investigation, we found that in Workbook (“1325700000669.xlsx”)
WorkSheet [LGD SeeThru by SKU],

There is some very strange data exists behind 255 column, such as Cell(XEV56) etc., this data seems without meaning, and causes memory exception. These cells values are null but the background color are set.
So would you please remove this strange data or set print area to avoid printing such cells. We have tried this and then the template is converted to PDF format successfully. So, please try it.
And, we will still look into it and try to find some better way to support such large excel files.


Thank you.