EXCEL and OpenOffice.Org CALC have functionality that allows table
data on web to be referenced within a spreadsheet and refreshed
periodically. A description of the EXCEL feature is provided
http://www.vertex42.com/News/excel-web-query.html
This is a handy feature if you are familiar with these spreadsheet
tools for visualisation or data analysis and your source data is
published on web (stock reports for example).
Question: can you use a Google Spreadsheet as a source for this type
of web query?
I have found that
(1) Using a Google Spreadsheet, I created a URL for a custom gadget
representing a small range of data cells. I pasted this URL into EXCEL
2007 as the address of the Web Query. This created a live connection
to the spreadsheet and the result in a single cell of
google.visualization.Query.setResponse
({version:'0.6',status:'ok',sig:'608691428',table:{cols:
[{id:'B',label:'',type:'string',pattern:''},
{id:'C',label:'',type:'string',pattern:''}],rows:[{c:[{v:'Course ....
That is, the data is collected in a standard google visualisation
format but not handled by Excel as table.
(2) Openoffice does not get the data in at all.
I could hack around with macros to achieve the desired effect but I
would prefer to use the standard product features. All suggestions
gratefully received.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Docs Data APIs" group.
To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com
To unsubscribe from this group, send email to
google-docs-data-apis+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Google-Docs-Data-APIs?hl=en
-~----------~----~----~----~------~----~------~--~---
