How to add extracted data to an excel sheet?

Help Activities
1

Hi,

I’m extracting data from an website for each code number (undefined number of results will be found), inside for each activity im using another for each activity to loop through each headline(results found) to extract table.

for example: im extracting headline(using get text activity) along with that im extracting table with multiple columns(Using Table extraction)…

So the bot has to create an excel sheet , create sheet with first iteration code and add headline with extracted table. and repeat the same for all headlines and columns.

then create next sheet for next iteration.

How can i achieve this?

2

@geetanjali.nerlekar

Use a index in for loop to create your your sheets…as index changes for each loop the sheetname will be unique

cheers

3

@geetanjali.nerlekar

You can aslo pass the

text value which is dyanamic like headline

Cheers
or

Follow the steps which is mentioned in the fisrt reply