How to use Excel Read Range Activity in Modern design? Range & Save to parameters examples?

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
image

Excel.xaml (7.7 KB)

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:

  1. 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

@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.