Read Cell

This activity helps the user to read and extract the data from the specified cell in
the provided input excel sheet. This activity works within the Excel scope activity.

Technical Reference

 

INPUT

Cell: Indicates to provide the “Cell” reference to read the data from it.

This parameter accepts values in the “String” datatype.

SheetName: Indicates to provide the  “SheetName” to read the data from the provided input excel worksheet. This parameter accepts values in the “String” datatype."

 

 

 

 

 

 

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the "Boolean" value as "True" or "False."

 

True: Continue executing the workflow regardless of any errors thrown.

False: Halt the workflow if it encounters any errors.

None: If the option is left blank, the activity will, by default, behave as if "False" were chosen.

Version: It indicates the version of the feature being used.

 

OUTPUT

Result: It provides the ability to view the execution status of the activity. It returns values in "Boolean."

 

True: Indicates that the activity has been executed successfully without any errors.

False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

Text: It helps to view the output of the activity as the extracted value from the specified cell in “String” value. It returns the values in “String” datatype. Refer the below example to declare the variable.

Represents mandatory fields to execute the workflow

 

Here’s an example of how “ReadCell” activity works –

In the following example, I am using the “Excel sheet” which is used to automate in
the Use case. To get a better understanding, click here.

This report encompasses employee particulars like Name, Position, Age, Office,
Start date, and Salary.

1.       Here, I am continuing from the “WriteRange” activity’s example.

2.       Now, placing the " ReadCell " activity within the scope activity.

a.       In this case, I am extracting the value from the cell by providing a random cell
reference from the excel sheet using this activity.

b.       Double click on the activity to provide the “Cell” value.

i.      Here I am providing the “Cell” reference as “B4”.

c.       Next, moving to “SheetName” and providing the value as “Report” in the box.

 

d.       Now, navigating to the “Text” in the properties to declare a variable to view
the extracted value.

i.      There are two ways to create a variable-

ii.      Method 1 – Click on the "Text" property within the "ReadCell" activity and enter
the variable name. In this case, we are using “CellValue." Then, press "Ctrl+Q,"
which is a shortcut key to create a variable.

 

iii.      Method 2 - Click on the Variables pane and enter the name " CellValue." Then,
in the "Variable Types" column, select "String" from the dropdown menu.

 

e.       Now add the “WriteLine” activity next to the “ReadCell” activity.

i.      Using this activity to view the text.

ii.      Here I am providing the value as “CellValue”.

3.       Now, execute the workflow.

Below is a sample of the output of the activity.