Convert Excel file to PDF format compatible with PDF/A-1a with Node.js via C++

Possible Usage Scenarios

PDF/A is a unique flavor of PDF designed for the long‑term preservation of documents. PDF/A is an ISO‑standardized version of the Portable Document Format (PDF) that embeds all fonts used in the document within the PDF file. PDF/A differs from PDF by prohibiting features such as font linking (as opposed to font embedding) and encryption. Aspose.Cells for Node.js via C++ enables you to save Excel files to PDF/A‑compliant PDF files (PDF/A‑1a, PDF/A‑1b, PDF/A‑2a, PDF/A‑2b, PDF/A‑2u, PDF/A‑3a, PDF/A‑2ab, and PDF/A‑3u are supported). This topic describes how to save an Excel workbook to a PDF/A‑compliant (PDF/A‑1a) PDF file.

Convert Excel file to PDF Format Compatible with PDF/A-1a

Developers may use the PdfSaveOptions class to set different attributes for the conversion. Setting various properties of the PdfSaveOptions class gives you control over the printing, font, security, and compression settings for the output PDF. The most important property is PdfSaveOptions.getCompliance() that enables you to save Excel files to PDF/A‑compliant PDF files.

The following sample code demonstrates how to convert an Excel file to PDF format compatible with PDF/A‑1a. Please see its output PDF as well as the screenshot for reference.

Screenshot

Sample Code

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const outputDir = path.join(__dirname, "output");

// Create workbook object
const wb = new AsposeCells.Workbook();

// Access first worksheet
const ws = wb.getWorksheets().get(0);

// Access cell B5 and add a message inside it
const cell = ws.getCells().get("B5");
cell.putValue("This PDF format is compatible with PDF/A-1a.");

// Create PDF save options and set its compliance to PDF/A-1a
const opts = new AsposeCells.PdfSaveOptions();
opts.setCompliance(AsposeCells.PdfCompliance.PdfA1a);

// Save the output PDF
wb.save(path.join(outputDir, "outputCompliancePdfA1a.pdf"), opts);