Hi, I am able to export into EXCEL from the coldfusion stuff, But i am getting problem when the data contains like 9E124 after export into excel it is showing like 9.00+124. Please give me your valuable suggestion on this to resolve this issue. I need the data in EXCEL also like 9E124 instead of 9.00+124. Reply me as early as possible.
Hi I don't think u can do this, since you have to manually change it in excel sheet by selecting those cells > right click > Format Cells > 'Number' Tab > Text. Or if you don't mind this one extra character, just put ' before the text which is displayed as scientific number. Eg. <td>'9E124</td> Code (markup): I think this would be OK for you. And don't forget to say thanks if you liked my opinion.
You could actually try to use XML to create the document. http://www.bennadel.com/blog/461-Creating-Microsoft-Excel-Documents-With-ColdFusion-And-XML.htm