HP3000-L Archives

September 2004, Week 4

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Emerson, Tom" <[log in to unmask]>
Reply To:
Emerson, Tom
Date:
Tue, 28 Sep 2004 16:20:31 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (32 lines)
> -----Original Message-----
> Behalf Of Tim Valder
> 
> I am continually deluged with users asking "can you send me 
> that report in
> Excel?".  Well, I can, but not without getting involved in 
> converting it.

[insert donna g. sigh here]

Umm, why not put the onus on the users to do [their own] work?  After all, here is "an excel file":

    1,2,3
    3,4,5
    8,7,4

Don't believe me?  copy those three lines to a text file, NAME it with ".csv" as an extension, and open in excel...

But, you did start out with "...that report...", well, consider this portion of a "report":

Part Number   Description  Qty
001001-90-01  Product A    100
123456-78-90  Product B   2500
E1415 -00-01  Product C     15

Again, copy those four lines to a file and "open" in excel -- give the file some seemingly random extension such as ".txt" or ".prn", and you'll be pleasantly surprised to find excel will "figure out" that this is a FIXED WIDTH file and import properly [g'head -- I just did this myself to make sure my example would work]

In short, I think if you spend a few minutes training your users, you can relieve yourself from this burdon [some days it helps to think like tom sawyer or huck finn, if you know what I mean...]

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2