topic Re: UPLOADING DATA FROM EXCEL FILE. in Application Development and Automation Discussions

UPLOADING DATA FROM EXCEL FILE.

Former Member — Mon, 25 Aug 2008 14:40:17 GMT

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

Re: UPLOADING DATA FROM EXCEL FILE.

Former Member — Mon, 25 Aug 2008 15:15:42 GMT

U try this FM: TEXT_CONVERT_XLS_TO_SAP

Regards:

Prabu

Re: UPLOADING DATA FROM EXCEL FILE.

Former Member — Mon, 25 Aug 2008 15:19:07 GMT

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.

Re: UPLOADING DATA FROM EXCEL FILE.

Former Member — Wed, 27 Aug 2008 10:50:15 GMT

Hi,

Check my previous post for the same question for referance

Guess this will help you.

Regards,

Ram.