Skip to main content

What can we help you with?

Read Excel Cell

Ivan Kuznetsov
  • Updated

Description

Reads the value of a specified cell in an Excel document. The 'Save value to variable' activity appears automatically when choosing the 'Read Excel Cell' activity. It automatically saves the value to a variable. However, the activity is not mandatory to use and can be removed from the workflow.

Studio Pro supports Microsoft Excel .xls and .xlsx file formats.

 

As of the 8.3 update, there are two ways of interacting with MS Excel - Microsoft Native and Generic. Navigate to the menu "Settings"  → "Microsoft activities" to choose a method.

Microsoft Native uses standard Microsoft methods to interact with the Excel application. It requires Excel to be installed on your computer and extends the capabilities of interacting with all Excel functionalities.
Generic does not require Excel to be installed and may have some Excel functionalities limitations.

 

Parameters

Path

  1. Set a value: enables you to directly write the desired path. Clicking the 'Pick' button allows you to manually choose the path.

  2. Save the previous step result: chooses the last result activity as a path.

  3. Calculate a value: enables you to use available properties and methods to form a path.

     

Row number

Allows you to specify a row for the cell to read.‌

  1. Set a value: enables you to directly write the desired number of the row.

  2. Save the previous step result: chooses the last result activity as a number of the row.

  3. Calculate a value: enables you to use available properties and methods to form a number of the row.

     

Column number

Allows you to specify a column for the cell to read.‌

  1. Set a value: enables you to directly write the desired Excel column index of the column.

  2. Save the previous step result: chooses the previous activity result as Excel column index of the start column.

  3. Calculate a value: enables you to use available properties and methods to form Excel column index of the column.

     

Excel sheet name

By default, the first sheet in an Excel file is used.‌

  1. Set a value: enables you to directly specify the sheet name, for example, Employees.

  2. Save the previous step result: chooses the previous activity result as the sheet name.

  3. Calculate a value: enables you to use available properties and methods to form the sheet name.

     

Comment

Contains an annotation to the activity. The input text will be displayed above the activity name.

 

Result

The excel data is stored in the excel_cell_content variable by default. This variable represents one cell of the table.

For example, if we read the first row (1) and third column (C) we can get such a record:

 
"Value (1,3)"

Related articles