Re: cf and excel - freeze panes

2002-12-16 Thread Samuel R. Neff
At 12:19 PM 12/16/2002, you wrote: >When creating an excel spreadsheet with coldfusion, is there a way to >create what 'freeze panes' in excel does to lock the headers? > >thanks, >seth It's a part of the workbook's Windows property, in VBA you can access it like this: ThisWorkbook.Windows(1).F

RE: CF and Excel

2001-10-24 Thread Costas Piliotis
www.cfcomet.com has some really good examples of using Excel as a datasource. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 1:19 PM To: CF-Talk Subject: Re: CF and Excel fairly low tech approach but I have set up an access database that

RE: CF and Excel

2001-10-23 Thread Carlisle, Eric
Have you looked here? http://www.cfcomet.com EC -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 5:19 PM To: CF-Talk Subject: CF and Excel Is there a way to read in an Excel worksheet into a cf app, possibly through com, wit

Re: CF and Excel

2001-10-23 Thread Eric Dawson
fairly low tech approach but I have set up an access database that links to an excel spreadsheet that can be freely uploaded by site administrator. The access database has the DSN mapping. I use it so he can upload many new records at once, and is used as part of an import process. Eric Dawso

Re: CF and Excel

2001-06-22 Thread Dave Hannum
I do it a couple of ways. First, you can create a comma delimited file (.csv) and then using cfcontent, deliver it right to the browser to be downloaded, or you can write it to the server to be downloaded later. Or, I often use the CFX_EXCEL custom tag from the exchange. You need Excel on the s

RE: CF and Excel

2001-06-21 Thread David Shadovitz
David, You got that error because Excel is not registered on your server. Assuming that Excel is in fact installed on your server, you can register it by following the directions at http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=32381637-0922-41CA- BBE305C2D66A7025#2. Note that t