Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem with ALSM_EXCEL_TO_INTERNAL_TABLE and TEXT_CONVERT_XLS_TO_SAP

Former Member

‎07-23-2009 11:23 AM

0 Kudos

Hi,

when i was testing the function module ALSM_EXCEL_TO_INTERNAL_TABLE to upload data from EXCEL to internal table it gives UPLOAD_OLE exception. But when I tested the same in other system it works. I dont know what's the problem withmy system. Does any configuration require for this?

And when using TEXT_CONVERT_XLS_TO_SAP functin module conversion_failed exception is raised.

Could anyone help me in this.

Regards,

Tom

4 REPLIES 4

Former Member

‎07-23-2009 11:27 AM

0 Kudos

Hi,

Please check the data types of your importing parameters for both the FMs. Cross check with SE37.

Former Member

‎07-23-2009 11:30 AM

0 Kudos

I'm passing the variables with same datatypes as in functin modules

Sm1tje
Active Contributor
In response to Former Member

‎07-23-2009 12:18 PM

0 Kudos

The UPLOAD_OLE error usually occurs upon passing the incorrect path for the excel file you want to upload. Make sure that the path is correct. Seems you are using two different systems, so this could be caused by an incorrect path.

Former Member

‎07-23-2009 12:15 PM

0 Kudos

As you told your code is working fine in other system except your system. That means your system has got some problem with MS Excel. May be it is corrupted or some thing. I have experienced the problem like you when I was using TEXT_CONVERT_XLS_TO_SAP fm. But reinstall of excel solved my problem.

Regards

Shiba Prasad Dutta