Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel to SAP Starting from Column Two

former_member805784
Explorer

‎2022 Jun 01 2:48 PM

0 Kudos
149

I followed this tutorial to create a program to upload a excel sheet to an sap ztable.

How To SAP Upload Excel File With TEXT_CONVERT_XLS_TO_SAP (sap4tech.net)

I am wondering if there is a way to start filling in the data to the second column of the ztable. For example I have my ztable with client, name, age, email, etc... however my excel sheet does not contain client because that is a system input. I got around this by leaving an empty column but I would like to not do this every time I want to modify my ztable. Any sugesstions?

2 REPLIES 2

FredericGirod
Active Contributor

‎2022 Jun 01 3:01 PM

104

go at the end of your documentation and look directly the ABAP2xlsx

it is a powerfull solution, in Oo programing

abo
Active Contributor

‎2022 Jun 01 3:23 PM

104

what frdric.girod said, with an additional warning: skip the saplink thingy (it is obsolete) and go directly to the main source on GitHub.