WorkBook.Save goes endless

Aspose.Cells Product Family
1

I have atttached file which is an xls file, which we try to convert to PDFA 3B format,
For that we read the stream and store it in “DocumentMetaData.DestinationStream” in below code snapshot, But when we call workbook.Save, it is noted that it goes inside and never comes out even after 15 min. can you please let us know behaviour at your end 1) it si getting converted ? 2) how long it take for conversion (Exact time)??

image.png (16.9 KB)

image.png (30.0 KB)

989839_240613072628127_Tech Doc Matrix QA_SOAP_full rule set.zip (1.9 MB)

2

@Gayatri_Naik
There are 14.6k pages in the print view, so the pdf is large.
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-56660

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.

3

How to Check the Final Print count ??

4

@Gayatri_Naik
Please refer to the following code to check page count:

Workbook wb = new Workbook(filePath + "input.xlsx");

WorkbookRender render = new WorkbookRender(wb, new ImageOrPrintOptions());
Console.WriteLine(render.PageCount);
5

May i please know as of now how log it is taking at your end for conversion to 3 B format ??

6

@Gayatri_Naik,

The process (Excel to PDF) on our end is also consuming a significant amount of time. That’s why we logged a ticket (Ticket ID: “CELLSNET-56660”) for the issue to improve performance when exporting large XLS files to PDF. Please give us a little time, and we will evaluate the issue thoroughly and try to resolve the issue soon. Once we have an update, we will let you know.

7

Sure Noted Thanks

8

@Gayatri_Naik
Thank you for your feedback. You are welcome. Once there is an update, we will notify you promptly.

9

@Gayatri_Naik ,

The fastest way to get page cout is using WorkbookPrintingPreview.EvaluatedPageCount.
Code:

Workbook wb = new Workbook("989839_240613072628127_Tech Doc Matrix QA_SOAP_full rule set.xls");

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.AllColumnsInOnePagePerSheet = true;

WorkbookPrintingPreview workbookPrintingPreview = 
    new WorkbookPrintingPreview(wb, imgOptions);

Console.WriteLine(workbookPrintingPreview.EvaluatedPageCount);

Your source file has tons of pages, if you disable AllColumnsInOnePagePerSheet option, the total page count will be about 15k. It will cost significant time while converting such file to pdf.

The coversion takes about 10 minutes on our side with the following code by Aspose.Cells for .Net 24.9:

Workbook wb = new Workbook("989839_240613072628127_Tech Doc Matrix QA_SOAP_full rule set.xls");

PdfSaveOptions options = new PdfSaveOptions();
options.AllColumnsInOnePagePerSheet = true;
options.Compliance = PdfCompliance.PdfA3b;

wb.Save("output.pdf", options);

Also, you can track the conversion progress by PdfSaveOptions.PageSavingCallback: Track Document Conversion Progress|Documentation