If you're using CFMX, you can use the Jakarta POI API to do this.
http://jakarta.apache.org/poi/hssf/
Programmatically Manipulating Microsoft Excel Spreadsheets with the Apache POI API (Java code):
http://www.devarticles.com/c/a/Apache/Manupulating_Excel_Spreadsheets_with_Apache_POI/
Busy ColdFusion Developers' Guide to HSSF Features http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA
HTH,
Adrian
Daniel Elmore wrote:
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
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.
----------------------------------------------------------
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
