I suspect you won't get much help with this. I've never seen CFTABLE used to produce Excel content - although under the hood it produces HTML so I guess why not.
Still, I think most of us (myself included) would suggest a different method with more control over formatting ... Like creating HTML Table with cfoutput (for the simple apporach) or usuing POI. -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: vidya yegnaraman [mailto:[email protected]] Sent: Wednesday, August 12, 2009 3:45 PM To: cf-talk Subject: cftable query Hi, I am a newbie to coldfusion. I have a code that has to write some data to an excel sheet. Below is the code snippet for it. <CFHEADER NAME="Content-Disposition" VALUE="attachment; FILENAME=test.xls"> <CFCONTENT TYPE="application/msexcel"> <cftable query = "sql" startRow = "1" colSpacing = "3" colheaders> What happens is, when the excel opens up, data is printed from A34581 and not A1. Can any please help me with this as it is very urgent. Thanks much in advance karth ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
