Question: SQR output file... -Reply

[Cecilia Bigley <cbigle@CORP.ATL.COM>]

Jimmy -

When you're writing out your file, write out delimiters
(i.e. tabs) in between fields which will load into EXCEL
properly.  Then you can pull it out of EXCEL in whatever
format you need. You can also write out a first line of
Column Headers if you like.

For Example :

let $tab1=chr(9)

!Write out Header Line.

WRITE 1 from
'YTDPaygroup'
$tab1
'Amount'

!Write out Data Line.
WRITE 1 from
$paygroup:3
$tab1
$amount:10

----
Cecilia Bigley
Application Developer
ATL Ultrasound



>>> Jimmy Liao <chien-wei.j.liao@AC.COM> 06/26/98
02:22pm >>>
Hi,

I was wondering, if it is possible for SQR3 to create an
output file in the
format of an Excel Spreadsheet?
So far, I have tried to create a flat file and add the
extension of .xls at
the end of the file name to trick
Excel to either open it or to import it (but it's not quite
working as well
as I had hoped).

Since the spacing is crucial ( the data must be in the
correct row/column
so it can be automatically
uploaded into PeopleSoft), I was wondering if there's a
standard way of
creating the data in the spreadsheet
format without having to deal with the Import Manager in
Excel.

Thanks in advance!

Regards,
Jimmy Liao