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
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
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
Re: Using Excel COM Object without installing Excel
or create an HTML file and set the mime type to excel. (works pretty slick). From: "Dave Hannum" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Using Excel COM Object without installing Excel Date: Fri, 27 Apr 2001 11:24:13 -0400 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
RE: Using Excel COM Object without installing Excel
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