Compiling tinyxml for iOS? Seeing this kind of error?
tinyxml.cpp:25:10: fatal error: 'ctype.h' file not found
You probably just upgraded Xcode, or just installed it. You don't have the right simulator installed. Go to Xcode preferences -> Downloads tab and install the right simulator.
Monday, April 22, 2013
Thursday, April 11, 2013
Very simple Google Spreadsheet code
FYI - this blog post is from a long time ago, and I think things have changed quite a bit. I'm leaving it here because some parts my still be useful, but definitely read the comments and don't expect it to work out of the box. - James, 26 Nov 2013
(Update - see comment from Sean about this no longer working due to auth changes from Google)
I wanted to use data from a google docs spreadsheet in a project, and the sample code all talks about how to authenticate and get lists of documents for a user.
In my case, I already had a public document that I wanted to read.
You’ll want to read the doc here first, but there were two gaps.
The output:
(Update - see comment from Sean about this no longer working due to auth changes from Google)
I wanted to use data from a google docs spreadsheet in a project, and the sample code all talks about how to authenticate and get lists of documents for a user.
In my case, I already had a public document that I wanted to read.
You’ll want to read the doc here first, but there were two gaps.
- It wasn’t straightforward (at least for me) to figure out exactly what the URL for a public spreadsheet should be (the doc concentrates on private documents, and assumes you’re going to be iterating through a list of available spreadsheets, not going straight to a specific one).
- It wasn’t clear which Java classes mapped to the URLs I had.
The output:
One 1 Two 2 Three 3The code:
package com.banshee; import java.io.IOException; import java.net.URL; import com.google.gdata.client.spreadsheet.SpreadsheetService; import com.google.gdata.data.spreadsheet.CustomElementCollection; import com.google.gdata.data.spreadsheet.ListEntry; import com.google.gdata.data.spreadsheet.ListFeed; import com.google.gdata.util.ServiceException; public class SpreadsheetSucker { public static void main(String[] args) { SpreadsheetService service = new SpreadsheetService("com.banshee"); try { // Notice that the url ends // with default/public/values. // That wasn't obvious (at least to me) // from the documentation. String urlString = "https://spreadsheets.google.com/feeds/list/0AsaDhyyXNaFSdDJ2VUxtVGVWN1Yza1loU1RPVVU3OFE/default/public/values"; // turn the string into a URL URL url = new URL(urlString); // You could substitute a cell feed here in place of // the list feed ListFeed feed = service.getFeed(url, ListFeed.class); for (ListEntry entry : feed.getEntries()) { CustomElementCollection elements = entry.getCustomElements(); String name = elements.getValue("name"); System.out.println(name); String number = elements.getValue("Number"); System.out.println(number); } } catch (IOException e) { e.printStackTrace(); } catch (ServiceException e) { e.printStackTrace(); } } }
Subscribe to:
Posts (Atom)