Use something like http://cflib.org/udf/parseExcel to read the Excel into a struct of arrays and then use, for example, http://cflib.org/udf/StructOfArraysToQuery -> http://cflib.org/udf/QueryToCsv to create the text file.
On Tue, Nov 9, 2010 at 10:06 AM, fun and learning <[email protected]>wrote: > > HI All - > > I am uploading an excel file using coldfusion. Once the file has been > uploaded, I want to convert it to a text file. What I am trying to do now is > once the file is uploaded, I am reading the excel file and then writing the > output to text file. but the write method creates all junk in the text file. > > What is the best way to do this? > > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
