2006 Sep 29 5:52 AM
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.
2006 Sep 29 5:59 AM
Hi
Please try this function module TEXT_CONVERT_XLS_TO_SAP
Regards
Gopi
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |