If anyone can help me I would really appreciate it. In this case, how do I make the routine read the elevation of each floor in the Excel spreadsheet and launch it automatically? I need you to read the value entered in the formula, which is 300 for each floor, or the final and individual value of each one, according to column B = ELEVATION
Hi @cintiamiranda21 is it something here you are after
1 Like
This solution is perfect. However, I want you to actually search the spreadsheet, as it will be the basis for other routines, so we would only have to fill it in once, for several routines. But after the routine is ready to perform the desired function, I am unable to change it and make it search directly from the Excel spreadsheet.
1 Like
arhhh guess i misunderstand
1 Like
Looks like you need to remove the @L2 level on the ByColumn input.
Moving to the OpenXML nodes instead is advisable.