ExcelReader Xojo Component

ExcelReader.Worksheet Class

Object that represents Excel worksheet.

Object
   Worksheet

class ExcelReader.Worksheet

Properties

CellMergeInfoRecordCountReturns count of CellMergeInfo records
DefaultRowHeightReturns the default row height in the worksheet.
NameReturns name of the worksheet.
OwnerReturns the owner which is workbook object of the worksheet.
PopulatedRowCountReturns number of populated rows
TabColorReturns color of the tab for the sheet.

Methods

CellReturns cell at given column and row index regardless if the cell is populated with data or not.
shared CellAddressToIndexesConverts Excel style cell address like A2 to indexes like column = 0, row = 1
CellMergeInfoRecordReturns CellMergeInfo record at given index. (zero based)
CellValueReturns the Cell.Value for cell at column and row index.
ColumnReturns instance of Column to get information about given column in the Excel sheet.
PopulatedRowReturns 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