Re: SQR - And SpreadSheets

[Sölving Björn <bjorn.solving@TEAM.ICL.SE>]

Makhari,

You are asking for an EXCEL-file created by SQR.
We have for a number of years used a "psuedo-xls" format, thats
actually a tab-separated ASCII file given a name such as foo.xls
Every line ends with CRLF. Just open in EXCEL and say OK to most
questions. The user may then format the sheet for best column-fit.

If you want a nicer method try this one:
SQR produces a text file where each row contains:
<row number><tab><column number><tab><actual text><tab>
<font name><tab><font size>

That file will then be read into EXCEL via a simple macro(VBA)
reading every SQR-line and producing a nice EXCEL-sheet,
(no graphichs, no formulas of course).

SYLK-format is another possible format, I have never used it....

Regards
Björn Sölving (ICL,Sweden)
bjorn.solving@team.icl.se

----------------------------------
Robert Goshko:
>Makhari,
>
>As far as I know, SQR cannot output in excel file format, but for a
spreadsheet,
>I have written to a flat file with either fixed column widths or delimited
>(comma or semicolon), this way the file could be opened by just about any
>spreadsheet program on the market.
>
>....Rob
>
>-----Original Message-----
>From:   Makhari T [SMTP:makharit@DP.NEW.ISCORLTD.CO.ZA]
>Sent:   Wednesday, March 11, 1998 6:26 AM
>To:     Multiple recipients of list SQR-USERS
>Subject:        SQR - And SpreadSheets
>
>Hi  !!!!!
>
>We've just written an SQR report program , but our users want to
>do manipulations to this report (as in change values on the report
>where needs be) using any spread sheet.  So we  thought of writing
>a report output to Microsoft Excel For windows 95  Version 7 ,
>Or any kind of  Spreadsheet that can be suitable for the above
>data manupulations.
>Can SQR produce an Microsoft Excel  file , or any Spreadsheet file ?
>If so how ??????
>
>Thanks in advance for your response to our  Question.
>
>
>
>Bye
>
>Tshenuwani Makhari
>
>"YOU ARE THE SUM TOTAL OF ALL THE EXPERIENCES
> YOU HAVE EVER HAD IN LIFE, AND A COMPOSITE OF
> ALL THE PEOPLE YOU HAVE EVER MET OVER THE YEARS."
>
>
>