OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » when apex report save to csv format it change the data

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » when apex report save to csv format it change the data (apex 3.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

when apex report save to csv format it change the data [message #575565]

Thu, 24 January 2013 03:02

annu-agi
Messages: 237
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.

regards

Anwer

Report message to a moderator