1. Feedback
  2. ASP.NET Core
  3. 47804

Welcome to the ASP.NET Core feedback portal. We’re happy you’re here! If you have feedback on how to improve the ASP.NET Core, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Error When Converting Excel to PDF With Images on Separate Sheets

Please see attached zip containing two files. An excel file to be converted to a PDF (01-Test-ToBeConverted.xlsx) and the resulting converted file (02-Test-Converted.pdf).

Please note that the excel file has two images: one on each sheet.

The PDF result correctly creates two pages but repeats the first image on the second sheet. The second image on sheet 2 is not created.

Code to recreate below.

IApplication application = excelEngine.Excel;

application.DefaultVersion = ExcelVersion.Xlsx;

IWorkbook workbook = application.Workbooks.Open(excelFile);

var renderer = new XlsIORenderer();

var settings = new XlsIORendererSettings();

settings.ExportQualityImage = false;

settings.EmbedFonts = true;

settings.PdfConformanceLevel = PdfConformanceLevel.Pdf_A1B;

var pdfDocument = renderer.ConvertToPDF(workbook, settings);

var memoryStream = new MemoryStream();

pdfDocument.Save(memoryStream);

memoryStream.Position = 0;

return memoryStream;