Need Help in Exporting to Excel using Coldfusion

Question

Hi,
While trying to do Export to Excel Using Coldfusion Microsoft
Excel is treating 'E' as an Exponential instead of a Text.
For Example while entering 25E95 as a Text Value it is
getting displayed in the Exported Excel Sheet as 25E+95.

I would like to know whether there is any work around to
resolve this Issues.

Expecting a Positive Reply ASAP.

Thanks,
With Regards,
Bala.

Anonymous · Answer

The dirtiest solution would be to append a ' before the text. It will look fine in excel and force the data to be text.

Ben Nadel has a POI utility that works quite well when writing to excel. In his utility you can even specify column types (with a little work) so that dates and text are formated properly.

http://www.bennadel.com/projects/poi-utility.htm

Good Luck,
Brendan

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded