EMF vs PNG

Aspose.Cells Product Family
1

Please help with SheetRender / ImageOrPrintOptions exporting issues.

I need to be able to export a WorkSheet to an image that will be watermarked via an overlay of another image.

Option 1:ImageOrPrintOptions.ImageFormat = ImageFormat.Emf;

Quick and clear export to EMF, with low memory usage, but converting the EMF

to Bitmap to overlay the watermark image results in a blurred image. Not good enough to print.

Option 2: ImageOrPrintOptions.ImageFormat = ImageFormat.Png;

To get a decent image quality I need to set the [Horizontal/Vertical]Resolution = 250;

This makes the export slower, and uses a LOT of memory.

My application jumps to 1.2GB of memory usage when exporting a workbook with about 30 images.



Please run this through the attached sample application, and compare the memory usage between the 2 output formats. (You'll just need to add a folder called Images)


I cannot use a "using" clause around the SheetRender because it doesn't implement IDisposable.

There seems to be a memory leak.


So, is there a way to export an image (JPG, PNG, BMP) with the quality of EMF?


2

Hi,

Please try the latest version Aspose.Cells for .NET v7.1.0 and let us know your feedback.

3

Hi Shakeel


The problem still persists with the 7.0.1.0 dll

4

Hi,

Thanks for testing it with latest dll. I have logged this issue as CELLSNET-30603. We will update you asap.

5

Hi,

We have fixed this issue. Please download:
Aspose.Cells for .NET v7.0.1.1

6

I still receive the basically same results.

My memory usage dropped from 1.225GB to 1.178GB.

7

Good day,


Any feedback on the above?

Kind regards,
8

Hi,

I am afraid, there is no feedback as yet.

9

Hi,

Please download: Aspose.Cells for .NET v7.0.1.3

We have tested with current version and memory cost is not more than 80MB , Please check your system configuration.

10

The update download link seems to be dead.

11

armandsmit:
The update download link seems to be dead.

Third browser lucky.

12

Hi,

It’s good to know you were able to download it now. Let me know if you still having any problem.

13

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.