Sorry, wrong level of answer then. Here's one that calls the excel dll: http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn131&extID=100299 2#loc=en_us&view=sn131&extID=1002992&viewName=ColdFusion%20Extension&avm=1
CFObject is what you would use, not cffile as you do not know the format that Microsoft stores excel documents in, nor do you need to know, let the dll handle it. Jacob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Elmore Sent: Wednesday, January 05, 2005 1:14 PM To: [email protected] Subject: RE: Convert Excel File Out of those 1 billion ways which one is the easiest :) Is there not a way to do this with cffile and cfcontent, or a CFX tag? I don't care to write VB for this. Thanks! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jacob Cameron Sent: Wednesday, January 05, 2005 9:48 AM To: [email protected] Subject: RE: Convert Excel File Depending on what you are trying to do, there is 1 billion ways to do this. Below is just the way I would do it and have done it in the past. If you have an XLS file that you want as plain text, you have to do it through XLS (Or something that can read those types of files, which very by version). Record a macro of what you want to do. View Macro source, copy and paste it into VB (ASP, ColdFusion and PHP can all do it directly also by calling the Excel object, but I do not recommend it.) I'd do it in VB 6.0 as it will take about 30 minutes to setup and test completely and it is a more stable environment when dealing with server objects. Then about 30 minutes to deploy (If it's your first time). If you want to call it from CF, then create a VB Active X DLL. For command line, setup an EXE. You will have to be sure the excel DLL's or OLE's (I think it's OLE, can't remember exactly) are on the server you want to do this on, you can just copy it over or use the deployment wizard that comes with Studio. I haven't done it in .NET studio yet as no one will pay the $500 for me to upgrade, until Studio 2005 comes out:) I've done it through CF in the past and found that it works best calling through a DLL. Jacob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Ivanoff Sent: Wednesday, January 05, 2005 8:51 AM To: [email protected] Subject: Re: Convert Excel File the long way would be to make the spreadsheet a datasource, read it, make it into a string, then save it as plain text, cvs, or tsv On Tue, 4 Jan 2005 16:30:56 -0600, Daniel Elmore <[EMAIL PROTECTED]> wrote: > I am trying to convert XLS files to plain text, to either a CSV or > TSV. I can do this manually using excel, but I'm pretty sure > ColdFusion has a programmic way to do this. > > Any Ideas? > > Thanks! > Daniel Elmore > > ---------------------------------------------------------- > To post, send email to [email protected] To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
