Thanks Mr.Viz! It worked. I selected the option "automatically.." and it works
thanks pragan. On Nov 26, 12:13 pm, VizGuy <[EMAIL PROTECTED]> wrote: > I guess it has to do with the way you publish the data in your > spreadsheet.Note > that when you publish data, you can select auto publish, that will update > the published version every 5 minutes, or you can publish it once, and then > any changes will only be reflected in the published version once you > Re-Publish manually. > > Is this the case? > > VizGuy > > On Wed, Nov 26, 2008 at 6:52 PM, Pragan <[EMAIL PROTECTED]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
