When you have extensive amount of data in spreadsheets, it becomes difficult to process relevant information for business management, analytics and data visualization.
DsExcel Java allows you to summarize bulk data in groups so that complex spreadsheets are easier to read, navigate, and manipulate. Each group in DsExcel Java is distinguished with a group header row next to it which can be used to display or hide information as and when required. In order to expand a group to display rows and columns that have been hidden, you can set the setShowDetail method of the IRange Interface to boolean true and in order to collapse the expanded rows or columns,you can set the setShowDetail method of the IRange Interface to boolean false.
Applying grouping in a spreadsheet involves the following tasks:
