My data are not printing in excel

Learn
, ,
1

i have one excel sheet in which 10 links in one column.go one by one link and hit in browser and scrap text from that page and print in excel sheet…but here only last value is printing in my excel…
here is my codeMain.xaml (10.2 KB)

2

Use Merge Datatable to merge each set of scraped data into a master datatable. Then write the data outside of the loop.

Alternatively, you could use Append Range instead of Write Range, but I think this will be limited, since you’re targeting F1 as the starting cell, and this activity does not include an option to select the starting cell.

3

Hi,

As I can see, each time you are writing the value to “F1”. That is why in the end you have only last value.

If you want to record all scared text in one cell separated by e.g. coma, you can do the following:

image
image1454×756 30.9 KB

image
image1442×747 31.8 KB

4

hi …thanks for reply…i tried this one…but it not working

5

it only printing the last value

6

i dont want to print all scraped value in one cell.i want 1st should print in 1st cell next value in the next cell like this…plz help

7

it not working

8

Hello,

In write range activity, instead of “F1” please write the following:
“F” + (dttable.Rows.IndexOf(row)+1).ToString

Now robot will record data in the next row after each iteration :slight_smile:

1 Like
9

thank u so much …now it working