Excel-Sheet to internal table

Former Member — Tue, 22 Aug 2017 08:07:50 GMT

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

Re: Excel-Sheet to internal table

pokrakam — Tue, 22 Aug 2017 12:00:19 GMT

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

Re: Excel-Sheet to internal table

UweFetzer_se38 — Tue, 22 Aug 2017 14:38:52 GMT

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

topic Excel-Sheet to internal table in Application Development and Automation Discussions

Excel-Sheet to internal table

Re: Excel-Sheet to internal table

Re: Excel-Sheet to internal table