cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Upload

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

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

Former Member
0 Kudos

Thank you sir, Got you.

Thx

Mithun

Former Member
0 Kudos

Hi ,

I would appreciate if you could tell me , how this conversion is supported for SAP GUI frontend applications..

Thx

Mithun

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

With the SAPGUI, we use Office Automation. On the client side we open Excel as a control within the SAPGUI and allow Excel to perform the conversion. This is one benefit to running as a client application instead of in a web browser.

Former Member
0 Kudos

Thanks a lot.

Answers (0)