Hi Chrissy, You can get something close with the 'list' feed - http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingListFeeds
The caveat is that your column names will be: a) in the namespace "http://schemas.google.com/spreadsheets/2006/extended b) converted into legal XML names according to http://code.google.com/apis/spreadsheets/data/3.0/reference.html#gsx_reference <http://code.google.com/apis/spreadsheets/data/3.0/reference.html#gsx_reference>As regards conversion of names, you'll be pretty safe if your column headings are valid XML element names. However, Google don't currently specify how they redact column heading names containing XML-unsafe characters other than spaces. Experimentation would probably show that they are handled the same way as spaces though. cheers, David. On Fri, Apr 22, 2011 at 5:07 AM, Chrissy < [email protected]> wrote: > I see that I can export the Google Spreadsheet in different formats - atom > and RSS, but the actual atom or RSS doesn't have the same schema as my > column names. Is there a way I can export the Google Spreadsheet so that my > schema builds from my column headings? > > So, if I had column headings like title, link, date, description, author - > can I get the RSS to print out information like: > <title>This is my title</title> > <link>http://google.com</link> > <pubDate>Apr 21, 2011</pubDate> > <description>Blah blah blah</description> > <author>Author's Name</author> >
