Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Reading a desktop excel file

Former Member
0 Kudos

Hi all,

We have an issue in our production environment. There is an abap program that opens an excel file (located at user's desktop) and insert the information from it into a z table. It works fine, but on 3 new production servers it does not work (in other old ones it continue working). Basis team (as they always do) says that the configuration is the same on all those servers - I think they are wrong.

Actually I didn't debug it at those new production servers to see exactly what is the matter (to pass through all the bureaucracy process I will spend two days until get it).

As the program and the scenario are very simple I think that someone else problably have already found something like it. Some of you have a tip about it?

regards.

roberti

1 ACCEPTED SOLUTION

Former Member
0 Kudos

I had a similar problem once....and the solucion was in the security config.(account user control)

3 REPLIES 3

Former Member
0 Kudos

I had a similar problem once....and the solucion was in the security config.(account user control)

0 Kudos

Hi,

debugging on production server I found that the file is been opened and the data is been read. The problem is in a simple conversion from "0009" to hexadecimal and again to char. In one server (now I know that is HP-UX), this results in "####" string. In another server (Linux), the result is "\_###\_", replacing the "_" with an unrecognized char in the debugger. Some of you have already saw something like this?

thanks!

roberti

0 Kudos

Hi all,

solved the issue changing the conversion of character 0009 to hexa by usingl %_HORIZONTAL_TAB.

thanks.

regards.

roberti