On Tue, May 20, 2008 at 12:31 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Is there not an easy way to import several one sheet excel files into > one workbook file with each previous file in its own sheet? > > I am not seeing it in my Excel wondering.
JExcelAPI will do it easy. At least easier than POI. Here's some example code (reading in workbooks, turning worksheets into queries, and turning queries into worksheets, which are then stuck in a workbook, etc..): http://code.google.com/p/cfjexcel/ You can even copy graphs and stuff from sheet to sheet... as a workaround to do some stuff you can't do in POI (last I checked). Formulas and whatnot are cake... a pimp little API, IMO. :d -- CNN is one of the participants in the war. I have a fantasy where Ted Turner is elected president but refuses because he doesn't want to give up power. Arthur C. Clarke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:260439 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5