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)