Alrighty, I've done some more troubleshooting and it looks like when I pull in some other form of data that is NOT a string, it magically makes the first row headers. So if I put a new column and just fill it with "FALSE", the headers work. If I make a new column and fill it with numbers, the headers work.
I can fake it to make it work, but I'd like to hear if this is a bug or if I've got something configured wrong. On Aug 13, 1:41 pm, briankennedy1 <[email protected]> wrote: > If you do try out the code, make sure that the URL doesnt have that > line break in it after "pub?" and before "key=", it all has to be on > one line. > > On Aug 13, 1:04 pm, briankennedy1 <[email protected]> wrote: > > > Hey all, > > > I'm creating a table from Google spreadsheet data. When my data is > > processed into the spreadsheet, it does not recognize my column names. > > I believe this is because I am using HTML in my cells. When I strip > > out the HTML, the column names are recognized, become bold and are > > able to be sorted. > > > How do I get the table visualization to recognize my column names? > > > If you head over here and pop in the below code you can see what I > > mean:http://code.google.com/apis/ajax/playground/?type=visualization#table > > > function drawVisualization() { > > var query = new google.visualization.Query( > > 'http://spreadsheets.google.com/pub? > > key=tKOcHX3T8pHOCSz5X2TR6Kg'); > > > query.send(handleQueryResponse); > > } > > > function handleQueryResponse(response) { > > if (response.isError()) { > > alert('Error in query: ' + response.getMessage() + ' ' + > > response.getDetailedMessage()); > > return; > > } > > > var data = response.getDataTable(); > > visualization = new google.visualization.Table > > (document.getElementById('table')); > > visualization.draw(data, {allowHtml: true}); > > > } > > > Any help is appreciated! > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
