Publishing as a webpage allows you to use the visualization API to access the spreadsheet as a database, and use all the charting features, etc.
Sharing allows people to view or edit the spreadsheet just as you would. On Mar 22, 4:30 am, Tobi Harnegg <[email protected]> wrote: > Ok, obviously its not enough to share AND make it editable by > everyone, you also have to put "Publish as Website", i wasnt aware of > that, stupid me :) > > (I still dont understand whats the difference between "Sharing with > everyone" and "Publishing as a website" in google docs? > > best, > tob > > On 22 Mrz., 02:13, Pegasusrjf <[email protected]> wrote: > > > > > I have had this issue from time to time. > > > Be sure that all the sheets were actually published, and I usually > > double check to see who has permissions just to make sure that > > everyone can read without sign-in required. > > > On Mar 21, 10:26 am, Tobi Harnegg <[email protected]> wrote: > > > > Ok, I have ONE spreadsheet where this is working, but as soon as i > > > enter another one > "Access Denied" > > > > working spreadsheet: > > > 'http://spreadsheets.google.com/tq? > > > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > > > nonworking spreadsheet (amongst others) > > > 'http://spreadsheets.google.com/tq? > > > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > > > Logical conclusion would be, it has something to do with the docs > > > themselves, but > > > all spreadsheets are completely shared, for reading and editing. > > > > Or is there some secret essential setting i have to change? > > > > Very grateful for Advice, > > > > Tobias > > > > PS: Even though i am a total noob, i like playing around with this API > > > > and here is the complete code: > > > > ------------------------------------------------ > > > <!-- > > > copyright (c) 2009 Google inc. > > > > You are free to copy and use this sample. > > > License can be found > > > here:http://code.google.com/apis/ajaxsearch/faq/#license > > > --> > > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > > > <html xmlns="http://www.w3.org/1999/xhtml";> > > > <head> > > > <meta http-equiv="content-type" content="text/html; charset=utf-8"/ > > > > <title> > > > Google Visualization API Sample > > > </title> > > > <script type="text/javascript" src="http://www.google.com/jsapi";></ > > > script> > > > <script type="text/javascript"> > > > google.load('visualization', '1', {packages: ['table']}); > > > </script> > > > <script type="text/javascript"> > > > > var isFirstTime = true; > > > var options = {'showRowNumber': false}; > > > var data; > > > var queryInput; > > > > // To see the data that this visualization uses, browse to > > > var query = new google.visualization.Query( > > > // 'http://spreadsheets.google.com/tq? > > > key=0AveLEDuTZv0vdFNFb1pBNl9scGVRU3JWd19qZUtuQVE&pub=1'); > > > 'http://spreadsheets.google.com/tq? > > > key=0AveLEDuTZv0vdGxWV0hUZkZWYXdBaE1sT29GUjZKQWc&pub=1'); > > > > function sendAndDraw() { > > > // Send the query with a callback function. > > > query.send(handleQueryResponse); > > > } > > > > function handleQueryResponse(response) { > > > if (response.isError()) { > > > alert('Error in query: ' + response.getMessage() + ' ' + > > > response.getDetailedMessage()); > > > return; > > > } > > > data = response.getDataTable(); > > > var table = new > > > google.visualization.Table(document.getElementById('querytable')); > > > table.draw(data, {'showRowNumber': false}); > > > if (isFirstTime) { > > > init(); > > > } > > > } > > > > function setQuery(queryString) { > > > // Query language examples configured with the UI > > > query.setQuery(queryString); > > > sendAndDraw(); > > > queryInput.value = queryString; > > > } > > > > google.setOnLoadCallback(sendAndDraw); > > > > function init() { > > > isFirstTime = false; > > > (new > > > google.visualization.Table(document.getElementById('table'))).draw(data, > > > options); > > > queryInput = document.getElementById('display-query'); > > > } > > > > function setQueryFromUser() { > > > setQuery(queryInput.value); > > > } > > > > // Apply query language. > > > query.setQuery('SELECT A,B,D ORDER BY A DESC'); > > > > </script> > > > </head> > > > <body style="font-family: Arial; border: 0 none;"> > > > <div style="margin-bottom: 10px; padding: 5px; border: 1px solid gray; > > > background-color: buttonface;"> > > > <span> Test-Table </span> > > > > </div> > > > <table style='width: 100%;'> > > > <tr> > > > <td style="width: 50%; padding: 10px; vertical-align: left;"> > > > <div id="querytable"></div> > > > </td> > > > </tr> > > > </table> > > > </body> > > > </html>- Hide quoted text - > > - Show quoted text - -- 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.
