Type Alias: XltxOpenOptions

type XltxOpenOptions = object;

Options to open the XLTX file.

Properties

keepColumnGroups?

optional keepColumnGroups?: boolean;

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

Example

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

keepRowGroups?

optional keepRowGroups?: boolean;

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

Example

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

password?

optional password?: string;

Optional. For decrypting password-protected XLTX file.

Example

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

showFilters?

optional showFilters?: boolean;

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

Example

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

showHiddenColumns?

optional showHiddenColumns?: boolean;

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

Example

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

showHiddenRows?

optional showHiddenRows?: boolean;

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

Example

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

showHiddenSheets?

optional showHiddenSheets?: boolean;

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

Example

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