Page 1 of 1

TEXT_CONVERT_XLS_TO_SAP and japanese Excel

PostPosted: Thu Jul 10, 2014 4:34 am
by Bebop
Hi gang,

I wrote a program that imports the contents of an Excel file by using function module TEXT_CONVERT_XLS_TO_SAP. Works just fine as it did for many years in other programs. Only in Japan it doesn't work, when using it from a japanese desktop the exception CONVERSION_FAILED is triggered.

Now, I just learned right now that this FM isn't officially released .... :oops:

So, looks as if I had to rewrite it for CSV format. However, is there any chance to get this to work ?

Best regards
Frank

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

PostPosted: Thu Jul 10, 2014 4:49 am
by Baz
Hi

You could try something like this:

http://wiki.scn.sap.com/wiki/display/Sn ... p+using+OO

it has been tested for Japanese - according to the Author...

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

PostPosted: Thu Jul 10, 2014 5:11 am
by Bebop
Thanks a lot for the hint. However, no japanese characters are used (e.g. material text). And the SAP system is unicode anyway, it is pretty much latest release (7.31, EHP6).

Could it theoretically help to work on the code page or something like that ?

Best regards