Load Source Excel File Without Charts with Node.js via C++
Contents
[
Hide
]
Aspose.Cells allows you to load your Excel file without charts. Please use LoadOptions.getLoadFilter() property for this purpose.
Load Spreadsheet Without Charts
The following sample code loads the sample Excel file without charts and saves it in output PDF format.
const path = require("path");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Specify the load options and filter the data
const options = new AsposeCells.LoadOptions();
// Include everything except charts
options.setLoadFilter(new AsposeCells.LoadFilter(AsposeCells.LoadDataFilterOptions.All & ~AsposeCells.LoadDataFilterOptions.Chart));
// Load the workbook with specified load options
const workbook = new AsposeCells.Workbook(path.join(dataDir, "chart.xlsx"), options);
// Save the workbook in PDF format
workbook.save(path.join(dataDir, "ResultWithoutChart.pdf"), AsposeCells.SaveFormat.Pdf);