If you use the content type trick to open HTML inside of Excel then you get content type warnings whenever you open the file. Creating native Excel files is harder to do, but I think the results are more professional, and you can make use of features like filter columns and calculation columns. If you haven't already done so, you should search the archives of this list since this topic has been discussed many times.
Another thing to consider is creating a PDF version instead since PDF files are often easier to create. PDF is a more common file format for invoices from what I have seen. -Mike Chabot On Mon, Oct 27, 2008 at 3:46 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > You can change your content type so that the browser thinks it is > downloading an Excel file. > > Google: cfcontent Excel cfheader > > -----Original Message----- > From: Brian Yager [mailto:[EMAIL PROTECTED] > Sent: Monday, October 27, 2008 2:15 PM > To: cf-talk > Subject: Best way to create an .xls file from a page > > 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:314408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
