Load data from Excel

[Chirag8520 0]

hello sir

 

i make a script for google + post

1) i make a csv file

http://screencast.com/t/ksDLIgHT

 

2)when i run my script all the data will display in once, my aim is in one loop one one data is field after in second loop another data is fill

http://screencast.com/t/CbyRNyofR

 

so sir please help

 

i also want to add function like when my first loop finish then row one will be delete automatic and again start from row one

 

Edited May 21, 2014 by Chirag8520

[HelloInsomnia 1103]

Since you didn't provide code I can't edit yours. Instead here is the basic idea of what you're trying to do:

ui open file("CSV File", #csv)
comment("Clear the table before adding new data")
clear table(&data)
create table from file(#csv, &data)
comment("Set the table row number to be 0 since 0
is the first row in the table (not 1)")
set(#table_row_num, 0, "Global")
loop($table total rows(&data)) {
    comment("This is the actual table cell so you can copy this
code to use it anywhere not just an alert - the
alert is just an example")
    alert($table cell(&data, #table_row_num, 0))
    comment("At the end of each loop add 1 to the table
row number because we want the next row
on each iteration of the loop")
    increment(#table_row_num)
}

[Chirag8520 0]

 

Since you didn't provide code I can't edit yours. Instead here is the basic idea of what you're trying to do:

ui open file("CSV File", #csv)
comment("Clear the table before adding new data")
clear table(&data)
create table from file(#csv, &data)
comment("Set the table row number to be 0 since 0
is the first row in the table (not 1)")
set(#table_row_num, 0, "Global")
loop($table total rows(&data)) {
    comment("This is the actual table cell so you can copy this
code to use it anywhere not just an alert - the
alert is just an example")
    alert($table cell(&data, #table_row_num, 0))
    comment("At the end of each loop add 1 to the table
row number because we want the next row
on each iteration of the loop")
    increment(#table_row_num)
}

hellolnsomnia, this is my code

I use your code but again the data will be abstract all in once, i want that the data from the excel will load one by one in every loop

google+ bot.ubot

Edited May 23, 2014 by Chirag8520