Re: single sourcing to Excel spreadsheets

[Tony Chung <tonyc -at- tonychung -dot- ca>]

That function updates the data every time you load the Excel sheet.

-Tony

On Thursday, 18 February 2016, Tom Johnson <tomjohnson1492 -at- gmail -dot- com> wrote:

> 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 <javascript:;>
> cell: 408-540-8562
>
> On Thu, Feb 18, 2016 at 2:52 PM, <mbaker -at- analecta -dot- com <javascript:;>>
> 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
> <javascript:;>
> > [mailto:techwr-l-bounces+mbaker <javascript:;>=
> analecta -dot- com -at- lists -dot- techwr-l -dot- com <javascript:;>] 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 <javascript:;>
> > 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
> <javascript:;>.
> >
> > To unsubscribe send a blank email to
> > techwr-l-leave -at- lists -dot- techwr-l -dot- com <javascript:;>
> >
> >
> > Send administrative questions to admin -at- techwr-l -dot- com <javascript:;>.
> 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 tonyc -at- tonychung -dot- ca
> <javascript:;>.
>
> To unsubscribe send a blank email to
> techwr-l-leave -at- lists -dot- techwr-l -dot- com <javascript:;>
>
>
> Send administrative questions to admin -at- techwr-l -dot- com <javascript:;>. 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