Hi, a) Here is my spreadsheet I'm trying to show as html table: http://spreadsheets.google.com/ccc?key=pTSZ7bTknTaeiR_JJrmx2SA
b) Then, I followed this example to create a visualization http://code.google.com/apis/visualization/documentation/dev/index.html but instead of creating DataTable manually within html file, I read it from my spreadsheet above. But the datetime elements that iclude both date and none zero time are not shown?!! Please advise <html> <head> <script type="text/javascript" src="http://www.google.com/jsapi";></ script> <script type="text/javascript" src="mytablevis.js"></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["table"]}); // Set callback to run when API is loaded google.setOnLoadCallback(drawVisualization); // Called when the Visualization API is loaded. function drawVisualization() { var query = new google.visualization.Query('http:// spreadsheets.google.com/ccc?key=pTSZ7bTknTaeiR_JJrmx2SA'); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var vis = new google.visualization.Table(document.getElementById ('mydiv')); vis.draw(data, {showRowNumber: true}); } </script> <title></title></head> <body> <div id="mydiv"></div> <p>Test example.</p> </body> </html> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
