Skip to Content

Excel-Sheet to internal table

Hi Guys,

i wrote a program that reads an Excel-File and gives me for every Sheet an internal table like this:

ROW | COLUMN | VALUE

I transformed this out of 2 records into this with some Coding:

KEY | VALUE

But i Need all this into an structure / internal table which Looks like this:

VALUE | VALUE | VALUE | VALUE | VALUE

The Header of this structure / internal table is the same as the first row of the Excel.

I tried Looping my NameValueTable into this structure but this is not really performant... Is there a possibility to upload my Excel directly into the structure, for every sheet? Because every sheet Looks different and Needs an other structure.

Thanks for your help! :)

Alex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 22, 2017 at 12:00 PM

    I really really recommend looking at the most excellent ABAP2XLSX project. Easy to find using your favorite search engine.

    Add comment
    10|10000 characters needed characters exceeded