Convert an Excel worksheet to JPG - DPI problem

Aspose.Cells Product Family
1

Hi,

we want to use Aspose.Cells to convert Excel worksheets to JPG images. The conversion works, but when we try to set the desired dpi value for the converted images (in the ImageOrPrintOptions), this value is ignored. So the images habe the dpi value of 96 dpi.
How can we convert the worksheets to JPGs in another quality / dpi value?

I hope you can help me here!

Best regards,
Alexander

2

Hi Alexander,


Thank you for bringing this issue to our knowledge.

We are able to replicate the issue while using the latest version of Aspose.Cells for Java 8.1.0.3. It seems that setting the vertical and/or horizontal resolution for the resultant Jpeg image does not take effect when spreadsheets are rendered to image format. We have logged this problem in our bug tracking system under the ticket CELLSJAVA-40878.

Please spare us little time to properly analyze the problem cause, and to provide a fix at earliest possible. In the meanwhile, we will keep you posted with updates in this regard.

Reference Java Code:

Workbook book = new Workbook(myDir + “sample.xlsx”);
Worksheet sheet = book.getWorksheets().get(0);
ImageOrPrintOptions saveOptions = new ImageOrPrintOptions();
saveOptions.setImageFormat(ImageFormat.getJpeg());
saveOptions.setHorizontalResolution(300);
saveOptions.setVerticalResolution(300);
SheetRender renderer = new SheetRender(sheet, saveOptions);
renderer.toImage(0, myDir + “output.jpeg”);


3

Hi,

are there any news regarding this issue?
We would like to use Aspose to convert Excel sheets, but it doesn’t make much sense if we can only convert with 96 dpi …

Regards,
Alexander

4

Hi Alexander,


Unfortunately, we have yet received any updates in this regard. However, we have raised your concerns to the concerned development team members, and requested them to share the insight of this problem, and possibly an estimated release schedule for the fix. As soon as some news comes in, we will post here for your kind reference.
5

Hi Alexander,


Just to bring in your knowledge that the issue logged earlier as CELLSJAVA-40878 will be fixed with next revision of Aspose.Cells for Java. We haven’t yet scheduled the said release, however, as soon as the next release is available for public use, we will notify you here.
6

Hi,


Please try our latest version/fix: Aspose.Cells for Java v8.1.1.3 (attached).

We have fixed your issue now.

Let us know your feedback.

Thank you.
7

Hi,

thanks for the fix, it is working now! :slight_smile:

Regards,
Alexander

8

Hi,


Thanks for your feedback.

Good to know that your issue is resolved by the new version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.
9

The issues you have found earlier (filed as CELLSJAVA-40878) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.