I need to save worksheets as PDF/A format. is that possible with Aspose.Cells? if not can I get the PDF converted to PDF A with Aspose.PDF?
Thank you for contacting Aspose support.
You may use the following piece of code to convert any spreadsheet to PDF format with PDF/A-1b compliance.
var book = new Workbook(myDir + “book1.xls”);
var saveOptions = new PdfSaveOptions(SaveFormat.Pdf);
saveOptions.Compliance = PdfCompliance.PdfA1b;
book.Save(myDir + “output.pdf”, saveOptions);