[]
type XlsxOpenOptions = object;
Options to open the XLSX file.
optional keepColumnGroups: boolean;
Optional. Whether to show the column groups when loading a XLSX file. The default value is true.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepColumnGroups: false});
optional keepRowGroups: boolean;
Optional. Whether to show the row groups when loading a XLSX file. The default value is true.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepRowGroups: false});
optional password: string;
Optional. For decrypting password-protected XLSX file.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {password: "123"});
optional showFilters: boolean;
Optional. Whether to show the filters in XLSX file. The default value is true.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showFilters: false});
optional showHiddenColumns: boolean;
Optional. Whether to show the hidden columns in XLSX file. The default value is false.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenColumns: true});
optional showHiddenRows: boolean;
Optional. Whether to show the hidden rows in XLSX file. The default value is false.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenRows: true});
optional showHiddenSheets: boolean;
Optional. Whether to show the hidden and very hidden sheets in XLSX file. The default value is false.
viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenSheets: true});