Export select rows only from Excel to use in documentation

Subject: Export select rows only from Excel to use in documentation
From: Svi Ben-Elya <svib -at- flashnetworks -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Wed, 21 Sep 2005 18:15:50 +0300

Can anyone help me automate export of parameter info from Excel for import
into table is FM. Please CC me.

Current Situation:
1. I automatically separate out the relevent columns to a separate worksheet
(defined in Excel).
2. I use a separate column to mark which rows I need for which worksheet.
All rows appear in the worksheet (relevant ones with text - other are
3. I save the worksheet as a tab delimited file.
4. I import the .txt file into FrameMaker and save as text. The table is
fine except that I am stuck with all of the blank lines.

Needed Mechanism:
1. I want to automatically remove all of the blank lines either inside the
Excel file or when I export (save as).
2. I also want to add a bracket to the start and end of one of the cell
values in the worksheet.

Excel Formmula Used:

Explanation of Formula:

G is the sort column.

"3-Common" is the value to find.

T(Sheet1!A2),"") places the relevant text into the worksheet field if
"3-Common" is found.

"" keeps the cell empty if "3-Common" is not found.

- Svi Ben-Elya -
Documentation Manager
svib -at- flashnetworks -dot- com

This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.


Now Shipping -- WebWorks ePublisher Pro for Word! Easily create online
Help. And online anything else. Redesigned interface with a new
project-based workflow. Try it today! http://www.webworks.com/techwr-l

Doc-To-Help 2005 converts RoboHelp files with one click. Author with Word or any HTML editor. Visit our site to see a conversion demo movie and learn more. http://www.componentone.com/TECHWRL/DocToHelp2005

You are currently subscribed to techwr-l as:
archiver -at- techwr-l -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- techwr-l -dot- com
Send administrative questions to lisa -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/techwhirl/ for more resources and info.


Previous by Author: Re: Linking to online help topic
Next by Author: Re: Linking to online help topic
Previous by Thread: RE: Problem Generating Printed Documentation in RoboHelp HTML X5
Next by Thread: Re: Export select rows only from Excel to use in documentation

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

Sponsored Ads