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

TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Postby 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
Bebop
 
Posts: 79
Joined: Mon Jun 06, 2011 9:13 am

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Postby 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
Baz
 
Posts: 4736
Joined: Fri Nov 08, 2002 5:54 am
Location: He's out there! somewhere!!!!

Re: TEXT_CONVERT_XLS_TO_SAP and japanese Excel

Postby 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
Bebop
 
Posts: 79
Joined: Mon Jun 06, 2011 9:13 am


Return to ABAP

Who is online

Users browsing this forum: No registered users and 7 guests





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