RE: Excel Question -- MIDRANGE-L

tn5250j java client from sourceforge.net will export in an *.xls format but
csv is good enough.





Regards 

Steve Dodkins 

 
Welcome ... to the world of air technology and drive engineering, the world
of ebm-papst. Get informed on our unique range of products. And get to know
how motor technology and engineering, aerodynamics and electronics are made
to interact to perfection in our innovative system solutions.


IMPORTANT NOTICE This email (including any attachments) is meant only for
the intended recipient. It may also contain confidential and privileged
information. If you are not the intended recipient, any reliance on, use,
disclosure, distribution or copying of this email or attachments is strictly
prohibited. This email is not intended to be relied upon by any person
without subsequent written confirmation of its contents. ebmpapst UK Ltd.
cannot accept any responsibility for the accuracy or completeness of this
message as it has been transmitted over a public network. Furthermore, the
content of this e-mail is the personal view of the sender and does not
represent the advice, views or opinion of our company. Accordingly, our
company disclaim all responsibility and accept no liability (including in
negligence) for the consequences of any person acting, or refraining from
acting, on such information prior to the receipt by those persons of
subsequent written confirmation. In particular (but not by way of 
limitation) our company disclaims all responsibility and accepts no
liability for any e-mails which are defamatory, offensive, racist or in any
other way are in breach of any third party's rights, including breach of
confidence, privacy or other rights. If you have received this e-mail
message in error, please notify me immediately by telephone. Please also
destroy and delete the message from your computer. Any form of reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message is strictly prohibited. If you suspect
that the message may have been intercepted or amended, please notify
ebmpapst UK Ltd on +44(0)1245 468555. 
ebmpapst (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ 



-----Original Message-----
From: Goodbar, Loyd (ETS - Water Valley)
[mailto:LGoodbar@xxxxxxxxxxxxxx]
Sent: 22 September 2004 16:16
To: Midrange Systems Technical Discussion
Subject: RE: Excel Question


There is no native OS/400 command to create Excel files through V5R2. There
are some third-party packages to convert a physical file to XLS with column
headings and proper formatting. 

It is possible to create an HTML file, but call it .XLS, that Excel can
read. Search the archives for "schemas-microsoft-com:office:excel". 

Personally, we've had very few complaints about providing CSV files.

HTH,
Loyd

Loyd Goodbar
Senior programmer/analyst
BorgWarner
E/TS Water Valley
662-473-5713

-----Original Message-----
From: Muralidhar Narayana [mailto:Muralidhar_Narayana@xxxxxxxxxxx] 
Sent: Wednesday, September 22, 2004 09:58
To: midrange-l@xxxxxxxxxxxx
Subject: Excel Question

I ve frequently seen users ask for reports to be delivered in "excel
format". How is this done? My first instinct is to modify my
report-generating program to output information to an externally-described
physical file instead of (or in addition to) to a spool file, then to use
EMAIL to send the physical file to the user with parameter DELIMITER(*CSV).
But the resulting .CSV file doesn't really look like the report as I drop
all headings line (including column headings) and total lines. Is there a
way to deliver the report in "excel format" that actually looks like the
original report?

Thanks for your responses! Kindly respond

 

Regards,

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.