Using the spreadsheet api version 3.0, I made a program to create a
worksheet and then fill out the values obtained in an analysis tool we use
here.
Currently, the block of code I'm using is:
int iSize = values.size();
ListEntry row = null;
for(int i=1;i<iSize;i++){
row = new ListEntry();
for(int j=0; j<jSize; j++){
row.getCustomElements().setValueLocal(values.get(0).get(j),
values.get(i).get(j));
}
// Send the new row to the API for insertion.
row = service.insert(listFeedUrl, row);
}
values is an ArrayList<ArrayList<String>>, with the the first row being the
header names.
Currently, when running this, I can go to google drive and see each row
being inserted. But the problem is, it takes such a long time doing it this
way, and I think there must be a more efficient way of writing the data,
maybe a full table insert instead of row by row?
If anyone knows how to make this much faster to insert, I'd appreciate it!
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
