Hi Mr.Vizguy, thanks for the reply. I guess I was wrong in saying that. Looks like there was more delay than usual in showing that on the page. Now I have another question. How about the color formatting for the cells? I have defined some rules in my spread sheet for certain columns but when I call that sheet through api, it just shows the data from the sheet and not the formatting with colors. Also, even if define the max range like a2:i30(as my content is dynamic, it will be 30 rows at one time and 10 rows at some other time), viz api just shows the rows only that has content but that's not the case if I just call this URL directly, it displays even the empty rows. http://spreadsheets.google.com/pub?key=pOwJNZtcSjzJS8r_oQIb3TQ&output=html&gid=6&single=true&range=a4:i30. I cannot do it without range as I might not want to show rows above 4.
any hep please? Please check 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"]}); google.setOnLoadCallback(initialize); function initialize() { var url ='http://spreadsheets.google.com/pub? key=pOwJNZtcSjzJS8r_oQIb3TQ&output=html&gid=6&single=true&range=a2:i30'; var query = new google.visualization.Query(url); query.send(draw); } function draw(response) { if (response.isError()) { alert("Error in query") } var Data1 = response.getDataTable(); var table1 = new google.visualization.Table (document.getElementById('table1_div')); table1.draw(Data1, {}); } </script> <body> <div id="table1_div" ></div><br /> </body> </html> On Mar 11, 1:20 pm, VizBoy <[email protected]> wrote: > Hi, > > The visualization api does not care if the cell content was created by a > formula or directly. > So your code should work. > Please try the simplest scenario, i.e., without the "select J" and use a > simple visualization where you can see all the data like a Table and let me > know if you see the result of the formula. > > - VizBoy. > > On Wed, Mar 11, 2009 at 6:23 PM, Pragan <[email protected]> wrote: > > > Hi, > > > I have a question in getting the data from a cell in spreadsheet that > > is filled using a formula. > > I created a spreadhsheet and I am trying to get the data using viz > > api. One column in this cell is filled based on other cells using the > > formula : =IF(A2="?",0,1) > > I can see the values when I publish the sheet but not when I use this > > query > > "query.setQuery('select J');" from viz api . Is there any way to > > either get the content or write the formula in the code? Please let me > > know. > > > 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 -~----------~----~----~----~------~----~------~--~---
