SpreadsheetLoadOptions class

SpreadsheetLoadOptions class

Options for loading Spreadsheet documents.

The SpreadsheetLoadOptions type exposes the following members:

Constructors

Constructor Description
init Initializes a new instance of SpreadsheetLoadOptions class.

Methods

Method Description
clone Clones current instance.

Properties

Property Description
all_columns_in_one_page_per_sheet The property determines whether all column content of a sheet is output to a single page.
auto_fit_rows The rows are autofitted when converting.
check_excel_restriction The property indicates whether to check Excel file restrictions when modifying cell-related objects.
clear_built_in_document_properties The flag indicating whether built-in document properties are cleared.
clear_custom_document_properties The ClearCustomDocumentProperties property indicates whether custom document properties are cleared when loading a spreadsheet.
columns_per_page The number of columns per page used to split a worksheet into pages. Default is 0, meaning no pagination.
convert_owned The property implements IDocumentsContainerLoadOptions.convert_owned.
convert_owner The ConvertOwner flag indicates whether the owner of the converted document is set.
convert_range The range to convert when converting to a format other than spreadsheet. Example: “D1:F8”.
culture_info The system culture info used when the file is loaded.
default_font The default font for a spreadsheet document, used when a font is missing.
depth The depth of the spreadsheet load options, implementing IDocumentsContainerLoadOptions.depth; default is 1.
font_substitutes The font substitutes used when converting a spreadsheet document.
format The input document file type.
ignore_formula_calculation_errors The property indicates whether to ignore formula calculation errors.
margin_settings The margin settings. See IPageMarginOptions for details.
one_page_per_sheet The content of the sheet is converted to a single PDF page when one_page_per_sheet is True; default is True.
optimize_pdf_size The conversion is optimized for better file size than print quality when set to True and converting to PDF.
password The password used to unprotect a protected document.
preserve_document_structure The property determines whether the document structure should be preserved when converting to PDF (default is False).
print_comments The way comments are printed with the sheet; default is PrintNoComments.
reset_font_folders The property resets font folders before loading a document.
rows_per_page The number of rows per page used to split a worksheet into pages; a value of 0 disables pagination.
sheet_indexes The list of sheet indexes to convert; the indexes must be zero-based.
sheets The sheet name to convert.
show_grid_lines The option to show grid lines when converting Excel files.
show_hidden_sheets The option to show hidden sheets when converting Excel files.
size_settings The size settings for the spreadsheet load operation.
skip_empty_rows_and_columns The property that skips empty rows and columns when converting; default is True.
skip_external_resources The property implements IResourceLoadingOptions.skip_external_resources.
skip_footers The property skips footers when converting spreadsheet documents. Default: False.
skip_headers The property indicates whether to skip headers when converting spreadsheet documents. Default: False.
whitelisted_resources The whitelisted resources for loading, implementing IResourceLoadingOptions.whitelisted_resources.

See Also