Skip to Content
avatar image
Former Member

Excel Upload

Hi,

I am trying hard to convert excel 2003 to a internal table but failed to do so , tried many techniques such as using function module HR_KR_XSTRING_TO_STRING but none of them are working for all instances.

Is there any released version of code,class or function module there which can convert xstring to string.

Please dont answer if you are not sure or have not implemented it before.

thx

Mithun

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 20, 2011 at 06:28 PM

    >Is there any released version of code,class or function module there which can convert xstring to string.

    Yes there is, but that isn't what you need. The problem is that Excel format is a propriatery, Microsoft binary format. You can't just simply convert it to a string. That said there aren't any released classes or function modules to convert binary office 2003 format to an internal table. People generally use a text based Excel format (like tab delimited) or XML. These formats can be converted to STRING and then parsed using various functionalities.

    Add comment
    10|10000 characters needed characters exceeded