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 -~----------~----~----~----~------~----~------~--~---
