Please reply me as I have to plan other things based on this answer!!! Sorry !
thanks pragan. On Nov 25, 4:14 pm, Pragan <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
