Get Cell Value

Reads a value from an excel sheet cell.

Excel to Datatable designer

Properties#

Excel to Datatable properties

Input#

  1. File Path Path to csv or xls/xlsx file.
  2. Column Name The name of the column where to find the cell.
  3. Row Index The index of the row from where to read the value from cell.
  4. Sheet Name The name of the sheet from where to read the cell. It can be left blank if we want to load data from first sheet.

General Properties#

See General Properties.

Misc#

See Misc.

Out Error#

See Out Error.

Result#

  1. Cell Value The value read from the cell.