RE: [sqr-users] Excel Formatting 2000

[James Womeldorf <jwomeldo@fastenal.com>]

Hi Satheesh,

If you are interested in a reliable method of creating spreadsheet files
using SQR you might take a look at http://www.ontko.com/sqr/sylk.html.
The production of SYLK files using these routines requires a little more
programming but allows you to do a fair amount of formatting of the cells in
the resulting spreadsheet.

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of p
satheesh kumar
Sent: Monday, December 06, 2004 7:15 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Excel Formating 2000


Hello,

I am doing integration from coldfusion to cgi and in cgi I am forming the
sqr command and executing the same and creating the .csv file. What my
problem is the comma seperated value(.csv) is able to open. When I am
opening in Excel 2003 the formatting looks good. I mean all the comma is
seperated with new column and results is displaying in each and every column
in good manner.

When I tried the same in Excel 2000. The results are coming in only one
cell. ( I mean with comma as a seperator. It is not showing in different
cell instead it is displaying with comma in only one cell e.g Microsoft
Technologies, AL, Alabama).

The code I used for forming and executing the sqr command is
$sqrcommand1 =
          "sqrt $Rptsqr $UIDPWD -E$ErrorFile -F$FileName -PRINTER:EP -EH_CSV
".
              " ". "$QUERY_ID" ." ". " ".           
              "\'". "$CLIENT_ID" ."\'". " ".           
              " ". "$ID" ." ". " ".
              "\'". "$PARAMETER1" ."\'". " ".
              "\'". "$PARAMETER2" ."\'". " ".
              "\'". "$PARAMETER3" ."\'". " ".
              "\'". "$PARAMETER4" ."\'". " ".
             " 1>/var/tmp/lm 2>/var/tmp/lm1" ; 

Could somebody help me out.

Thanks in advance,
Satheesh.

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

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