I wouldn't say it is the *best* way but this will maintain table layouts: http://mgt.pastebin.com/f27bd1c5a
Another way to do it is what Mike Chabot suggested. Yet another way: Create a spreadsheet and fill the places where you want your data to go with CF vars #.yourQury.yourVar# and then save as XML or HTML (I forget) and use the above method to populated it and force it to the browser. HTH ~G~ On Mon, Oct 27, 2008 at 3:14 PM, Brian Yager <[EMAIL PROTECTED]>wrote: > Hi all, > > I have a page that creates an invoice. I need to be able to make an Excel > spreadsheet out of it. It does have different sized tables in it. What is > the best way to do this? I have saved the page as a .xls and it was > perfect. Just need to do this automatically now. > > Thanks! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
