This website is not affiliated with, sponsored by, or approved by SAP AG.

TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Post Reply
Bebop
Posts: 79
Joined: Mon Jun 06, 2011 9:13 am

TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Post by Bebop » Thu Jul 10, 2014 4:34 am

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

Baz
Posts: 4743
Joined: Fri Nov 08, 2002 5:54 am
Location: He's out there! somewhere!!!!
Contact:

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Post by Baz » Thu Jul 10, 2014 4:49 am

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...
Baz

AsPiRiNg tUlY iDiOt Image

http://www.catb.org/~esr/faqs/smart-questions.html

Image

check out my Podcasts http://dj-baz.podomatic.com

Bebop
Posts: 79
Joined: Mon Jun 06, 2011 9:13 am

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Post by Bebop » Thu Jul 10, 2014 5:11 am

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

Post Reply