UPLOADING DATA FROM EXCEL FILE.

[Former Member]

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

[Former Member]

Hi

U try this FM: TEXT_CONVERT_XLS_TO_SAP

Regards:

Prabu

[Former Member]

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.

[Former Member]

Hi,

Check my previous post for the same question for referance

Guess this will help you.

Regards,

Ram.