Unable to scrap table data in row wise format in excel sheet

excel
activities

#1

Hi there,

Can anybody please suggest me how to do it?
I am unable to scrap table data in row wise format in excel sheet. I am using excel application scope to write the scraped data. Is there ant better way to do this?

Regards,
Sasmita


#2

Hi @Sasmita,
You have two option to read the data form excel.
1.Read Range Activity from - File Work Book
2.Read Range Activity from - Excel - it should be in the excel application scope.

But the data should be in table format like

image

if possible can you share the excel sheet.

you can check this also

Regards
Balamurugan


#3

thanks for quick reply @balupad14,

I need to scrap tabular data from a particular website and need to write it in to the excel sheet.

what I did able to get is, the tabular format scraped data is getting written in a single cell of the excel sheet like i have shared the sheet.
Is it possible the tabular data to be scraped and written in different cells like i have mentioned in the shared the excel sheet.
Note: i have mentioned my comments in yellow background color in the attached excel sheet.
Demo_sheet.xlsx (8.8 KB)

Do you have any suggestions for me?

Regards,
Sasmita


#4

Hi @Sasmita,
Before write the excel , you have to split the data. After that you have to write the data into excel.

Below I have attached the code for split the string. It took a lot of time to write. Happy coding…
File : ExcelData.zip (1.8 KB)

It remembers the Level 3 certification Assignment 1.

Regards
Balamurugan


#5

Hi @balupad14,

Your help/support is much appreciated. it worked for me.
Thanks.

Regards,
Sasmita


#6

Hi All,
I am getting issue while trying to extract data from different URL in the same Attache Browser using for each row. I have kept some URLs in the excel sheet and trying to extract the details by browsing the URLs.
After extracting 1st URL’s details, It is showing error(UI element not found) and unable to extract the 2nd URL’s details. Any suggestion for me how I can get details from all the URLs I have in the list.

Thanks & Regards,
Sasmita


#7

Hi @Sasmita,
I know you are using the to Navigate with different url by the help of “Navigate to” activity. But My question is. each url is not having the same element in the web page. for example you have three url
1.Google
2.yahoo
3.hotmail.

Each url is having different elements in the web page.

Regards
Balamurugan


#8

Hi @balupad14,
I am using a web page, where different URLs are there having same element. For example, garments store website, the URLs of a particular.
Each URL from a same web page and having same elements. my concern is to enter each URL and get the garment details.

Thanks & Regards,
Sasmita


#9

Hi @Sasmita ,

Try to apply the following steps may fix your problem.
1.Read the excel into a datatable
2.Open browser wiht url “Google.com
3.Add foreach activity inside it.
4.Use the “Navigate to” activity apply the url from row(ColUrl).tostring.
5.Apply the selector element and get the information and store it.

So the steps 4 and 5 will be int the loop.

Regards
Balamurugan


#10

Hi @balupad14,
I have tried the same, but I was trying with type into activity. Let me try using “Navigate to”.
Thanks

Regards,
Sasmita


#11

Hello @balupad14,

I have a pdf file which is a scanned form where i have to extract the handwritten data. But I was unable to do so using Microsoft and Google OCR. I tried using Abbyy OCR but it wasn’t also able to extract the data that I needed.
Can you please suggest me Is there any other solution for this problem in UIPath??

Regards,
Sasmita