Excel - Data can't converted to PDF

Aspose.Cells Product Family
1

Hello



I have a Problem with a excel-data. When I convert this to a PDF the internal Memory usage increases very fast.



Hope you can help



I attach the file to the post

2

Hi Christian,


Thank you for contacting Aspose support.

It would be of great help in properly investigating the presented scenario if you can share details about your environment. Please share the following details along with the memory utilization logs.

  • Platform (.NET/Java/Android)
  • Aspose.Cells API version
  • Operating system version
  • Operating system architecture (32bit/64bit)
  • Target .NET Framework version (if platform is .NET)
  • JDK version (if platform is Java)
  • JDK type (if platform is Java)
  • Android API version (if platform is Android)
  • Your current code snippet for conversion process (preferably share a sample application)

Looking forward to your response.
3

Hi,


Thanks for the template file and some details.

After an initial test, I observed the issue as you mentioned. I found the memory increases all the time and a lot of time is taken when converting your template Excel file to PDF file format. I also noticed some worksheets have lots of unnecessary blank pages (some sheets have invalid formatting/borders etc.). For example, the second worksheet has thousands of blank pages in it. I also tried to remove blank rows/columns and also used MemoryPreference option but in vain. I have logged a ticket with an id “CELLSNET-43549” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.

4

Hi,


We have evaluated your issue further.
Well, for memory increase issue, it only costs about 300M on our end which is fine here.
For the conversion taking long time issue, well, there are 1048576 rows in the second sheet “Pipeline-Basisdaten”, but from row 50 to row 1048576, they are unneeded blank rows.This would surely cause two problems:
1) There are 13,444 pages in the sheet, this needs a lot of time while converting to PDF.
2) The PivotTable in sheet “Pipeline” needs a lot of time to calculate it.
So, it is good to remove row 50 to row 1048576 in sheet “Pipeline-Basisdaten”. Or set the print area of sheet “Pipeline-Basisdaten” and the source data of the pivot table in the sheet “Pipeline” to actual range.
e.g
Sample code:

Workbook wb = new Workbook(srcFile);
Cells cells = wb.Worksheets[“Pipeline-Basisdaten”].Cells;
cells.DeleteRows(50, cells.Rows.Count-50);

wb.Save(destFile.pdf);

And, please try the latest version/fix: Aspose.Cells for .NET v8.4.0.8

Hope, this helps you to figure your issue out now.

Thank you.

5

Yes you are right. This makes sense. Thanks for your help

6

Hi,


You are welcome. Good to know that your understand your issue. 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.