Google Spreadsheet (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Alex, Sean FitzSimons, Chee Onn Wu

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 15 MAR 2011 11:31:35PM Alex wrote:

in OI , i use "MsXml2.ServerXmlhttp" to manipulate data in google spreadsheet.

Now the query or retrieve information from Google spreadsheet return value is in XML format (i think so).

What is the easiest way to extract information from "This long return value".

Thanks.

Example for the return value:

https://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full2011-03-15T07:17:[email protected]://spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cssly2011-03-15T07:17:15.779ZST1sellingprice1: 10, sellingprice2: 2, sellingprice3: 3ST11023https:spreadsheets.google.com/feeds/list/0AoOUtxyorVGhdGNONGhFMTB2bWxhQWdfTkk5OEhaUmc/1/private/full/cu76f2011-03-15T07:17:15.779ZRsellingprice1: 20, sellingprice2: 2, sellingprice3: 3R2023 </QUOTE> —- === At 16 MAR 2011 09:26AM Sean FitzSimons wrote: === <QUOTE>Alex, The function Get_XML_Value() should provide you with the method of returning values from XML. Sean </QUOTE> —- === At 16 MAR 2011 11:01PM Chee Onn Wu wrote: === <QUOTE>Thanks Sean. Get_xml_value is work great for simple tag. How about some tag is like this:- The tag it self got a lot of other info. Thanks </QUOTE> —- === At 18 MAR 2011 05:05AM Alex wrote: === <QUOTE>Did a bit of reading. Just found out that above "long return value" is actually call "atom feed" i still need help to read each element in this atom feed in a easy way. Thanks. </QUOTE> View this thread on the Works forum...