Excel and DataScrapping

Help
1

Hello friends…need your help…
I have one excel file in local system which contains suppose 51 rows (including header) and 5-6 columns.On the other side I am extracting a table from web-page,the rows and columns in excel file are similar to data table table extracted from web,but their position may differ and in extracted data table.But my problem is, if a value(either Complete / Pending/Failed) in a cell occurs in Data table then corresponding to Row which matches with the excel file, need to be update in my excel file.

excelpic
excelpic529×717 28 KB
—Excel File extratPic ----Extracted Data table
excelpicfinal
excelpicfinal669×550 30.1 KB
– Based on status of Extracted Data table,final excel file should be updated like this – I hope you guys understood the question…

1 Like
2

Hi @monishankar

You can use lookup datatable activity buddy

  1. use excel application scope to read the excel and use read range activity and get the output datatable named exceldatatable
  2. Then extract the data from the web page and save the datatable with a variable named ExtractedDatatable
  3. then use a for each row loop like this which will update the datatable with column status, a value corresponding to the name you have

here pass the values like this in properties of lookup datatable activity

image
image1007×467 34.5 KB

For more info on lookup datatable activity kindly have view on this

kindly try this and let know buddy
Cheers @monishankar

1 Like
3

were you able to update now @monishankar

4

I am checking bro,if it works, I will let you know.

5

sure @monishankar

1 Like
6

It was very helpful bro… :grinning:

1 Like
7

Cheers buddy @monishankar

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.