If you don't use "headers=N", then the API tries to guess the column headers, and it looks like, in some cases, it doesn't do a very good job of guessing. Setting "headers=N" tells the API that the column headers are in the first N rows.
On Apr 20, 8:18 am, Peter Wraae Marino <[email protected]> wrote: > Hi, > > yes it did work.. but I find it confusing.. because on this page i don't use > the headers=1 > but all the tables have headers? > > http://www.powertumbling.dk/statistics/ > > <http://www.powertumbling.dk/statistics/>a little confused here. > > Peter > > On Wed, Apr 20, 2011 at 2:16 PM, asgallant <[email protected]>wrote: > > > > > > > > > > > Add "&headers=1" to the end of the query url, like this: > > var query = new google.visualization.Query( 'http:// > > spreadsheets.google.com/tq? > > key=0As8yTIMYNMU0dGYwSnZzOXFIM0k0UWJBSHRVZ1dnNkE&pub=1&headers=1' ); > > > That should do it. > > > On Apr 20, 7:50 am, Peter Wraae Marino <[email protected]> wrote: > > > ok.. it should have stated: > > > > can anyone tell me why my labels are on the first row and not in the > > header > > > of the table? > > > see links below. > > > > Peter Wraae Marino > > > > On Wed, Apr 20, 2011 at 9:01 AM, Peter Wraae Marino > > > <[email protected]>wrote: > > > > > Hi, > > > > > can anyone tell my my labels are on the first row: > > > >http://www.powertumbling.dk/dictionary > > > > > The spreadsheet is here: > > > > >https://spreadsheets.google.com/spreadsheet/pub?hl=en&hl=en&key=0As8y. > > .. > > > > > regards, > > > > Peter > > > > > -- > > > > Bellinge Gymnasterne:http://www.bellingegymnasterne.dk > > > > Power Tumbling:http://www.powertumbling.dk > > > > OSG-Help:http://code.google.com/p/sigmaosg > > > > Personal Site:http://www.marino.dk > > > > -- > > > Bellinge Gymnasterne:http://www.bellingegymnasterne.dk > > > Power Tumbling:http://www.powertumbling.dk > > > OSG-Help:http://code.google.com/p/sigmaosg > > > Personal Site:http://www.marino.dk > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google Visualization API" group. > > To post to this group, send email to > > [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. > > -- > Bellinge Gymnasterne:http://www.bellingegymnasterne.dk > Power Tumbling:http://www.powertumbling.dk > OSG-Help:http://code.google.com/p/sigmaosg > Personal Site:http://www.marino.dk -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
