RE: [sqr-users] creating a .XLS Excel file

["Simpson, Don I \(UK\)" <Don.I.Simpson@baesystems.com>]

Ashwin,

I've done a fair bit of this, using Symbolic Link (SYLK)

Some hints:
1       The avaiable documentation of SYLK is scant and not in any great
depth.
2       There are some Excel features, mainly sophisticated ones like
cell borders, lines, worksheets, etc., that it seems not to be able to
represent. It can do colours.
3       The SYLK format is complicated. I've found the best way to grab
it for the end-user purpose is to create a simple spreadsheet of what
you want your end-user output to look like, save it as SYLK, look at the
SYLK in a text editor, and try to interpret what you are seeing (not
always easy).
4       The format requires three basic "types" of output; what I will
call pre-amble, then column headers, then cell data. If you build your
example spreadsheet bit by bit, you can see what these look like., i.e.
first of all, save an empty spreadsheet as SYLK, that will give you the
preamble, then add your column headers, etc..
5       You can manipulate fonts a bit, but, again, it's not crystal
clear how it works.
6       If you get SYLK interpretration errors from Excel when you
attempt to open your output, it can be very difficult to work out where
they actually are, as the line numbers that Excel gives seem to bear no
relationship whatsoever to the number of "lines" in your SYLK. The
problem is is knowing what SYKL thinks is a "line" (it isn't the number
of text lines in the file, for starters!!!)

Hope this helps. If I can help any more, just post your request through
the forum.

Regards,


Don Simpson
 
Sent by BAE Systems plc or a member of the BAE Systems group of
companies
BAE Systems plc
A company registered in England and Wales  Company Number 1470151
Registered Office: 6 Carlton Gardens, London SW1Y 5AD, United Kingdom

-----Original Message-----
From: sqr-users-bounces+don.i.simpson=baesystems.com@sqrug.org
[mailto:sqr-users-bounces+don.i.simpson=baesystems.com@sqrug.org] On
Behalf Of Arun Kumar
Sent: 12 April 2007 21:45
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] creating a .XLS Excel file

               *** WARNING ***

This mail has originated outside your organization, either from an
external partner or the Global Internet. 
     Keep this in mind if you answer this message. 

 You can try creating 'sylk' format files excel will open them.

Search the home page for 'sylk' and slk .. You will get lots of hits..

----- Original Message ----
From: ashwin reddy <ashwin443@yahoo.co.uk>
To: sqr-users@sqrug.org
Sent: Thursday, April 12, 2007 3:51:47 PM
Subject: [sqr-users] creating a .XLS Excel file

I have created a lot of csv files. But i always wanted to create a .xls
file so that all the leading zeros would be visibile.

Has anyone written a sqr  that can generate a excel file output using
SQR's.

I even know that the leading zeros in csv can be visible if we use
="number" ....i just want to know if there is a way a .xls report file
can be generated using sqr's

Thanks,
Ashwin


      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try
it now.
http://uk.answers.yahoo.com/ 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users







       
________________________________________________________________________
____________
TV dinner still cooling? 
Check out "Tonight's Picks" on Yahoo! TV.
http://tv.yahoo.com/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users