Here is a post by Jason (CF Product Manager) discussing the use of JExcel with ColdFusion
http://www.cfinsider.com/index.cfm/2008/1/3/Modify-Excel-Spreadsheets-with-ColdFusion-the-easy-way HTH Qasim On Jan 28, 2008 10:26 AM, Marco Antonio C. Santos <[EMAIL PROTECTED]> wrote: > Ben Nadel created a very nice cfc called POIUtility.cfc. This ColdFusion > component works with POI to read/write excel spreadsheets. Please look > this > link: > > > http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm > > Cheers > Marco Antonio > > On Jan 28, 2008 6:56 AM, Richard White <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > we purchased a cfx called excel2query as we are developing an import > > facility that allows users to import data out of an excel document into > the > > mysql database. > > > > we have to do it into a query as then we run various verifications on > the > > data. > > > > however we have noticed that it gets the data that ms excel stores and > not > > what it displays. > > > > for example, in excel someone may put integer values 1,2,3 etc... in a > > column then they use the format cell to display it how they want, e.g. > > they may format these integers to a number with 1 decimal point. we need > to > > get these formatted values and not just what they entered first. > > > > does anyone know of anyway we can get ms excel to store the values it > has > > formated or any other tag that converts ms excel data to a query and > gets > > the actual displays value after formatting? > > > > thanks very much for your help > > > > richard > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
