How to use Excel Read Range Activity in Modern design? Range & Save to parameters examples? I couldn’t find any documentation for modern activities, please help.
use use excel file activity and specify file path
then inside, use read range
for range input
Excel.Sheet("Sheet1").Range("A1")
if your sheet = Sheet1 and table starts at A1
then in save to property use your datatable variable
Excel.xaml (7.7 KB)
10 Likes
Hello @Rohit_More
You can check the below video and the doc for getting more idea on the modern excel acitivties.
To read excel you can do as below:
- Use excel activity (seelct the excel to automate)
2)Read range activity (in the range field you click on the + button and select the sheet and the cells to read)
3)Output you will get as datatable
https://docs.uipath.com/activities/docs/excel-application-card
2 Likes
@jack.chan @Rahul_Unnikrishnan Thanks you for your help.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.