Community
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
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: 
Read only

UPLOADING DATA FROM EXCEL FILE.

Former Member

‎2008 Aug 25 3:40 PM

0 Likes
522

Hi All,

i have to upload the data from excel file to an internal table.I am using FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' for that. But the problem is it taking upto 50 characters only from each cell of excel sheet. in each cell i have more than 100 characters.

How to read these type of data?..

Plz help me in this regard.

thank you in advance!!!!

Regards,

Ravi

Hi All,

i have to upload the data from excel file to an internal table.I am using FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' for that. But the problem is it taking upto 50 characters only from each cell of excel sheet. in each cell i have more than 100 characters.

How to read these type of data?..

Plz help me in this regard.

thank you in advance!!!!

Regards,

Ravi

Reply
3 REPLIES 3
Read only

Former Member

‎2008 Aug 25 4:15 PM

0 Likes
485

Hi

U try this FM: TEXT_CONVERT_XLS_TO_SAP

Regards:

Prabu

Read only

Former Member

‎2008 Aug 25 4:19 PM

0 Likes
485

Bset thing is to copy ALSM_EXCEL_TO_INTERNAL_TABLE to

ZALSM_EXCEL_TO_INTERNAL_TABLE and inside the FM in tables section, ALSMEX_TABLINE replace with ZALSMEX_TABLINE... inside ZALSMEX_TABLINE change VALUE to CHAR100 type.

Read only

Former Member

‎2008 Aug 27 11:50 AM

0 Likes
485

Hi,

Check my previous post for the same question for referance

Guess this will help you.

Regards,

Ram.