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

ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member
0 Likes
343

Hi,

I am using this FM to get the data from excel to an internal table. The problem is that, if I have the row which has more than 4096 characters, upto 4096 chars it is coming in first row, whatever is left, that's coming in second row......say like

The first row in excel is

4096 chars in bold

<b>ZISU_UK1 ZISU_UK2 ZISU_UK3.........ZISU_</b>UKN ZISU_ES

ROW COL VALUE

-


--- -


0001 001 ZISU_UK1

.

.

.

.

.

0001 n ZISU

0002 1 _UKN

0002 2 ZISU_ES

How to overcome this?. Is there any other FM without this limitation?.

Hope I am clear in explaining my problem.

Hi,

I am using this FM to get the data from excel to an internal table. The problem is that, if I have the row which has more than 4096 characters, upto 4096 chars it is coming in first row, whatever is left, that's coming in second row......say like

The first row in excel is

4096 chars in bold

<b>ZISU_UK1 ZISU_UK2 ZISU_UK3.........ZISU_</b>UKN ZISU_ES

ROW COL VALUE

-


--- -


0001 001 ZISU_UK1

.

.

.

.

.

0001 n ZISU

0002 1 _UKN

0002 2 ZISU_ES

How to overcome this?. Is there any other FM without this limitation?.

Hope I am clear in explaining my problem.

1 REPLY 1
Read only

gopi_narendra
Active Contributor
0 Likes
289

Hi

Please try this function module TEXT_CONVERT_XLS_TO_SAP

Regards

Gopi