Yeah, it is how my current export tag is setup but could not remember if it did this or not. I am pretty sure I have talked this issue before but done so many different Excel export methods over the years that they are all mixing up in my head. I do not think I used POI or building the XML to get this need before. Thought maybe I just put in a single quote before the number but testing that straight in Excel still leaves the single quote in the data but does not display it directly at least, so doubt it was that. If I do not see a response by tomorrow afternoon when I get to work then I will go digging and see if maybe I can figure out which project had the need and how I addressed it.
On 10/18/07, Dae <[EMAIL PROTECTED]> wrote: > > 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!!! > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
