RE: [sqr-users] Freeze column names in xls output file

["Peter Clark" <PGCLARK@vac-acc.gc.ca>]

Unlikely that MicroSoft would allow that :-)

>>> VXG@creditacceptance.com 2003/01/14 11:44:22 am >>>
Thank again Jim:

I have tried this, but in vain - SQR can neither directly create an
EXCEL file nor can append the data to an EXCEL file (not CSV file
format).  May be the future version of SQR can solve this issue.  

Ven


-----Original Message-----
From: James Womeldorf [mailto:jwomeldo@fastenal.com] 
Sent: Tuesday, January 14, 2003 12:09 AM
To: 'sqr-users@sqrug.org' 
Subject: RE: [sqr-users] Freeze column names in xls output file


Hi Ven,
You should be able to open the file For-Append instead of For-Writing. 
I
think that should work.
Jim


-----Original Message-----
From: Ven Garlapati [mailto:VXG@creditacceptance.com] 
Sent: Monday, January 13, 2003 1:43 PM
To: sqr-users@sqrug.org 
Subject: RE: [sqr-users] Freeze column names in xls output file


Thanks Jim,
For the helpful hint and Good Luck.  I think I am pushing my luck
here.
Does SQR allows appending (for-append) the data to EXCEL file -
(reading
from a csv file)?

Thanks,
Ven Garlapati 

-----Original Message-----
From: James Womeldorf [mailto:jwomeldo@fastenal.com] 
Sent: Friday, January 10, 2003 6:10 PM
To: 'sqr-users@sqrug.org' 
Subject: RE: [sqr-users] Freeze column names in xls output file


Hi Ven,

I've used the slk format quite a bit, and I'm quite certain freezing is
not
supported by slk.  

The way I usually test the compatibility of a feature is to create an
Excel
file with the feature I'm interested in.  Then I 'save as' the file to
the
.slk type.  Then I close Excel.  Finally, I double click on the
filename and
up it comes in Excel.  This is the test - is the feature still there? 
If
not, it is not supported and I forget about it.  If it is still there,
then
I load the file in a text editor and try to figure out how the feature
is
represented in the file so I can produce it in SQR.

Good luck.  
Jim

-----Original Message-----
From: Ven Garlapati [mailto:VXG@creditacceptance.com] 
Sent: Friday, January 10, 2003 4:19 PM
To: sqr-users@sqrug.org 
Subject: [sqr-users] Freeze column names in xls output file


Hi all,

I just used "slk file format" to produce a xls file.  It works great,
but
now the user wants the freeze the column names in the xls output, so it
will
be easy to scroll down or up on the data with column names visible on
top
all the time.  I have tried to use the same .slk file format for this
as
well, but in vain. Any information would be helpful.

Thanks,
Ven Garlapati 

_______________________________________________
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 

_______________________________________________
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 

_______________________________________________
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