CodingForums.com - View Single Post - How to convert javascript array to coldfusion array?

Gjslick · 08-12-2011, 08:30 PM

It would be very hard to determine the format of the data having a user just copy and paste things from an excel file into a textarea. Try it out yourself and see how it looks, lol.

There is a way where you can upload excel files and process them though. Look up how to upload files, and then you can possibly use a Java library called "POI" to read the spreadsheet. Using that is pretty advanced though, so I don't know if you want to get involved. Some people have written ColdFusion wrappers for the POI library to make it a bit simpler however. Here's an example: http://www.bennadel.com/projects/poi-utility.htm, and a bit on how to use it: http://www.bennadel.com/blog/474-Col...xcel-Files.htm

08-12-2011, 08:30 PM	PM User \| #8
Gjslick Regular Coder Join Date: Feb 2009 Location: NJ, USA Posts: 476 Thanks: 2 Thanked 70 Times in 69 Posts	It would be very hard to determine the format of the data having a user just copy and paste things from an excel file into a textarea. Try it out yourself and see how it looks, lol. There is a way where you can upload excel files and process them though. Look up how to upload files, and then you can possibly use a Java library called "POI" to read the spreadsheet. Using that is pretty advanced though, so I don't know if you want to get involved. Some people have written ColdFusion wrappers for the POI library to make it a bit simpler however. Here's an example: http://www.bennadel.com/projects/poi-utility.htm, and a bit on how to use it: http://www.bennadel.com/blog/474-Col...xcel-Files.htm