Excel-Sheet to internal table

[Former Member]

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

[pokrakam]

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

[UweFetzer_se38]

see https://answers.sap.com/questions/289824/change-text-convert-xls-to-sap.html