[]
Document Solutions Data Viewer
Ƭ XlsxOpenOptions: Object
Options to open the XLSX file.
Name | Type | Description |
---|---|---|
showHiddenSheets? |
boolean |
Optional. Whether to show the hidden and very hidden sheets in XLSX file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenSheets: true}); |
showHiddenRows? |
boolean |
Optional. Whether to show the hidden rows in XLSX file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenRows: true}); |
showHiddenColumns? |
boolean |
Optional. Whether to show the hidden columns in XLSX file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showHiddenColumns: true}); |
showFilters? |
boolean |
Optional. Whether to show the filters in XLSX file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {showFilters: false}); |
keepRowGroups? |
boolean |
Optional. Whether to show the row groups when loading a XLSX file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepRowGroups: false}); |
keepColumnGroups? |
boolean |
Optional. Whether to show the column groups when loading a XLSX file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {keepColumnGroups: false}); |
password? |
string |
Optional. For decrypting password-protected XLSX file. Example javascript viewer.openFile('Documents/HelloWorld.xlsx', FileType.XLSX, {password: "123"}); |
Ƭ SSJsonOpenOptions: Object
Options to open the SSJSON file.
Name | Type | Description |
---|---|---|
showHiddenSheets? |
boolean |
Optional. Whether to show the hidden and very hidden sheets in SSJSON file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {showHiddenSheets: true}); |
showHiddenRows? |
boolean |
Optional. Whether to show the hidden rows in SSJSON file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {showHiddenRows: true}); |
showHiddenColumns? |
boolean |
Optional. Whether to show the hidden columns in SSJSON file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {showHiddenColumns: true}); |
showFilters? |
boolean |
Optional. Whether to show the filters in SSJSON file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {showFilters: false}); |
keepRowGroups? |
boolean |
Optional. Whether to show the row groups when loading a SSJSON file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {keepRowGroups: false}); |
keepColumnGroups? |
boolean |
Optional. Whether to show the column groups when loading a SSJSON file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.ssjson', FileType.SSJSON, {keepColumnGroups: false}); |
Ƭ CsvOpenOptions: Object
Options to open the CSV file.
Name | Type | Description |
---|---|---|
columnSeparator? |
string |
Optional. Column separator for CSV file. The default value is ','. Example javascript viewer.openFile('Documents/HelloWorld.CSV', FileType.CSV, {columnSeparator: ','}); |
rowSeparator? |
string |
Optional. Row separator for CSV file. The default value is '\r\n'. Example javascript viewer.openFile('Documents/HelloWorld.CSV', FileType.CSV, {rowSeparator: '\r\n'}); |
encoding? |
string |
Optional. Encoding for CSV file. The default value is 'UTF-8'. Example javascript viewer.openFile('Documents/HelloWorld.CSV', FileType.CSV, {encoding: 'ANSI'}); |
columnHasHeader? |
boolean |
Optional. Whether the column data in the CSV file has a header. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.CSV', FileType.CSV, {columnHasHeader: false}); |
Ƭ SjsOpenOptions: Object
Options to open the SJS file.
Name | Type | Description |
---|---|---|
showHiddenSheets? |
boolean |
Optional. Whether to show the hidden and very hidden sheets in SJS file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {showHiddenSheets: true}); |
showHiddenRows? |
boolean |
Optional. Whether to show the hidden rows in SJS file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {showHiddenRows: true}); |
showHiddenColumns? |
boolean |
Optional. Whether to show the hidden columns in SJS file. The default value is false. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {showHiddenColumns: true}); |
showFilters? |
boolean |
Optional. Whether to show the filters in SJS file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {showFilters: false}); |
keepRowGroups? |
boolean |
Optional. Whether to show the row groups when loading a SJS file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {keepRowGroups: false}); |
keepColumnGroups? |
boolean |
Optional. Whether to show the column groups when loading a SJS file. The default value is true. Example javascript viewer.openFile('Documents/HelloWorld.sjs', FileType.SJS, {keepColumnGroups: false}); |
Ƭ DataToolbarLayout: Object
Describes the toolbar items layout (order and visibility) for different view modes. These items are available in the toolbar layout: open, zoom, fullscreen, theme-change, toggle-note, about.
Name | Type | Description |
---|---|---|
default? |
string [] |
Default (desktop) view mode. Also applied when other modes are not specified. Example javascript viewer.toolbarlayout.default |
fullscreen? |
string [] |
The layout for the full-screen mode. Example javascript viewer.toolbarlayout.fullscreen |
mobile? |
string [] |
The toolbar layout for mobile devices. Example javascript viewer.toolbarlayout.mobile |