In Short, I start the conversion by doing this :
Aspose.Cells.PdfSaveOptions pdfSaveOptions = new Aspose.Cells.PdfSaveOptions();
pdfSaveOptions.Compliance = PdfCompliance.PdfA1b;
pdfSaveOptions.EmbedStandardWindowsFonts = true;
pdfSaveOptions.DefaultFont = “Arial”;
My excel workbook is then saved to pdf like this :
ReportAspose.Save(_AsposeExcel + ".pdf", pdfSaveOptions);
The Excel’s page setup is set as A3 Rotated, yet the PDF is always A4
How do I get the PDF to be the same page size as the XLS ?
(I have attached the XLS in question)
P2F_PlatHond.zip (213.4 KB)
Question 2 :
I have multiple macros in the XLS itself which I would like to run before I create the PDF. How do I do this ?