Re: question: format an excel file (.xls) inside sqr program

[Rod Wright <rwright@THEROUSECOMPANY.COM>]

I'm not aware of a way to do this through SQR. However, you could create the CSV
file, and then through a separate program, perhaps VB, make calls to Excel
(through the DLL) to import the file, format it, and finally save it as a .xls
file for your users.





"Lambert, Jin" <JLambert@HRBLOCK.COM> on 01/08/2001 10:32:13 AM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rodney Wright/Trcb/Rouse)

Subject:  question:  format an excel file (.xls) inside sqr program



I have a question and hope some of you have accomplished such and can share
your knowledge with me...

We are developing a SQR program, which, generates a report for the end
users.  We proposed the report be formatted as .csv file so the user can
open it as an excel.  However the users insist that they want the excel file
format (.xls) instead of .csv file format.  Is there anyway such request can
be accomplished via a SQR program?

Jin Lambert
PeopleSoft Financial Team
H&R Block
voice:       (816) 932-7529
fax:          (603) 687-4815
e-mail:      JLambert@hrblock.com