SV: Convert data files to Excel
Jari.S.Kaljunen@telia.se
Jari.S.Kaljunen@telia.se
Tue, 11 Dec 2001 13:09:05 +0100
--openmail-part-227db01b-00000001
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
;Creation-Date="Tue, 11 Dec 2001 13:09:05 +0100"
Content-Transfer-Encoding: quoted-printable
The difference with csv and slk files is that slk opens without any=20
importroutine.
Doubleklick at this sylk file:
=20
I have not managed to get any formulas to work ( not even tried much=20
yet) but field formatting should be possible with the headers in the=20
beginning of the file.
I have not seen any documentation but I have laborated with saving the=20
file as slk in Excel.
Anyhow the users that can now open their files without importroutine=20
are happier than before.
Microsoft keeps the real Excel file format secret...
/Jari
=2D----Ursprungligt meddelande-----
Fr=E5n: chris.sharman@ccagroup.co.uk=20
[SMTP:chris.sharman@ccagroup.co.uk]
Skickat: den 11 december 2001 12:04
Till: jari.s.kaljunen@telia.se; powerh-l@lists.swau.edu
=C4mne: RE: Convert data files to Excel
I've looked at .slk before, in the hope that it could do more than=20
=2Ecsv, but
I never got to first base.
I understand the 'C' lines below, but not the rest: have you any more
documentation please =3F Also some indication of the capabilities of .sl=
k,
compared with .csv =3F
I would have written the file below as a csv:
Name ,Title ,Salary,Linenumber
Jari ,Programmer,Less , 1
Michael,Boss ,More , 2
Excel/csv: doesn't seem to care much about quotes, except to handle=20
embedded
commas;
isn't smart about column width (all become standard width);
can cope with wrapped lines (just put the right number of commas on a=20
page
heading);
doesn't support formulae (afaik), macros, keystrokes, multiple sheets,=20
etc.
Thanks, Chris Sharman
=2D----Original Message-----
From: jari.s.kaljunen@telia.se [mailto:jari.s.kaljunen@telia.se]
Sent: 11 December 2001 10:35
To: mx% dmthomas@longfibre.com; mx% powerh-l@lists.swau.edu
Subject: SV: Convert data files to Excel
There is a file format called SYLK (default suffix .slk) and which is
possible to open direct with Excel.
A sylk file looks like this:
ID;PWXL;N;E
P;PGeneral
P;P0
P;P#,##0
F;P0;DG0G8;M255
B;Y21;X4;D0 0 20 3
O;L;D;V0;K47;G100 0.001
F;P2;FF2G;C4
C;Y1;X1;K"Name"
C;Y1;X2;K"Title"
C;Y1;X3;K"Salary"
C;Y1;X4;K"Linenumber"
C;Y2;X1;K"Jari"
C;Y2;X2;K"Programmer"
C;Y2;X3;K"Less"
C;Y2;X4;K 1
C;Y3;X1;K"Michael"
C;Y3;X2;K"Boss"
C;Y3;X3;K"More"
C;Y3;X4;K2
E
Note the Y and X coordinates and quotes with charachter strings.
You can experiment with this by creating a Excel file and saving it as
Sylk file and editing the file. You will see that Excel creates much of
stuff in the beginning of the file (but only a little of it is really
needed).
We create first a subfile having the record number ( X coordinate) and
item number ( Y coordinate) and the item value. Then we run a quiz that
creates text file that is renamed to *.xls and it opens direct in Excel
on PC.
$quiz
acc *sub=5Fitem
init head &
tab 1 'ID;PWXL;N;E' &
skip tab 1 &
'P;PGeneral' &
skip tab 1 &
'P;P0' &
skip tab 1 &
'P;P#,##0' &
skip tab 1 &
'F;P0;DG0G8;M255' &
skip tab 1 &
'B;Y21;X4;D0 0 20 3' &
skip tab 1 &
'O;L;D;V0;K47;G100 0.001' &
skip tab 1 &
'F;P2;FF2G;C4'
sel if d=5Felem <> '" "' and d=5Felem <> ""
set rep nolimit spacing 0 dev disc name sylk nohead page length 0 width
255
def d=5Frad char*252 =3D &
trunc(pack('C;Y' + ascii(rec=5Fno) + ';X' + ascii(item=5Fno) + ';K' +
d=5Felem ))
rep tab 1 d=5Frad
final foot tab 1 "E"
go
/Jari
=2D----Ursprungligt meddelande-----
Fr=E5n: dmthomas@longfibre.com [SMTP:dmthomas@longfibre.com]
Skickat: den 11 december 2001 01:00
Till: powerh-l@lists.swau.edu
=C4mne: Convert data files to Excel
I'm trying to move a quiz subfile to Excel. I've emailed myself a text
file that I've renamed with the excel file extension which works fine
except when opening it, I have to tweek it a bit to make the columns fit=
correctly. I've delimited this file with a "|" and with a ",". Both do
the same thing. I would like to be able to have this file open without
having to tweek the file. Any suggestions=3F
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
<<Fil: Convert data files to Excel.TXT>>
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to=20
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
=2D---------------------------------------------------------------------=
=2D-
=2D---
=2D---
Date: Tue, 11 Dec 2001 11:26:21 +0100
=2D---------------------------------------------------------------------=
=2D
Any views expressed in this message are those of the sender and not
necessarily those of CCA Group. The unauthorized use, disclosure,
copying or alteration of this message is forbidden. The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed. Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to=20
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to=20
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
<<Fil: RE=5F Convert data files to Excel.TXT>>=20
--openmail-part-227db01b-00000001
Content-Type: application/msexcel
Content-Disposition: attachment; filename="test.xls"
;Creation-Date="Tue, 11 Dec 2001 13:09:05 +0100"
Content-Transfer-Encoding: base64
SUQ7UFdYTDtOO0UNClA7UEdlbmVyYWwNClA7UDANClA7UCMsIyMwDQpGO1AwO0RHMEc4O00y
NTUNCkI7WTIxO1g0O0QwIDAgMjAgMw0KTztMO0Q7VjA7SzQ3O0cxMDAgMC4wMDENCkY7UDI7
RkYyRztDNA0KQztZMTtYMTtLIk5hbWUiDQpDO1kxO1gyO0siVGl0bGUiDQpDO1kxO1gzO0si
U2FsYXJ5Ig0KQztZMTtYNDtLIkxpbmVudW1iZXIiDQpDO1kyO1gxO0siSmFyaSINCkM7WTI7
WDI7SyJQcm9ncmFtbWVyIg0KQztZMjtYMztLIkxlc3MiDQpDO1kyO1g0O0sgMQ0KQztZMztY
MTtLIk1pY2hhZWwiDQpDO1kzO1gyO0siQm9zcyINCkM7WTM7WDM7SyJNb3JlIg0KQztZMztY
NDtLMg0KRQ==
--openmail-part-227db01b-00000001--