hi, I am just trying this very basic example and have a question about the data displayed. For example, I just have five symbols in my spreadsheet and having 3 datapoints(price,low,high). I am trying to query the spreadsheet using visulaization api(table package) to show the result back in the browser(range or individual cell).
I can see that data is updated in the spreadsheet which is good, but even if I refresh my browser the values doesn't change. I tried clearing the cache/cookies if that can be one reason. I couldn't think of any reason why its not changing even if you refresh. I can understand that it cannot refresh itself once its on the browser. At-least, manual refresh should show the current values from the spreadsheet. The values that I am seeing now are from Friday. (Nov 21). Can you please explain why this is happening? Please see this example: <html> <head> <script type="text/javascript" src="http://www.google.com/jsapi";></ script> <script type="text/javascript"> google.load('visualization', '1', {packages: ['table', 'map', 'columnchart']}); google.setOnLoadCallback(initialize); function initialize() { var query = new google.visualization.Query('http:// spreadsheets.google.com/pub? range=E4&headers=-1&key=paMPZbgrLy26_fkHVnLkCSg&gid=3'); query.send(handleQueryResponse); function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var table = new google.visualization.Table(document.getElementById ('table_div')); table.draw(data, {showRowNumber: true}); var chart = new google.visualization.PieChart(document.getElementById ('chart_div')); chart.draw(data, {width: 400, height: 240, is3D: true}); } } </script> </head> <body> <div id="table_div" style="width: 700px; height: 240px;"></div> </body></html> thanks pragan. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
