Psychotix 0 Posted February 26, 2012 Report Share Posted February 26, 2012 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. Quote Link to post Share on other sites
rumen 3 Posted February 26, 2012 Report Share Posted February 26, 2012 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. Quote Link to post Share on other sites
Psychotix 0 Posted February 26, 2012 Author Report Share Posted February 26, 2012 (edited) 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 Quote Link to post Share on other sites
George 1 Posted February 26, 2012 Report Share Posted February 26, 2012 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 clipboard2) Right click on the Drag Comments Here box in your script3) Click Paste. Quote Link to post Share on other sites
Psychotix 0 Posted February 27, 2012 Author Report Share Posted February 27, 2012 (edited) 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 Quote Link to post Share on other sites
LoWrIdErTJ - BotGuru 904 Posted February 27, 2012 Report Share Posted February 27, 2012 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 pasteui open file("Excel File To Process", #xcel) Copy pastedefine test {create table from file(#xcel, &excel)type text(<name="q">, $table cell(&excel, 1, 1), "Standard")} Copy pasteif($comparison(#xcel, "=", $nothing)) {then {alert("Please choose file first")stop script}else {navigate("google.com", "Wait")test()}} Quote Link to post Share on other sites
Psychotix 0 Posted March 2, 2012 Author Report Share Posted March 2, 2012 Ok i figured it out finally. I arranged the CSV like this A1 B1A2 B2A3 B3 I tell it to pull table location column 1, row 2. It pulled B3! So this thing starts at zero not 1. Quote Link to post Share on other sites
a2mateit 395 Posted March 2, 2012 Report Share Posted March 2, 2012 That's correct. When working with a .csv, 0 is the starting point and not 1. Quote Link to post Share on other sites
George 1 Posted March 2, 2012 Report Share Posted March 2, 2012 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. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.