How to read Excel File cells value to UI Vision for process

Ui.Vision HowTo
1

Because RPA cannot automate import the excel file to local storage, I want to directly read Excel File cells values from C: to UI Vision for process. The content is
A B
1 101 VendorA
2 102 VendorB

I tried to use XRun to python script to get the result but I have no idea how to put the result as array to ui vision. The python script like this
"
import pandas as pd

df = pd.read_excel (r’C:\Users\Percy Fong\Desktop\Python\prog\Test.xlsx’)
print (df)
"
Do you have any solution help me finish the automation?

2

Excel can export the data to CSV format. And RPA can read and write CSV files:

I tried to use XRun to python script to get the result but I have no idea how to put the result as array to ui vision.

If you must read from native Excel files, then your idea with XRun and the Python script is good:

  • Use the Python script to convert XLSX files to CSV format,
  • …and then import the CSV data with the csvRead command.
1 Like
3

Have not sense to use excel, use csv it’s more easy and fast.