Skip to Content
0
Apr 24, 2014 at 08:46 AM

Need suggestion in uploading dynamic excel file to corresponding columns of internal table

13 Views

Hi Friends,

I have an excel file which doesn't have standard template. Just the users will key in their header (in row1 ) and followed by item details in excel and upload to internal table. Now by doing some internal developments in program I need to place the values in corresponding fields.

Let me explain with some examples.

1. I have an internal table

data : begin of itab occurs 0,

f1,

f2,

f3,

f4,

f5,

end of itab.

2. I have excel file as below

3 . Now i need to fill my internal table itab as below

Need to be placed in corresponding fields.

4. When I used GUI_UPLOAD FM it updates internal table as

Please give me suggestion on how to achieve it.

Thanks in advance.

Attachments

Capture.JPG (12.1 kB)
Capture1.JPG (13.5 kB)
Capture2.JPG (13.6 kB)