How to use argument in the before mentioned questions

Help Studio
, ,
1

Navigate to the sheet which was given in input argument and read the data over there (datatable)

2

Hello @Ojaswa_Pandey_18_BEC_031

You can sue Read Range activity and provide the sheetname variable in the property of the activity.

image

Thanks

3

But there are 4 sheets in the workbook and the data I need is of the sheet which is given in the input argument. How to use the concept of argument in this?

Thanks

4

Eventhough if there are multiple sheets in the excel, whatever the sheetname that you are providing it will read only that sheet.

If you want to pass an argument and do this process, then create a workflow and create an IN argument. Pass the sheetname to that argument and then use that argument in the Read Range activity.

image
image784×454 14.8 KB

image

Thanks

5

What activities should I use in the invoke workflow file?

6

@Ojaswa_Pandey_18_BEC_031

You just need to create a variable or argument for sheetname and instead of the name use the argument or the variable in the read range sheet name property

Cheers

7

You can create 2 workflow. for example Main.xaml and sequence1.xaml.

In the Main.xaml, use invoke workflow file activity and call sequence1.xaml.
In sequence1.xaml, you need to create an IN argument with name “SheetName”
Then open the sequence1.xaml and add a read range activity and pass that argument (SheetName) to the property.

Thanks

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.