Or there is the java solution: You can easily use the jexcel api. I say easy, as in easier than POI. :-)
Really, it's quite nice, and lets you do whatever you want with excel. Two thumbs up! :den (Note that you must host the ODBC database on a microsoft server for the below idea.) On 4/27/06, Phillip B. Holmes <[EMAIL PROTECTED]> wrote: > > I think this is what you after. > You could setup a xls as a db in CF and just query the data from the > spreadsheet path. > > 1. Create an empty Excel spreadsheet (placeholder) > 2. Create a System DSN for the spreadsheet in the server's ODBC Data > Source > Administrator. > 3. Create an ODBC Socket data source in the ColdFusion Administrator, > pointing to the ODBC DSN created in step 2. > 4 Use the IN predicate within the query, specifying the path to the actual > spreadsheet to be used. > > <cfquery name="test" datasource="dynamicXLS"> > SELECT TN_ID > FROM [CF$] > IN '#path to your generated spreadsheet#' 'EXCEL 5.0;' > </cfquery> > > Warmest Regards, > > Phillip B. Holmes > http://phillipholmes.com > 214-995-6175 (cell) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239008 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54