How to Loop Extract Table Many URL Insert data and create sheet excel

Help Studio
, ,
1

The image shows a sequence of actions in a workflow automation program, where an Excel file named "nameaddress.xlsx" is read, and for each row in "Sheet1" with headers, data is written into a file named "Report.xlsx". (Captioned by AI)
The image shows a sequence of actions in a workflow automation program, where an Excel file named "nameaddress.xlsx" is read, and for each row in "Sheet1" with headers, data is written into a file named "Report.xlsx". (Captioned by AI)715×814 25 KB

I’m have some question I want to Loop Extract table. Receive data to Var(extracttable)
1.first loop extract table from url save to var(excelextractable)
2.insert into for each excel row
But it’s loop can’t extract secound loop extract table url >>>> how to ???

2

Hi @ilizishible_Choa

Use Write Cell activity instead of Write Range Workbook activity

Regards,

3

@ilizishible_Choa,

Remove For Each Excel Row activity and only use Write Range activity. This will write all extracted rows to excel sheet in one go.

If your sheet would have existing data which you want to preserve and new data should be added below the existing rows, the use Append Range activity.

Thanks,
Ashok :slightly_smiling_face:

4

@ilizishible_Choa

Welcome to the community

if you are trying to append the data from different tables into same sheet

either use merge datatable and then use one single write

or use append range activity

cheers

5

Is there anyone who can make an example for me to look at? The need is to extract multiple URL tables and then have Excel create a Sheet in the same worksheet. Put the extract table from the Web into each created Sheet in a One By One format.