Free Support Forum - aspose.com

Convert excel to pdf very slow

The attachment is the excel I am trying to convert to pdf. It will take about 3 minutes by the code below. Can we short this time by any other way?
test.zip (2.4 MB)

code:
public MemoryStream ConvertExcelToPdfMemory(string excelPath)
{
Workbook wb = new Workbook(excelPath);
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.AllColumnsInOnePagePerSheet = true;
pdfSaveOptions.CalculateFormula = true;
MemoryStream memoryStream = new MemoryStream();
wb.Worksheets[0].AutoFitRows(true);
wb.Save(memoryStream, pdfSaveOptions);
return memoryStream;
}

By the way, the version I am using is 17.6.0.0

@985664960,

Thanks for the template file and sample code.

Please try our latest version/fix: Aspose.Cells for .NET v19.11.5 (attached)

I have tested using your sample code and template file, it works and takes less than a minutes to render to PDF. By the way, the following lines (features) might be taking more time based on your huge data list:

pdfSaveOptions.AllColumnsInOnePagePerSheet = true;
wb.Worksheets[0].AutoFitRows(true);

Let us know your feedback.
Aspose.Cells19.11.5 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.11.5 For .Net4.0.Zip (5.0 MB)