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
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’)
Do you have any solution help me finish the automation?