Hello,
i am building app like below-
my requirement is to show excel data which i have in my local folder here in table in apps.
how can i achieve this?
is i need to do any upath process?
help me on same.
Hello,
i am building app like below-
my requirement is to show excel data which i have in my local folder here in table in apps.
how can i achieve this?
is i need to do any upath process?
help me on same.
Ideally you cannot display excel as is
you need to build a process to read the data and then send to apps as out argument datatable and then that datatable can be displayed
or same data needs to be added to data services and then it can be displayed
these are the two ways
cheers
Hello @Mathkar_kunal
You can do this by using 'start process" in (Page load) events of mainPage and assigning the Output to local app variable ( you can use the same process Output datatable as well)
Build a RPA workflow to read the excel file from local , in Arguments you can specify the
Output - Data table retrieved from excel.
In Event tab- call this process in ‘start process’ event and after that activity assign process.datatable to app variable datatable (create a app variable - dt_datatable)
For customization use dt_datatable or just use process.datatable.
( In the table control in app, in General tab
Add data source as dt_datatable and then add all required columns - change names or add or remove columns)
Hope it helps- Mark as solution if it does work.
To display data from a local Excel file in a UiPath App table, you do need a UiPath process. UiPath Apps cannot “browse” your local computer’s folders directly for security reasons; it needs a Robot to act as the bridge to read that file.
DataTable (e.g., out_dt_ExcelData)."C:\Users\YourName\Documents\Data.xlsx").out_dt_ExcelData argument.out_dt_ExcelData argument from your process.issue resolved thanks you