Product: Kryon RPA (Studio/Robot)

Product Version:19.1+

Components: Kryon Studio/Python

Article Status: Completed

Step1: Open CMD and navigate to folder where python installed inside Kryon Studio folder in my case it is >> C:Program FilesKryon StudioPython

Check Pic1

Step2: install "xlrd" package as follows

Note: if you are using python first time then it might ask you to upgrade first PIP then please do with following command:

python -m pip install --upgrade pip

Check Pic2

now type following command as follows:

python -m pip install xlrd

Check Pic3

This will installed excel handling library in python. In my case it is already installed ?

Step 3: inside Kryon Studio, use Run Script as follows and use following python script

#Python scripts starts here

# Program to extract a particular row value 

import xlrd 

loc = ("path of file") 

wb = xlrd.open_workbook(loc) 

sheet = wb.sheet_by_index(0) 

sheet.cell_value(0, 0) 

print(sheet.row_values(1)) 

#Python scripts ends here

 Check Pic4

 Check Pic5

Enjoy ?

Regards,

Zakir Khan