read multiple entries into iternal table

Former Member — Thu, 07 Feb 2008 12:01:44 GMT

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.

Re: read multiple entries into iternal table

Former Member — Thu, 07 Feb 2008 12:16:11 GMT

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.

topic read multiple entries into iternal table in Application Development and Automation Discussions

read multiple entries into iternal table

Re: read multiple entries into iternal table