Type Alias: XlsxOpenOptions

type XlsxOpenOptions = object;

Options to open the XLSX file.

Properties

keepColumnGroups?

optional keepColumnGroups?: boolean;

Optional. Whether to show the column groups when loading a XLSX file. The default value is true.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepColumnGroups: false});

keepRowGroups?

optional keepRowGroups?: boolean;

Optional. Whether to show the row groups when loading a XLSX file. The default value is true.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepRowGroups: false});

password?

optional password?: string;

Optional. For decrypting password-protected XLSX file.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {password: "123"});

showFilters?

optional showFilters?: boolean;

Optional. Whether to show the filters in XLSX file. The default value is true.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showFilters: false});

showHiddenColumns?

optional showHiddenColumns?: boolean;

Optional. Whether to show the hidden columns in XLSX file. The default value is false.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenColumns: true});

showHiddenRows?

optional showHiddenRows?: boolean;

Optional. Whether to show the hidden rows in XLSX file. The default value is false.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenRows: true});

showHiddenSheets?

optional showHiddenSheets?: boolean;

Optional. Whether to show the hidden and very hidden sheets in XLSX file. The default value is false.

Example

viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenSheets: true});