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
• Get Intersection, Union and Offset Range
• Access Areas in a Range
• Get Special Cell Ranges
• Access Cells, Rows and Columns in a Range
• Get Address of Cell Range
• Cut or Copy Cell Ranges
• Cut or Copy Shape, Slicer, Chart and Picture
• Paste or Ignore Data in Hidden Range
• 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
• Auto Merge Cells
• Protect Cell Range
• Set Values to a Range
• Set Custom Objects to a Range
• Set Row Height and Column Width
• Auto Fit Row Height and Column Width
• Work with Used Range
• Measure Digital Width
• Set Default Values for Cell Range
• Set Cell Background Image for Cell Range
• Ignore Errors in Cell Range