Extract specific data/text value from webpage

Help Automation Hub
,
1

Hi All,

How to Extract specific data/text value from webpage, in one single page text i have to take only highlight text. Any suggestions please how can build the workflow.

Thanks in Advance,
Niranjan

2

Hi @Niranjan_k

Kindly Explain Input and expected output with Screenshot

Thanks
VP

3

@Vishnuraj_Pandiyarajan2 Thanks for your reply,
Input data from web im trying to copy format,
WebData
Output in same format i want in Excel, Please help me how can i extract from Webpage.

image
image686Ă—551 25.7 KB

Thanks & Regards,
Niranjan

4

@Niranjan_k

Have you tried with datascraping ?

Thanks
Varun

5

@varunk I tried using data scraping but data is selecting as like below image, but how do i extract same format to excel. Header will change as per sections.
WebData

Thanks,
Niranjan

6

Hi @Niranjan_k

Isn’t that the required format?. You want the formatting as well?

cheers

7

@Anil_G What ever format on web page they are looking in same format in Excel as well,
but im able to pull only data, I want same format as webpage in excel.

Thanks & Regards,
Niranjan

8

Hi @Niranjan_k

So try like this

  1. click on the first word on the top left in your first row
  2. Then immediately do a click down
  3. Then mouse hover to the last element in the table
  4. Then click up on the last element bottom right
  5. Use ctrl+c to copy
    6.Open a excel and use past from clip board or ctrl+v

A part of it I have made it. Please see the xaml. Idea is same implement it

For top left and bottom right use offset property
image

ExtractSampleDeathReturns.xaml (42.8 KB)

cheers

1 Like
9

@Niranjan_k

After extracting data using datascraping then entire data will be in datatable use write range activity provide the same datatable & check it will work

Thnaks
Varun

10

Hello @Niranjan_k

Have you tried using the Table extraction to extract the entire data from the Web page and then use a Write range to write to Excel.

Thanks

1 Like
11

@Anil_G Im getting “Document invalid” error message when im opening the file. can you resend me please.

12

@Rahul_Unnikrishnan Thanks for the video i will follow the steps.

13

Hi @niranjan.kummara

Here it is

BlankProcess5 - Copy (2).zip (15.7 KB)

cheers

1 Like
14

Hi @Niranjan_k

Step 1 : Use Screen scraping activity and the output will be stored in String format
Step 2 : Use Generate Data table activity to get the your String with expected Columns.

Thanks,
VP