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

[Franck Masson <franck.masson@BRIO.COM>]

James,

when i have to provide a .SLK file formatted as the enduser expect.
I use excell to create the template with 2 or 3 lines.
then i save it in .slk format.
open it in notepad
cut it in 3 parts
the header with column heading that i store in top.txt file
the line of value
that i code in sqr
the bottom that i store in bottom.txt file ( if there is some sum at the
end)

then in my SQR code
1) i copy the top.txt in result.xls
2) create the line using sqr to write to result.xls
3) copy the Bottom.txt in result.xls

you can have something like this ( see attachment)
( in the attachment i have coded in sqr top.txt, but it is easy to store
it in a file and read this file and add it to result.xls.)

Franck,

PS: You have to optmise the way you design your excell template.
do not apply multiple time the format of cells.



James Womeldorf wrote:
>
> Has anyone out there messed around with the .SLK format for writing text
> files to be opened by Excel?
> Preliminary tests I have done look hopeful.  Leading zeros in strings like
> 0010 can be retained, and it is even possible to format columns (and
> individual cells, I expect) but the format of the file is a bit odd (and
> terse).
> If anyone knows just how the .SLK files are laid out I would be interested.

laposte.xls

Copie.sqr

begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard