read multiple entries into iternal table

[Former Member]

Hi Gurus,

i have to read an excel sheet from presentation server into internal table.the excel sheet has 7 fields.out of the 7 fields four fields have multiple data entries.how to read all into a single internal table.

E.g.

let us suppose the fields are

pri,pric,prit,vfro,vto,frbl & pamt.

out of these in vfro,vto,frbl & pamt the data is repeated for the same set of data in pri,pric,prit.

So can you tell me how to populate the iternal table with syntax and the same example?

All replies will be rewarded.

[Former Member]

hi,

Function Group-KCDE Data transfer from PC files

Function Module-KCD_EXCEL_OLE_TO_INT_CONVERT

Desc:

Uploads an *.xls file to internal table (max cell length = 32). Example. This function uses a range selection and copy-paste technique, therefore it quite fast.

Try this, not sure if it would work.

Hope this helps, Do reward.