Load Source Excel File Without Charts

Load Spreadsheet Without Charts

The following sample code loads the sample excel file without charts and saves it in output PDF format.

from aspose.cells import LoadDataFilterOptions, LoadFilter, LoadOptions, SaveFormat, Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Specify the load options and filter the data
options = LoadOptions()
# Include everything except charts
options.load_filter = LoadFilter(LoadDataFilterOptions.ALL & ~LoadDataFilterOptions.CHART)
# Load the workbook with specified load options
workbook = Workbook(dataDir + "chart.xlsx", options)
# Save the workbook in PDF format
workbook.save(dataDir + "ResultWithoutChart.pdf", SaveFormat.PDF)