xlsio to pdf

[Gimmy]

Buon giorno

Devo convertire un foglio XLS generato con le Vs. classi in un pdf.

Non riesco a generare il PDF in landscape.

Ottengo  SEMPRE il foglio excel in Landscape e il documento PDF in Portrait.

Mi potete aiutare ?

Questo è il mio codice:

///////////////////////////////

[...omissis...]

sheet.PageSetup.FitToPagesWide = 1;

sheet.PageSetup.FitToPagesTall = 1;

sheet.PageSetup.Orientation = ExcelPageOrientation.Landscape ;

XlsIORenderer renderer = new XlsIORenderer();

PdfDocument pdfDocument = new();

pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape;

pdfDocument = renderer.ConvertToPDF(sheet);

Stream stream = new FileStream("C:\TEMP\TEST.PDF", FileMode.Create, FileAccess.ReadWrite);

pdfDocument.Save(stream);

[... Omissis... ]

[Mohan Chandran]

Hi Gimmy, 

We have confirmed the issue as Exporting Excel to PDF in Landscape orientation is improper. We have logged a defect report for this issue and the fix will be included in our upcoming weekly NuGet release which will be available by October 26th, 2021. 

Regards, 

Mohan. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Gimmy, 

We appreciate your patience. 

We have included the fix for the issue Exporting Excel to PDF in Landscape orientation is improper in our weekly NuGet release version 19.3.0.47. The NuGet package can be downloaded from below link. 

https://www.nuget.org/packages/Syncfusion.XlsIORenderer.Net.Core/19.3.0.47  

Regards, 

Keerthi.