Import excel file with the hierarchy data.

[Former Member]

How to import the tree of data from excel file(Picture 1 below)? I want to fill layout of this form and then export excel file(Picture 2 below)?

Pic.1

Pic.2

[lenastodal]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful) and share screenshots of what you've seen/done. The more details you provide, the more likely it is that members will be able to assist you.
Should you wish, you can still edit your question.
Finally, if you're hoping to connect with readers, please consider adding a picture to your profile as it encourages readers to respond to you. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS.

Best,
Lena
SAP Community Moderator

[Sandra_Rossi]

Do you want to create an ABAP program which reads an XLSX file and writes another XLSX file? If yes, use abap2xlsx for both reading and writing.

[Former Member]

Can we use XLSX workbench to solve this task? I can't find any fully documment of abap2xlsx, the host website abap2xlsx.org have closed.

[Sandra_Rossi]

XLSX workbench, I don't know. Less powerful than abap2xlsx.

You have hundreds of links to abap2xlsx in the Web. It's a github project.