I am able to scrape few tables and write into excel sheet.
I have facing an issue whereby i need to add a single data that is correlated to those tables.
I have tried using GET TEXT but i do not know how to write into excel
I have tried using screen scraping but extractdatameta is empty may i know how to write XML string code to get a single text from web site?
Use “write cell” activity and pass the string value that you got using get text activity
So the issue is that the single data is correlated with the other 6-7 extracted datatable… And all the datatable ouput are the same because they are correlated table.
My problem is that I cannot write the single text to an output variable
Please upload your workflow and share site link and screenshot !!
Site that I’m extracting data from is confidential site.
Can you help me to try or any site will do.
Main concern is to make *screen scrapping single element text * and extract datatable and write into excel .
Plsss I need help ASAP
Try to use a correct selector and take the required attribute of that selector
As you mentioned You don’t want to use get text activity and write cell ,
can upload Excel sheet that you want to be written by bot and workflow .
Or
Take another website and show the similar scenario.
Ok I will upload ASAP… Fyi that single element data is an input by user
anyone?
sorry for delay , can you upload one sample ,how your output should be?
Hi it’s ok.
For e.g.
first name Neymar input into site and scrape then output to excel sheet 2 write range “B1”
So I want the name(which is from sheet1) on sheet 2 column A after scraping out.
You use .trim in the end of string , it will remove spacing.
For example strName.string
I have seen your previous query , I will reply it soon.
The data is a mockup with hard code… In actual will be extracted from the website. After a datatable, the next following datatable will be in new row new column.