A cell or a collection of cells in a worksheet is called Range and the various operations executed on the cells in rows and columns is called Range Operations.

In DsExcel Java, the getRange method in the IWorksheet interface enables users to perform range operations.

Using DsExcel Java, users can handle the following range operations:

• Access a Range
• Access Areas in a Range
• Access Cells, Rows and Columns in a Range
• Cut or Copy Cell Ranges
• Cut or Copy Shape, Slicer, Chart and Picture
• Find and Replace Data
• Get Row and Column Count
• Hide Rows and Columns
• Insert And Delete Cell Ranges
• Insert and Delete Rows and Columns
• Merge Cells
• Set Values to a Range
• Set Row Height and Column Width
• Auto Fit Row Height and Column Width
• Work with Used Range