ExcelReader Xojo Component |

# ExcelReader.Worksheet Class

Object that represents Excel worksheet.

Object
Worksheet

class ExcelReader.Worksheet

#### Properties

CellMergeInfoRecordCount | Returns count of CellMergeInfo records
DefaultRowHeight | Returns the default row height in the worksheet.
Name | Returns name of the worksheet.
Owner | Returns the owner which is workbook object of the worksheet.
PopulatedRowCount | Returns number of populated rows
TabColor | Returns color of the tab for the sheet.

#### Methods

Cell | Returns cell at given column and row index regardless if the cell is populated with data or not.
shared CellAddressToIndexes | Converts Excel style cell address like A2 to indexes like column = 0, row = 1
CellMergeInfoRecord | Returns CellMergeInfo record at given index. (zero based)
CellValue | Returns the Cell.Value for cell at column and row index.
Column | Returns instance of Column to get information about given column in the Excel sheet.
PopulatedRow | Returns populated row at given index.

#### Supported Platforms:

- macOS Carbon
- macOS Intel 32 bit
- macOS Intel 64 bit
- macOS Apple Silicon
- Windows 32 bit
- Windows 64 bit
- Windows ARM 64 bit
- Linux 32 bit
- Linux 64 bit
- Linux ARM 32 bit
- Linux ARM 64 bit
- iOS