XLSX: read cell

Input data

Spreadsheet

Cell

Tab

Output data

Value

Description

The "XLSX: read cell" function allows reading a specific cell from an XLSX spreadsheet. This function takes the cell address and sheet tab as inputs and returns the value contained in the cell.

The value of the specified cell is returned as output. If there is any error in reading, the output value will be 0.

Input and Output Parameters

Inputs

Parameter
Default Units
Description
Spreadsheet
None
The XLSX file from which the cell value is read.
Cell
None
The address of the cell to be read (e.g., "A1").
Tab
None
The name of the sheet where the cell is located.

Output

Parameter
Default Units
Description
Value
None
The value contained in the specified cell.