Re: converting excel to text file
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 funandlrnn...@gmail.comwrote: 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
converting excel to text file
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:338992 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: converting excel to text file
You can also just use the CFSPREADSHEET tag and related functions in ColdFusion 9. -Adam On Tue, Nov 9, 2010 at 11:19 AM, John M Bliss bliss.j...@gmail.com wrote: 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 funandlrnn...@gmail.comwrote: 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:339000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm