What is a Row? What is a Column?
Rows and columns are the structural units of every RadSpreadProcessing worksheet. Use this article to understand how rows and columns are identified, what sizing options they provide, and which related APIs help you work with them in code.
Row and Column Addressing
A worksheet organizes cells into rows and columns. Rows are groups of cells on the same horizontal line. Excel addresses rows from 1 through 1,048,576. The row and column indexes that the API uses are zero-based.
Columns are groups of cells stacked on the same vertical line. Excel addresses columns from A through XFD.
A cell sits at the intersection of one row and one column, and its address combines the column letter and row number. For example, B3 refers to the cell in column B, row 3. In the API, CellIndex(2, 1) refers to the same cell because the row and column indexes start at zero.
Row Height
Rows offer several approaches for determining their height:
| Option | Description |
|---|---|
| Default Height | Each row has a default height of 20. When the row does not have an explicitly set height, it appears with its default height. |
| Height | Allows you to make a given set of rows appear with a fixed height. |
| Auto Fit | Sets the height of a specific row based on the content of all cells in the row. The height is determined by the cell with the tallest content. |
Column Width
Columns offer several approaches for determining their width:
| Option | Description |
|---|---|
| Default Width | Each column has a default width of 65. When the column does not have an explicit width set, it appears with its default width. |
| Width | Allows you to make a given set of columns appear with a fixed width. |
| Auto Fit | Sets the width of a specified column based on the content of all cells in the column. The width is determined by the cell with the widest content. |
For more information about setting row height and column width, see Resizing Rows and Columns.