Re: single sourcing to Excel spreadsheets

[Tom Johnson <tomjohnson1492 -at- gmail -dot- com>]

Thanks Mark. I'll check it out.

By the way, I tinkered around with the function in Excel that lets you
import data from external web sources, but it looks like it's a one-time
import. What I need is a script that will always pull from the defined
online source each time the spreadsheet is opened. The method described
here is really no different from copy and paste:
http://stackoverflow.com/questions/16797500/how-to-create-web-query-on-mac-excel-2011

Tom

---------------------
blog: idratherbewriting.com
twitter: tomjohnson
email: tomjohnson1492 -at- gmail -dot- com
cell: 408-540-8562

On Thu, Feb 18, 2016 at 2:52 PM, <mbaker -at- analecta -dot- com> wrote:

> When you say customize in Excel, do you mean that the customize it by hand
> in Excel or that they have written an Excel macro so that Excel is working
> just as a scripting environment.
>
> If the latter, I'd suggest that something like Beautiful Soup would
> probably
> provide a better environment for this.
> http://www.crummy.com/software/BeautifulSoup/bs4/doc/
>
> Mark
>
> -----Original Message-----
> From: techwr-l-bounces+mbaker=analecta -dot- com -at- lists -dot- techwr-l -dot- com
> [mailto:techwr-l-bounces+mbaker=analecta -dot- com -at- lists -dot- techwr-l -dot- com] On Behalf
> Of Tom Johnson
> Sent: Thursday, February 18, 2016 5:21 PM
> To: TECHWR-L
> Subject: single sourcing to Excel spreadsheets
>
> Does anyone know how to export content from an HTML source to Excel
> spreadsheets?
>
> Our delivery group uses Excel spreadsheets to customize the request
> elements
> customers use in an API (filtering the body request down from hundred of
> elements to a manageable handful). Other than somehow generating a CSV
> export from a source, I have never tried to single source content into a
> Excel spreadsheet output.
>
> Tom
>
> ---------------------
> blog: idratherbewriting.com
> twitter: tomjohnson
> email: tomjohnson1492 -at- gmail -dot- com
> cell: 408-540-8562
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Visit TechWhirl for the latest on content technology, content strategy and
> content development | http://techwhirl.com
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> You are currently subscribed to TECHWR-L as mbaker -at- analecta -dot- com -dot- 
>
> To unsubscribe send a blank email to
> techwr-l-leave -at- lists -dot- techwr-l -dot- com
>
>
> Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
> http://www.techwhirl.com/email-discussion-groups/ for more resources and
> info.
>
> Looking for articles on Technical Communications?  Head over to our online
> magazine at http://techwhirl.com
>
> Looking for the archived Techwr-l email discussions?  Search our public
> email archives @ http://techwr-l.com/archives
>
>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Visit TechWhirl for the latest on content technology, content strategy and content development | http://techwhirl.com

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com


Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwhirl.com/email-discussion-groups/ for more resources and info.

Looking for articles on Technical Communications?  Head over to our online magazine at http://techwhirl.com

Looking for the archived Techwr-l email discussions?  Search our public email archives @ http://techwr-l.com/archives