Thanks for your patience.
We have fixed the issue Exception throws while ExcelToPDF conversion on creating PivotTable only with Row Fields and generated patch in the version v220.127.116.11.
We suggest you to use the patch with following code snippet.
using (ExcelEngine excelEngine = new ExcelEngine())
IApplication application = excelEngine.Excel;
//Set the default application version
application.DefaultVersion = ExcelVersion.Excel2013;
//Load the existing Excel docuemnt into IWorkbook
IWorkbook workbook = application.Workbooks.Open(Server.MapPath("App_Data/result.xlsx"), ExcelOpenType.Automatic);
ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
//Initialize ExcelToPdfConverterSettings and disable the gridlines
ExcelToPdfConverterSettings converterSettings = new ExcelToPdfConverterSettings();
converterSettings.DisplayGridLines = GridLinesDisplayStyle.Invisible;
//Initialize PDF document
PdfDocument pdfDocument = new PdfDocument();
//Convert Excel document into PDF document
pdfDocument = converter.Convert(converterSettings);
//Open the document in browser after saving it
pdfDocument.Save("Output.pdf", HttpContext.ApplicationInstance.Response, HttpReadType.Save);
The patch with fix to resolve the reported issue can be downloaded from the following link.
Recommended approach - exe will perform automatic configuration
Please find the patch setup from below location:
Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment
Please find the patch assemblies alone from below location:
Assembly Version: 18.104.22.168
Installation Directions :
This patch should replace the files “Syncfusion.XlsIO.Base.dll” under the following folder.
$system drive:\ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.6
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\22.214.171.124\precompiledassemblies\126.96.36.199\4.6
To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.
You can change how you receive bug fixes by navigating to the following link and updating your preferences.
Please note that we have created this patch for version 188.8.131.52 specifically to resolve the issues reported in forum 150841.
If you have received other patches for the same version for other products, please apply all patches in the order received.
This fix will be included in our release version 18.1 which will be rolled out by end of March 2020.