Re: [sqr-users] Excel Formating 2000

[P Mroz <zstringer999@yahoo.com>]

I have had good results with Excel 2000 writing
tab-delimited files, and naming them with the
extension ".XLS".  You can simply double-click on the
output files to open them with Excel.  Excel is smart
enough to notice that they are tab-delimited, and
opens the files correctly without needing to go
through a wizard.

I have statements in my code like this:

#define XLS_OUT 1               ! Excel file output #

    let $tab = chr(9)

    let $xls_line = 'Hello' || $tab || 'World' || $tab
|| 'Its' || $tab || 'Me'

    write {XLS_OUT} from $xls_line    




--- p satheesh kumar <sathkumar_p@rediffmail.com>
wrote:

> 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.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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