Hi Russell, I dont know if this helps.. but helps for me: (is in java) http://blog.restphone.com/2011/05/very-simple-google-spreadsheet-code.html
The problem that i found is that i tried to "publish to the web" a spreadsheet via java.. but i don't find a simple.. code that explain me that if u know how to do it. Please tell me. Thanks. On Thursday, March 21, 2013 4:23:12 PM UTC-6, Russell Wright wrote: > > Hello, > > I couldn't find a single example that illustrates this, or any > documentation that explains it. I simply want to read the contents of some > cells, but from a public spreadsheet without setting user credentials. All > examples and write-ups I see involve authorizing a SpreadsheetsService for > a particular user, and then fetching a list of spreadsheets from the user, > like this: > > // Instantiate a SpreadsheetQuery object to retrieve spreadsheets. > SpreadsheetQuery query = new SpreadsheetQuery(); > > // Make a request to the API and get all spreadsheets. > SpreadsheetFeed feed = service.Query(query); > > For one, the call "service.Query(query)" seems to take like 10 seconds to > return. Secondly, I'd prefer to grab any public spreadsheet in general, > not one tied to my account, and especially not a huge collection of > spreadsheets. Ideally, I just want to grab a single public spreadsheet > from its URL, and read in some cell contents as strings. > > I've made a public spreadsheet and then published it (located here: > https://docs.google.com/spreadsheet/ccc?key=0AochdJZhbxmMdG1fRGlmaFpZVlBPSXBHX2hkRWxXRlE#gid=0), > > and I've attempted to query this spreadsheet without calling > setUserCredentials on the SpreadsheetsService, but I can't get it to work: > > SpreadsheetsService service = new SpreadsheetsService("test"); > > SpreadsheetQuery query = new > SpreadsheetQuery("https://spreadsheets.google.com/feeds/worksheets/0AochdJZhbxmMdG1fRGlmaFpZVlBPSXBHX2hkRWxXRlE/public/full";); > > SpreadsheetFeed feed = service.Query(query); > > In this example, I've attempted to use the URL format described here: > https://developers.google.com/google-apps/spreadsheets/#spreadsheets_api_urls_visibilities_and_projections, > > but calling service.Query(query) again takes like 10 seconds, and it > returns null. I've tried it with the standard URL as well, and a few other > variations. What am I doing wrong? > > > Best regards, > Russell > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
