Data not getting extracted to excel after scraping

[irfan.mansoori]

Hi Team,

I am trying to scrape data from a website however, the excel is not getting updated with the scraped data. Im only getting sheet after running the process. Request your update on the same.

[nv08 (Nilay Varshney)]

hey @irfan.mansoori
use breakpoint before writing to excel and check if the data is coming to datatable variable
if not check with the data scrapping process once.

[irfan.mansoori]

Hi Nilay,

thank you for your reply… but actually i dont know how to use breakpoint… Issue is even i have tried with other sites scraping, however, excel is not able to capture the data… im doubtful if im using the sequences properly. Please suggest.

[nv08 (Nilay Varshney)]

can you post your workflow here

[rajanrao1 (Rajan)]

try to debug the code step by step and check the data in output panel for data table variable
use f11 to debug 1 by 1 or right click on the write excel activity select toggle breakpoints and the click on the debug bot will stop at the write excel activity after extraction.
then you can check the data table variable

[irfan.mansoori]

[nv08 (Nilay Varshney)]

not like this.
Upload the .xaml file of your workflow.

[NIVED_NAMBIAR (NIVED N)]

Put a delay while scrapping data

[irfan.mansoori]

sorry… here it is…Sequence.xaml (12.1 KB)

[ppr (Peter Preuss)]

@irfan.mansoori
it looks like the result was empty e.g. the selector to the news div was failing or the extract data xml was not pointing to the parts.

have a look here:
Sequence.xaml (8.9 KB)

[irfan.mansoori]

great… its working… thanx a lot buddy…

[irfan.mansoori]

i got the selection check box… thnx a lot once again…