Data scrape and store in excel

studio
datascraping

#1

From the above website i needs to do data scrap list company starts from A and from B than store in excel file can anyone help me


#2

Hi @indra

1.> Please use Data Scrapping to get the entire table rows and columns.

Output will be a variable whose type would be data table.

2.> Later using for each row activity for Data Table ,iterate through the data type variable and store the company name’s in an array variable .

3.> Later using excel application scope save all the country names in the excel file.

4.> Later you can simply sort the Company Names.

Warm Regards,


#3

I can data scrap only list A and stored in data table but list B cannot scrap


#4

Hello @indra can you tell us what kind of error you are receiving…
I have tested working fine for me


#5

can you share the file you have tested


#6

I am sorry on office desktop cant share file…
just make sure selector is correct…
I am using this - < html title='Stock Starting with ‘* ’, List of Companies Stock Starting with ‘* ’ />
-remove extra space after asterisk (* ) [added space cause (* ) was not showing in preview section]


#7

Hi akshay can u please tell how to scrap compnay A and company B


#8

Hi prassin6 can u please tell how to scrap compnay A and company B


#9

Hello @indra I was busy with office work that is why I didnt replied you earlier…
try attached xaml Main.xaml (11.4 KB)


#10

Thank you @AkshaySandhu for sharing but my task is to scrap two comany name that is only 10 companies in same time and stored in excel file with different columns can you please help


#11

Hello @indra When you use data scraping and try to scrap the table data , you will get a prompt

Is the data spanning over multiple pages” -> There select yes.

It will select all the tables from each of the page from A-Z.


#12

Yes