Microsoft Excel Automation in StudioX

[Mariam_Al_Ashwan]

Currently ,l am taking “Microsoft Excel Automation” course at ui path Acadamy ,and l am trying to follow the same steps in the vedio called"How to use pivot Activities" ,but when l reach step to use "for each excel row " activity l could not find the recent created sheet for pivot table

Kindly ,advise .

[Edwin_Barahona]

Hi @Mariam_Al_Ashwan ,

You need to provide a valid range, you may define it using this format

ReferenceName.Sheet("SheetName").Range("Excel_Range")

see the example below: