How to read data from an excel file?

In order to read data from an excel file, we make use of column name.

Lets say we have a sample excel file as shown below whose data you want to read.

If you want to read the username or country at a specific index we will use its column name.

To achieve this please follow the steps below:

Step 1: Load the excel file using loadexcel function.

Once you load an excel file all the data of the file is now present in the alias name.

Step 2: Define a variable and use getcellvalue function to get the data from the excel sheet using alias name defined in step one.

Here, 0th index data with column name Username will get read and stored in a variable defined in Element key. In the above snapshot variable name is OutputUsername.

After completing this step variable OutputUsername has value as Alan.

Similarly you can get the data of any column based on its column name and index.

Was this page helpful?