Unable to convert MS Excel XLSX workbook to PDF format (CellsException)

Aspose.Cells Product Family
1

I have an issue converting the attached workbook from *.xlsx to pdf format.
There is an exception:
Aspose.Cells.CellsException
HResult=0x80131600
Message=Chart/Picture to image Error!
Source=Aspose.Cells

Code sample:
var wb = new Workbook(inputFile);
wb.Save(outputFile, SaveFormat.Pdf);

I use Aspose.Cells.dll 25.2.0.0.

I wasn’t able to upload the workbook due to file size limitations, so I broke the archive into tomes with 7zip (remove additional *.7z extension before de-archiving). If there is a better way, please tell me.
test8.zip.001.7z (5 MB)
test8.zip.002.7z (5 MB)
test8.zip.003.7z (5 MB)
test8.zip.004.7z (4.2 MB)

2

@licenses

It seems you are encountering a CellsException while trying to convert an XLSX workbook to PDF format using Aspose.Cells. The error message indicates an issue related to converting charts or pictures to images.

Here are a few steps you can take to troubleshoot and potentially resolve this issue:

  1. Update Aspose.Cells: Ensure you are using the latest version of Aspose.Cells. The version you mentioned (25.2.0.0) may have known issues that have been resolved in later releases. Check the Aspose.Cells releases page for the latest version and update your library accordingly.

  2. Check for Corrupted Elements: Sometimes, specific charts or images in the workbook can cause conversion issues. Open the workbook in Excel and check if there are any corrupted charts or images. Try removing or replacing them to see if that resolves the issue.

  3. Simplify the Workbook: If possible, create a simplified version of your workbook with fewer elements and see if the conversion works. This can help identify if a specific element is causing the problem.

  4. Error Handling: Implement error handling in your code to catch exceptions and log more details about the context in which the error occurs. This can provide more insight into what might be going wrong.

  5. Contact Support: If the issue persists after trying the above steps, consider reaching out to Aspose support with detailed information about your issue, including the specific version you are using, the code snippet, and any relevant details about the workbook.

Here is a sample code snippet for converting an XLSX file to PDF, which you can use as a reference:

var wb = new Workbook(inputFile);
wb.Save(outputFile, SaveFormat.Pdf);

Make sure to replace inputFile and outputFile with the actual paths to your files.

If you continue to experience issues, please provide more details about the specific elements in your workbook that might be causing the problem, and I can assist you further.

Sources:
[1]: Aspose.Cells for Java v22.12

3

@licenses,

I was unable to extract the Excel file from the zipped archives you provided. Please compress the Excel file in single archive again and upload it to a file sharing service (such as Google Drive, Dropbox, etc.), then share the download link here (make sure it doesn’t require any credentials). This way, we can access the file easily. After that, we will assess your issue and provide you with updates.

4

I was able to truncate the workbook while preserving the issue.
test10.zip (9.6 MB)

5

@licenses,

Thanks for providing us template Excel file.

After initial testing, I am able to reproduce the issue as you mentioned by converting your template Excel file to PDF. I found an exception “Chart/Picture to image Error” when rendering Excel file to PDF.

We require thorough evaluation of the issue. 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): CELLSNET-57860

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.

6

@licenses ,

The image at Row 218 is DIB file which can’t be displayed in Excel.
Screenshot_DIB.jpg (17.8 KB)

Does the image can be displayed right in Excel on your side?

Generally, a DIB file needs to be added with a BitmapFileHeader at the beginning to form a complete BMP file.

7

MS Excel has the same behavior on my side.

I presume the image was added in the wrong way, but it should not block the overall conversion of the workbook.
I have tried to export this document to PDF from MS Excel and there was no problem. The image is shown as an empty square.

8

@licenses,

Thanks for your feedback about MS Excel’ behavior on your end.

You’re correct. We will investigate and address the problem appropriately. We might either render an empty box (similar to MS Excel’s approach) for the image or provide a warning message regarding the unsupported image format.

9

@licenses ,

We will render an empty box (similar to MS Excel’s approach) for the image.

10

@licenses,

We are pleased to inform you that your issue (logged earlier as “CELLSNET-57860”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v25.3) scheduled for release first half of March (next month). You will be notified when the next version is published.

11

The issues you have found earlier (filed as CELLSNET-57860) have been fixed in this update. This message was posted using Bugs notification tool by leoluo