get values from several cells and place onto one row in excel sheet

KMANDO

Hi,

I am trying to get some text from different cells on a webpage then record these values into a spreadsheet within one row, not having any luck as of yet.

as the following provides the values to be extracted and places them into xls file but each value will be on a seperate row.
example:

_debugToFile(_getText(_cell(_table(0), 1, 2)), "C:\\textfile2.xls");
_debugToFile(_getText(_cell(_table(0), 2, 2)), "C:\\textfile2.xls");


What I am trying to do is pace both of the values into one row, but two different columns, I tried the following but no luck with it:

_debugToFile(_getText(_cell(_table(0), 1, 2))++(_cell(_table(0), 2, 1))), "C:\\text.xls");



any help would be appreciated

narayan

Use

_debugToFile(_getText(_cell(_table(0), 1, 2))+ ',' +(_cell(_table(0), 2, 1))), "C:\\text.xls");

Sahi is similar to javascript. Use javascript syntax when in doubt.