Thursday, February 16, 2012

How to Convert a Google Spreadsheet into JSON, XML, and MySQL

 http://blog.pamelafox.org/2009/05/how-to-convert-google-spreadsheet-into.html
Followed the above tutorial.it immensely helped.after that i tried to imitate.here's my own spread sheet.
https://docs.google.com/spreadsheet/ccc?key=0Alca46paoUEXdE1SaDI1blF3TTgyV0hYS3ZLUmlfQUE#gid=0

when you need response go to INSERT-GADGET-ADD A GADGET-CUSTOM
ADD THE URL:-http://pamelafoxsamplecode.googlecode.com/svn/trunk/spreadsheetsconverter/spreadsheetsconverter.xml
THEN ADD.now u will have to select the range of the outputs you want to see. and the output format.
select the whole table from the top to bottom rows.then get the output

What is CDATA?
unparsed character data."<![CDATA[" and ends with "]]>".the code written within it is not parsed by an XML parser

No comments:

Post a Comment