Hi there! I need to know how can a automate my bot to get the 30 columns from the row 2 and download on a file the pictures, wich are urls on this cells. How can I do this? Print screens ar more than wellcome. Thank you sm!
Use the Excel Application Scope activity to open your spreadsheet file.
Use the Read Cell Range activity to read the range containing the URLs. Set the range to the desired 30 columns in row 2 (e.g., “A2:AD2”). Store the result in a variable, let’s say urlArray.
Add a For Each activity and set the Type Argument to String to iterate over each URL in urlArray
The excel scope works no google sheets? I’m using the Gsuite package.
Should I put the variable at the left or right? if there is less than 30 pictures on the range and some cells are null, what do I do?
thank you!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
parvathi_ayanala
jamiejam
Anirudh_Tugawe