It probably won't help at all, but I've got a bit of code that uses jexcelapi, and converts queries to excel workbooks.
It puts each query in a worksheet, and has some simple formulas and whatnot, but I don't think that would do any good for what you're trying to do. Unless you've already got it broken down into queries, and one query per workbook sheet is ok. :-/ Again, probably not gonna help in this case, but hey, it's an option. *shrug* On 7/5/07, Will Tomlinson wrote: > > I'm just using <cfcontent> to force excel to open a .cfm page with some > generated tabular output. No problem with that part. > > My problem is I have some nested side-by-side tables. Excel is reading > those in and stacking them vertically. > > I tried sticking some special characters in the output, then replacing > them with Chr(9). No luck. > > Am I in need of scrapping this idea since my tables are a little complex? > And just using Ben's POI utility to build the .xls by hand? > > Thanks, > Will > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
