- Document Solutions Data Viewer Overview
- Key Features
- Getting Started
- User Interface
- Load File
- Resize Rows and Columns
- Cell Range Selection
- Tables
- Sorting and Filtering
- Grouping and Outlines
- Data Visualization
- Scroll Bars
- Notes
- Search Data
- Extract Data
- Keyboard Shortcuts
- Samples
- Client-side API Reference
- Release Notes
Tables
Tables organize the data in structured rows and columns, which makes managing and analyzing a group of related data easier. DsDataViewer supports the display of Tables in XLSX and SpreadJS (SSJSON and .sjs) files.
table
Managing Table Data
In spreadsheet documents, business data such as financial records, transaction details, sales data sheets, employee records, etc. are often stored in Tables. Regardless of the size or nature of these datasets, you may need to focus on specific data for your analysis. Sorting and filtering can make it easier to read, search, focus, and understand the data as needed.
With the Professional License, DsDataViewer supports interaction with the Tables and allows you to Sort, Filter, and Slice the data as needed using Sort & Filter button and Slicers.
The following GIF image illustrates the working of the Sort feature.
sorting-filter-dialog
The following GIF image illustrates the working of Filter feature.
filtering-filter-dialog
Note: In the XLSX or SpreadJS (SSJSON and .sjs) file, the filter icon appears in the header row of the selected Table. If Table does not have a header, then Filter icon shows no effect.
For information on sorting and filtering, see Sorting and Filtering.