Application Development 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: 

Please provide a solution for this problem

Former Member
0 Kudos

Hi,

I need to upload a excelfile into database table.

i am using the function module KCD_EXCEL_OLE_TO_INT_CONVERT.

this fm reads cell by cell in excel and the internal in which we are going to upload trhe data from the excel is of type kcde_cells.

This table kcde_cells has three fields

1.row

2.col

3.value

row and col stores row and column no and value stores the value in a particular row and column.

this field value is type char with length 32.

but my value of length 54.

so i can upload until 32 charecters but i need all the 54 charecters.

How can i upload the entire value that is of legnth 54.

Regards,

Chaithanya.

1 REPLY 1

Former Member
0 Kudos

Hi,

You can do it in 2 steps,

1. Use Gui_Upload to upload the excel sheet into an Internal table

2. Loop at ITAB.

Insert ZTAB from ITAB.

Endloop.

Try this,

KC