Data scrape and store in excel

Help
,
1

comany
comany1338Ɨ507 37.4 KB

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)

1 Like
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.

13

Hi, You can easily able to do it by data scrapping: Please check following video:

14

Excel overwrites the first page of data with the second etc. How can I stop this from happening? Is there a setting Iā€™m missing?