topic Re: Execl down load in Application Development and Automation Discussions

Execl down load

Former Member — Fri, 05 Jun 2009 14:38:46 GMT

Hi,

when i am trying the data down load from ALV to excel, Bin field is converting into Date format.Canyou please guide me how to solve it.

Example

Bing 01-01-01

While downloading it is converted into excel as 01/01/2001.

Thnaks

Yarava

Re: Execl down load

Former Member — Fri, 05 Jun 2009 15:37:55 GMT

Change the Excel cell properties or before downloading the values concatenate ' single quote to the

field and download to excel sheet ...

Re: Execl down load

Former Member — Fri, 05 Jun 2009 15:55:56 GMT

thanks for u r reply.

it is workiing fine if we concatenate bin with '.' one dot instead space.

But storage bin number will come along with dot.so it make difereence.

this problem not only from my report but alos when i down load data from table LINV alos i am getting same issue.

Thanks

Yarava

Re: Execl down load

Former Member — Mon, 08 Jun 2009 08:47:09 GMT

Hi guys,

are u aware of decarling hidden character in sap.

Thanks

Ramki

Re: Execl down load

rejish_balakrishnan — Mon, 08 Jun 2009 09:51:54 GMT

Hi,

This is obviously the problem with settings in MS excel .please change the settings for the same .

If u dont know how to change settings then open the excel sheet after uploading and select the entire column .

Then , goto tools---> options -->calculations (precision as displayed )

Also try changing the value of " fixed decimal places " to zero .

Re: Execl down load

Former Member — Mon, 08 Jun 2009 10:27:50 GMT

Hi,

i tried this option,but not worked,thanks for your reply.

is there other option for this.

Thanks

RAMKI

Re: Execl down load

rejish_balakrishnan — Mon, 08 Jun 2009 10:41:29 GMT

Sorry that my idea didnt worked out .But i encountered the same problem earlier also .After a long research i found the problem is with the MS excel .

But i am not quite sure which option i tried in options tab to make it work .

Maybe i am trying to contract your doubt to a smaller angle by asking u to concentrate on excel instead of messing with sap itself.

For confirming the same use any excel from other system or reinstall it on your system .

For eg : Sometimes selecting the fixed point decimals check box would make all the numbers to floating point notation even if the table data is not in floating point format .You cannot blame sap for this ... right !

Re: Execl down load

Former Member — Mon, 08 Jun 2009 12:14:45 GMT

Hi,

what you are telling is right, but my problem with char data type.Like bin is char(10),how it is converting into date format.is a big question,

Now i came to know that when u type 01-01-01 in cxcel and press enter excel is converting it automatically like 01/01/2001.

further analysis is required on this.

i am rewarding point to you.

Thanks

ramaki

Re: Execl down load

rejish_balakrishnan — Mon, 08 Jun 2009 12:47:24 GMT

Hi,

To add to this , there are many scenarios where i was really getting weird in the project especially with excel sheet .

Some scenario which u should be careful with in mere future are .

a) Automatic increment of numbers when an tab is encountered when a file is uploaded with tab delimiter used.

b) When character field starts with '+' .

eg: mysap it would show cell address (A4B3 )

c) Date field conversion .

d) Blank spaces in between character .

As per your above try , i got it as "1/1/2001" and not "01/01/2001" .

If you right click on particular cell and select format cells option and then Number tab and then select date as dd/mm/yy format , u would get "1/1/01" .

select ctr l + A and do this for all field . u will get the desired output .

if you want this to be followed for all excel sheets then configure by following the menu "tools-->options" as mentioned in my previous reply ..