Re: single sourcing to Excel spreadsheets

Subject: Re: single sourcing to Excel spreadsheets
From: Robert Lauriston <robert -at- lauriston -dot- com>
To: Tom Johnson <tomjohnson1492 -at- gmail -dot- com>, TECHWR-L <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Thu, 18 Feb 2016 15:07:48 -0800

Use a web query:

https://support.office.com/en-us/article/Get-external-data-from-a-Web-page-708f2249-9569-4ff9-a8a4-7ee5f1b1cfba#bmcreate_a_web_query

Refresh it when you open the file:'

https://support.office.com/en-us/article/Refresh-connected-imported-data-e76a38b0-e2e1-400b-9f2f-c87b9b18c092

Probably you could write a macro to do that automatically.

On Thu, Feb 18, 2016 at 2:20 PM, Tom Johnson <tomjohnson1492 -at- gmail -dot- com> wrote:
> 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.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
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


References:
single sourcing to Excel spreadsheets: From: Tom Johnson

Previous by Author: Re: least awful approach for keeping training slides up to date with core doc updates
Next by Author: Re: least awful approach for keeping training slides up to date with core doc updates
Previous by Thread: Re: single sourcing to Excel spreadsheets
Next by Thread: Re: least awful approach for keeping training slides up to date with core doc updates


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads