Range Operations

Range refers to a cell or a collection of cells and range operations are the operations performed on those cell collection using single line of code. The Range property of IWorksheet allows you to execute multiple operations on cells, rows or columns.

The operations that can be handled using Range property are as follows:

• Access a Range

• Access Areas in a Range

• 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 Skip 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

• 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 Cell Background Image for Cell Range

• Ignore ErrorsIn Cell Range