Thanks for the suggestion, but it seems to me that that would involve a lot
more processing (ODBC to read each record, CF to write each record back out
to a file) than simply opening the file with Excel and saving it as a text
file. We could be talking about thousands of records in this file, and I
don't think that CF is all that efficient at writing text files. I've got
the whole system working, and I can install Excel on the server if
necessary, but I'm just trying to find out whether it's possible to do it
(use the Excel COM object), without installing the whole shebang.
Thanks,
Bob
-----Original Message-----
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: April 27, 2001 1:50 PM
To: CF-Talk
Subject: Re: Using Excel COM Object without installing Excel
Then use the excel file as a data source in a query, then write it back out
to a text file.
Dave
----- Original Message -----
From: "Bob Silverberg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 12:39 PM
Subject: RE: Using Excel COM Object without installing Excel
No. I need to take an excel file, open it, and save it as a text file.
Thanks,
Bob
-----Original Message-----
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: April 27, 2001 11:24 AM
To: CF-Talk
Subject: Re: Using Excel COM Object without installing Excel
Are you wanting to create Excel .xls files to be deposited on the server?
If you're returning information to the browser where Excel with be engaged,
you have other options. Using CFCONTENT, you can return a comma delimited
file that will engage Excel and be read by it. You can do this without
Excel on the server.
Dave
----- Original Message -----
From: "Bob Silverberg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 11:10 AM
Subject: Using Excel COM Object without installing Excel
Does anyone know if one can access the Excel COM object using the CFOBJECT
tag without installing the full Excel application on the server? I am
wondering if there is just a type library, or a combination of DLLs that can
be installed on the server, rather than actually installing Excel. If you
have done this, it would be great if you could refer me to any instructions
you found regarding the installation.
Thanks,
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
