Gathering data and place them inside an excel sheet

Applying eValid to AJAX applications that require advanced DOM-based methods.

Gathering data and place them inside an excel sheet

Postby ArthurH » Mon May 04, 2020 9:14 am

Morning.

I want to extract certain detail of a website and paste them to relevant categories of a excel sheet.

I would like some advise on how I might accomplish this.

Thank you.
ArthurH
 
Posts: 1
Joined: Mon May 04, 2020 9:10 am

Re: Gathering data and place them inside an excel sheet

Postby eValid » Tue May 05, 2020 10:57 am

ArthurH wrote:Morning.

I want to extract certain detail of a website and paste them to relevant categories of a excel sheet.

I would like some advise on how I might accomplish this.

Thank you.


Thanks for asking ArthurH.

Once you have the specific DOM element identified, there are two commands that let you do this in the Windows environment:

ValueGet wid name "frame-path"

ValuePut wid name "frame-path"

In addition, to go along with these there are these commands:

ValueSave "filename" [APPEND]

ValueRead "filename" [END]

So there you have it: input and output to a specified property name in the DOM index that has "sourceIndex" stored inside eValid, and input and output to a local file.

Once you have the data delivered from/to a Windows file it is a simple matter to transfer it to the Excel spreadsheet.


-- eValid Support
eValid
 
Posts: 2392
Joined: Tue Jan 01, 2008 12:48 pm
Location: USA


Return to AJAX Applications & DOM Processing

Design Downloaded from free phpBB templates | free website templates | Free Web Buttons