[duxuser] Re: XL Sheet

  • From: "David P. Rosenfeld" <drosenfe@xxxxxxxxxx>
  • To: <duxuser@xxxxxxxxxxxxx>, <dbarnes@xxxxxxxxxxxxxxxxxxxxxxx>
  • Date: Wed, 07 May 2003 14:49:14 -0400

Hello.

I find that a very reliable method of dealing with Excel sheets in DBT is to go 
to the first cell of the sheet while in Excel, highlight the contents of the 
sheet with ctrl-shift-end, copy to the clipboard with ctrl-c, paste to an empty 
file in MS Word with ctrl-v, and save the Word file in normal Word format.  
When you bring this file into DBT, it will see a normal Word table and treat it 
accordingly.  If you like DBT's method of presenting the outline style and 
hierarchy levels, you probably won't need to do much to it.  What I often do is 
to turn the table into poetry mode with [PTYS] and [PTYE], replace the 
interfield hierarchy level commands with a semicolon and a space, and the 
beginning of each record ([hl1]) with the new-line command ([l]).




David R.


>>> dbarnes@xxxxxxxxxxxxxxxxxxxxxxx 05/07/03 03:48pm >>>
Hi everyone,

I have a Treasurer's Report, and I must translate the Summary Sheet and
emboss it.  summary   I have never done XL but what I'm trying to do is
figure out the best way to translate and emboss the XL Summary.  Any
ideas???

Another reason I want to do this is that when folks take out certain "tags"
I spend more time having to put back in things they took out--like parts of
bolded passages, making web addresses correctly, etc.  So I want to get to
the point where I can do the translation from the XL material myself.

Thanks for any ideas.

Deb B.

* * *
* This message is via list duxuser at freelists.org.
* To unsubscribe, send a blank message with
*   unsubscribe
* as the subject to <duxuser-request@xxxxxxxxxxxxx>. You may also
* subscribe, unsubscribe, and set vacation mode and other subscription
* options by visiting //www.freelists.org.  The list archive
* is also located there.
* Duxbury Systems' web site is http://www.duxburysystems.com 
* * *


* * *
* This message is via list duxuser at freelists.org.
* To unsubscribe, send a blank message with
*   unsubscribe
* as the subject to <duxuser-request@xxxxxxxxxxxxx>. You may also
* subscribe, unsubscribe, and set vacation mode and other subscription
* options by visiting //www.freelists.org.  The list archive
* is also located there.
* Duxbury Systems' web site is http://www.duxburysystems.com
* * *

Other related posts: