Re: Using Excel to View a LIS File

["Sarabudla, Raji R." <Raji.R.Sarabudla@KP.ORG>]

Hi Joe,

As far as I know, One  cannot view LIS files in Excel as it is.  You need to
write to  a separate file or string the fields  with a delimiter (Ex: Tab or
Comma )  and then you can import the file to Excel.  The other way is to
Open a file with XLS extension(i.e. temp.xls)  and write the  information
with a delimter and this can directly be opened in excel (Don't foreget to
write a heading row).  The following examle may help you.  You can write
this within your procedure without interrupting the logic or syntax.

Ex:
Begin-procedure temp
encode '<009>' into  $sep
open 'c:\temp\temp.xls' as 1 for-writing record=200:vary
! write heading row information
write 'field1heading' $sep 'field2heading' $sep 'field3heading' .....etc
begin-select
field1
field2
field3

 write  field1 $sep field2  $sep field3 $sep ...............etc.
end-select
close 1
end-procedure temp

Hth,
Cheers,
Raji
----------
From:  Joe [SMTP:jejohn1216@SURFREE.COM]
Sent:  Wednesday, August 18, 1999 11:03 AM
To:  Multiple recipients of list SQR-USERS
Subject:  Using Excel to View a LIS File

Good Morning, Group!

I have a user who needs to view LIS files from an SQR in Excel (politics
sometimes rules where logic fails).

However, the number fields in the file (which are fine in the LIS) are
"screwy" in that negatives are left justified and large numbers spill into
each other.

My question is this -- have any of you folks ever heard of a program or
macro that converts LIS output into an Excel spreadsheet?!?

TIA

~~ JEJ ~~   ;{)

__________________________________________
$14.95 a month Unlimited Internet Access.
Get your first month for $1.00.
http://www.surfree.com/promo

------- End of forwarded message -------

~~ JEJ ~~   ;{)

__________________________________________
$14.95 a month Unlimited Internet Access.
Get your first month for $1.00.
http://www.surfree.com/promo