Page 1 of 1

Gathering data and place them inside an excel sheet

PostPosted: Mon May 04, 2020 9:14 am
by ArthurH
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.

Re: Gathering data and place them inside an excel sheet

PostPosted: Tue May 05, 2020 10:57 am
by eValid
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