Home » Developer & Programmer » Application Express & MOD_PLSQL » when apex report save to csv format it change the data (apex 3.1)
when apex report save to csv format it change the data [message #575565] Thu, 24 January 2013 03:02 Go to next message
Messages: 195
Registered: July 2005
Location: Karachi
Senior Member

Dear all Experts

i have a report build in apex and working fine, By using interactive report features i save report output in csv form. It saves without any problem. But when i open this csv file in EXCEL it doesn't occur in actual form.

the sample data is like that
00010016263201	117728	C
00170006361701	80508	C
00170008794601	54276	C
00170010501801	62567	C
00177900171703	38349	C
00240010786501	127046	C
00270078809903	89132	C
00280015930203	351366	C

The first column is CARD number and you see there are some leading zero's in it, but when it open it in excel the leading zero's are gone and with some cells the data displaying with E+11.
10016263201	121309	C
1.70006E+11	79181	C
1.70009E+11	53197	C
1.70011E+11	61391	C
1.779E+11	37383	C
2.40011E+11	146011	C
2.70079E+11	97052	C
2.80016E+11	401702	C
2.80022E+11	374384	C

I tried concatenating with ',^, chr(32), but all in vain. Is there anyone who know how can i get out of this problem . Any idea will be appreciable.



Re: when apex report save to csv format it change the data [message #575596 is a reply to message #575565] Thu, 24 January 2013 10:46 Go to previous message
Messages: 19329
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It looks more like an Excel problem, not Apex. What happens if - in Excel - you modify the first column's type to "Text"?
Previous Topic: Moving APEX screens from one schema to other schema
Next Topic: Master_Detail Problem
Goto Forum:

Current Time: Tue Jul 29 17:30:42 CDT 2014

Total time taken to generate the page: 0.05636 seconds