Yup. that the way I usually do it. I build it in html then I just add a content header to send it to Excel.
On 10/18/07, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > Have you tried building an HTML table and putting that into Excel? > > On 10/18/07, Dae <[EMAIL PROTECTED]> wrote: > > > > Is there any way to set the field type in excel when outputting to it > > using > > coldfusion? > > > > I ask this because when I have a number that has leading zeros, they get > > dropped when output in excel. > > > > As an example lets say I have a table with name, id number. The ID > > numbers > > have leading zeros such as 0003732. When I output the web in a table, I > > get: > > Name ID > > John Doe 0003732 > > > > When I output to excel I get: > > Name ID > > John Doe 3732 > > > > Thanks!!! > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
