topic Re: Import excel file with the hierarchy data. in Application Development and Automation Discussions

Import excel file with the hierarchy data.

Former Member — Thu, 26 Nov 2020 21:27:23 GMT

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

Re: Import excel file with the hierarchy data.

lenastodal — Thu, 26 Nov 2020 21:28:03 GMT

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

Re: Import excel file with the hierarchy data.

Sandra_Rossi — Thu, 26 Nov 2020 21:49:00 GMT

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.

Re: Import excel file with the hierarchy data.

Former Member — Fri, 27 Nov 2020 08:33:34 GMT

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.

Re: Import excel file with the hierarchy data.

Sandra_Rossi — Fri, 27 Nov 2020 17:35:41 GMT

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.