Application Development and Automation 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
Showing results for 
Search instead for 
Did you mean: 
Read only

Error using TEXT_CONVERT_XLS_TO_SAP to upload file.

Former Member
0 Likes
574

Hi all,

I have a requirement in which i have nearly 150 columns in an excel sheet that has to be uploaded in a bdc program. I am using the fm TEXT_CONVERT_XLS_TO_SAP. The problem is upto 92 columns i have no issues but when i debugged i saw that in the fm the saprange is 92. Is there any other way or fm that can be used to meet the requirement.

Thanks in advance,

Ashok

Hi all,

I have a requirement in which i have nearly 150 columns in an excel sheet that has to be uploaded in a bdc program. I am using the fm TEXT_CONVERT_XLS_TO_SAP. The problem is upto 92 columns i have no issues but when i debugged i saw that in the fm the saprange is 92. Is there any other way or fm that can be used to meet the requirement.

Thanks in advance,

Ashok

3 REPLIES 3
Read only

former_member404244
Active Contributor
0 Likes
548

Hi,

Try to use the FM "ALSM_EXCEL_TO_INTERNAL_TABLE".

Regards,

Nagaraj

Read only

0 Likes
548

Hi Nagraj,

Is it a must to sort the data while using the fm ALSM_EXCEL_TO_INTERNAL_TABLE.

Read only

0 Likes
548

Hi,

Please search in SCN on this topic and you will get the information..

Regards,

Nagaraj