On RIA Forge, I remember this project: http://cfxl.riaforge.org/
Description: CFXL lets you quickly and easily create new spreadsheets and modify or read data from existing spreadsheets. This project abstracts and simplifies the POI API while still allowing you to get into the depths of that API. Support and other licenses available if needed. This will make your Excel nightmares go away. :) I have not tried it, but it has been updated recently and may remove some of what you are trying to achieve. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Fri, Mar 6, 2009 at 9:42 AM, <bki...@ups.com> wrote: > Dusty, > > I have used the Java POI tool in the past. It's easy to implement, > it is very fast (even at thousands of records and multiple worksheets) at > reading/building an excel document. > > I found this link on Ben Nadel's blog, he has built a nice cfc utility to > do the work for you, you may just have change a few mappings. > > http://www.bennadel.com/blog/469-Creating-Microsoft-Excel-Files-Using-ColdFusion-And-POI.htm > > > You should definitely be able to use it to read the excel file and then > insert into the db, as far as a custom tag to do both (file upload & read), > I do not have that. If you don't specifially need the file you can use the > POI utility to read it on the fly and then import. > > Blake > > > > Blake Kiser > UPS - Business Information & Analysis > SCS - S530A > 12380 Morris Rd. > Alpharetta, GA 30005 > (678) 746-4679, atlas 480-4679 > > > ------------------------------ > *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Dusty Hale > *Sent:* Friday, March 06, 2009 9:31 AM > *To:* discussion@acfug.org > *Subject:* [ACFUG Discuss] excel or csv to database table > > Hi I need to implement some CF code that does this and before I write > all the code, I thought certainly there has got to be a custom tag or cfc > that already does this: > > 1. Upload excel or csv file to server. > 2. Import the excel sheet or csv file into a database table. > > I found an upload custom tag and now I am looking for any advise or > recommendation on a custom tag or cfc or piece of code that will handle the > import part. If anyone knows of a good solution for this, please share. Much > appreciation! > > Thanks, > > Dusty > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform<http://www.acfug.org/?fa=login.edituserform> > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink <http://www.fusionlink.com/> > -------------------------------------------------------------