I don't know about the limits of spreadsheets. What you read could be right.
If you are going to have a few thousand rows, however, it might be worthwhile to arrange that the data is entered in a format that avoids the need for a transpose. In fact, with enough data, you might want to consider using a database instead of a spreadsheet. Just a suggestion. You can also write some script code to run within the spreadsheet to do a specific transpose the way you want, but whatever the spreadsheet limits are in terms of rows and columns would still apply. You can avoid looking through the rawdata as it is transmitted to the browser by using the datatable method calls. In particular, getValue will get the value at a row and column index: https://developers.google.com/chart/interactive/docs/reference#DataTable_getValue There is also a setValue method. Here is an example of the kind of loop required to transpose a matrix in JavaScript: http://stackoverflow.com/questions/4492678/to-swap-rows-with-columns-of-matrix-in-javascript-or-jquery You should do this with getValue and setValue calls instead of accessing the array elements directly. On Wed, Oct 22, 2014 at 2:55 PM, Rob H <[email protected]> wrote: > Thanks again Daniel. > > I read that there is a column limit in SpreadSheets so the transpose > option wouldn't work for this as I could have a few thousand rows - do you > know that to be the case? > > I've got the first steps of your javascript option and managed to dump the > Object into the console to look at. It's a hell of an object isn't it!? Do > you have any examples of iterating through these objects that I could use > as a guide? > > My concern with this method bringing back the whole spreadsheet in the > first call - it might be 2000 rows and I imagine that would take a > significant time? > > Many thanks > Rob > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/google-chart-api. > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
