We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel to PDF specify PDF version to save Workbook

I am attempting to set up a routine that opens excel and save it as a PDF. I am new to Aspose.Cells and want to specify the PDF version we are exporting the workbook too.

The code belows saves the workbook to PDF 1.4. How do i get this document to save as PDF version 1.7.

using (Workbook workbook = new Workbook(tmpFc.TheFile))
{
// Set Up Save Options
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
// Page Per Sheet
pdfSaveOptions.OnePagePerSheet = true;

// Save the workbook to PDF format
workbook.Save(tmpFc.PDFFileName, pdfSaveOptions);
}

SaveFormat only has the option to specifiy I’m saving as a PDF not which version.

Any help you can provide is greatly appreciated!

Thanks

@david_j_meyer2_boeing_com,

Aspose.Cells generates document in PDF version 1.4 (Acrobat 5.x) by default so you cannot set or change it by the APIs. It does not support to render Excel spreadsheets to PDF file version 1.7.

Would the only solution be to then open the document again with Aspose.PDF save it to version 1.7? Are there plans to upgrade Aspose.Cells to support saving to the current version of PDF 1.7?

Thanks again for being so responsive to my question.

@david_j_meyer2_boeing_com,

Yes, you may manipulate the version using Aspose.PDF API for your needs.