Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.apps.spreadsheets > #12
| Path | csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
|---|---|
| From | Phil <phil@groklabs.com> |
| Newsgroups | comp.apps.spreadsheets |
| Subject | Help needed with exporting data from Google Spreadsheets to Excel via dynamic link |
| Date | Thu, 19 Apr 2012 10:59:27 -0700 (PDT) |
| Organization | http://groups.google.com |
| Lines | 23 |
| Message-ID | <5356450.619.1334858367200.JavaMail.geo-discussion-forums@pbep2> (permalink) |
| NNTP-Posting-Host | 199.188.193.7 |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| X-Trace | posting.google.com 1334858475 18269 127.0.0.1 (19 Apr 2012 18:01:15 GMT) |
| X-Complaints-To | groups-abuse@google.com |
| NNTP-Posting-Date | Thu, 19 Apr 2012 18:01:15 +0000 (UTC) |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=199.188.193.7; posting-account=vx41JQoAAAA9LoHj6UIa3OOHfns_NOH4 |
| User-Agent | G2/1.0 |
| X-Received-Bytes | 2265 |
| Xref | csiph.com comp.apps.spreadsheets:12 |
Show key headers only | View raw
Hello Everyone. Here is my scenario. I have a google docs spreadsheet that is changed regularly - every two days or so. I want to automatically export that data into excel - note here, automatically! I want my client to be able to open an Excel file and see updated data from my google spreadsheet. I am able to manually push the data to her via spreadsheets, but I want it to happen automatically. I know that I can export a file (HTML, CSV, EXCEL, TXT) but that is not automatic. I know also, that I can publish to the web, and get a link to the published data. I have made sure to make that public data and everyone can access it. PROBLEM: When I try to open the URL (txt or csv) that Google Spreadsheets gives me in Excel 2011 (File, Open URL) https://docs.google.com/spreadsheet/pub?key=0Aqr4T7rLB9FMdDZ2S1daa3RIeFNMdWVKck9FNWF6YVE&single=true&gid=0&output=csv I get the following message: This site cannot be accessed. And Microsoft Excel cannot access the file "Filename" Path does not exist its being used by another program name of the workbook is the same as another already open. This is not the case in any of the examples. Can anyone help with this solution or any other solution that will allow me to automatically update data from google spreadsheets into Excel.
Back to comp.apps.spreadsheets | Previous | Next — Next in thread | Find similar
Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Phil <phil@groklabs.com> - 2012-04-19 10:59 -0700
Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link phil@groklabs.com - 2012-04-19 11:41 -0700
Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Peter Grummett <peter.grummett@regather.net> - 2012-05-27 00:34 -0700
csiph-web