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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.