Excel Automation for Shapes

excel
activities

#1

Hello, I would like to format a shape’s size (e.g rectangle) based on an array of excel values. When the for loop iterates through each row the shape of the rectangle should change. Can please advise how to do this in uipath ? Appreciate any guidance.


#2

Never done this, but will you be able to execute a macro inside the loop?

something like

ActiveSheet.Shapes("Rectangle 1")
        .Width = row("width").ToString()
        .Height = row("height").ToString()

#3

Thanks I think it’s a good idea. How do I incorporate this in uipath ? Should I use execute macro ? Appreciate any advise on how to call from uipath.


#4

Yes execute macro should work and you need to pass your width and height parameters to your excel macro.