About Tables

[Psychotix 0]

I've looked everywhere and couldnt find a tutorial on creating tables.

I cant get it to work.

 

Am I doing this right?

 

define test {

ui open file("Excel File To Process", #xcel)

create table from file(#xcel, &excel)

type text(<name="q">, $table cell(&excel, 1, 1), "Standard")

}

 

 

Thats in .csv and its not opened in excel. Thanks.

[rumen 3]

ui open file("Excel File To Process", #xcel)

define test {

create table from file(#xcel, &excel)

type text(<name="q">, $table cell(&excel, 1, 1), "Standard")

}

if($comparison(#xcel, "=", $nothing)) {

then {

alert("Please choose file first")

stop script

}

else {

navigate("google.com", "Wait")

test()

}

}

 

 

ps:ui commands must be outside define.

[Psychotix 0]

Tnx Rumen.

I have standard version, I cant copy paste that ehehe.

 

I tested it without Define earlier. I just had to put them there to be copy+pasted in bulk.

 

But is this right?

 

Create Table from CSV file >choose xcel as the table name

 

Then on the google form, access it ($tablecell) by calling column 1, row 1 of tablename xcel.

 

Because it does not work on my end.

Edited February 26, 2012 by Psychotix

[George 1]

Psychotix, Standard versions CAN paste code into their scripts. You just can't export it or have a code view.

 

1) Copy the above code to your clipboard

2) Right click on the Drag Comments Here box in your script

3) Click Paste.

[Psychotix 0]

There is a comments command? Havent noticed. But hey thanks will try.

 

Edit: Nope it didnt get processed as code.

Edited February 27, 2012 by Psychotix

[LoWrIdErTJ - BotGuru 904]

You can copy and paste but you have to do it in sections. only allows you to copy and paste 1 section at a time.

 

Example

 

Copy paste

ui open file("Excel File To Process", #xcel)

 

 

Copy paste

define test {

create table from file(#xcel, &excel)

type text(<name="q">, $table cell(&excel, 1, 1), "Standard")

}

 

Copy paste

if($comparison(#xcel, "=", $nothing)) {

then {

alert("Please choose file first")

stop script

}

else {

navigate("google.com", "Wait")

test()

}

}

[Psychotix 0]

Ok i figured it out finally.

 

I arranged the CSV like this

 

A1 B1

A2 B2

A3 B3

 

I tell it to pull table location column 1, row 2.

 

It pulled B3!

 

So this thing starts at zero not 1.

[a2mateit 395]

That's correct.

 

When working with a .csv, 0 is the starting point and not 1.

[George 1]

Any list or table starts with 0.

 

Psychotix, if you right click on a node and select Copy, you can paste it as code here in the forum as well.