Error on convering excel(xls) to image(jpg)

GroupDocs.Total Product Family
1

Hi there,

I am testing with groupdocs-conversion-23.10.jar on JDK 1.8.
I am getting the below error on converting xls(and xlsb) to jpg.
seems like it doesn’t work for excel format for some reason.
does it requires some settings or extra libraries(e.g. JAI).
please advice.

Caused by: java.util.NoSuchElementException
at javax.imageio.spi.FilterIterator.next(ServiceRegistry.java:849)
at javax.imageio.ImageIO$ImageWriterIterator.next(ImageIO.java:842)
at javax.imageio.ImageIO$ImageWriterIterator.next(ImageIO.java:827)
at com.groupdocs.conversion.internal.c.a.c.n27.a(Unknown Source)
at com.groupdocs.conversion.internal.c.a.c.z4m.a(Unknown Source)
at com.groupdocs.conversion.internal.c.a.c.WorkbookRender.toImage(Unknown Source)
… 27 more

thanks,
James

2

@James.Sung

Could you please share the problematic Excel file and the sample code or application using that issue could be reproduced? Please also share details on your development environment.

3

Hi Atir,

Please download the test application via the link below:
download test app

Once you download please unzip the file and execute runTest.cmd from command line.

Thanks,
James Sung

4

@James.Sung
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): CONVERSIONJAVA-2138

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

The error message suggests that the GroupDocs Conversion library is unable to find an appropriate image writer for the JPG format. This could be due to a number of reasons, such as:

  • The library is missing the necessary dependencies, such as the Java Advanced Imaging (JAI) library.
  • The library is configured to use a different image writer that does not support the JPG format.
  • The image writer is not installed on the system.

To resolve this issue, you can try the following:

  1. Make sure that the GroupDocs Conversion library has all of the necessary dependencies installed. This includes the JAI library, which is required for converting Excel files to images.
  2. Check the configuration of the GroupDocs Conversion library to make sure that it is using an image writer that supports the JPG format.
  3. If the image writer is not installed on the system, you can install it using the package manager for your operating system.

If you are still having problems, you can contact the GroupDocs support team for assistance.

Here are some additional tips for troubleshooting this error:

  • Try converting the Excel file to a different image format, such as PNG or GIF. If this works, then the problem is likely related to the JPG format specifically.
  • Try converting the Excel file on a different system. If this works, then the problem may be related to the specific system configuration where you are running the GroupDocs Conversion library.
  • Check the GroupDocs Conversion documentation for more information about troubleshooting image conversion errors.

I hope this helps! Let me know if you have any other questions.

6

@allanmax

We are already investigating this issue.

7

Hi @atir.tahir
Any update? or ETA?
We need to upgrade the library to 23.10 ASAP as the version(19.4) we are currently using has many issues.

Thanks,
James

8

@James.Sung

This issue is still under investigation.

The workaround is to use Java 11 with GroupDocs.Conversion 23.10.