Import Excel *.xlsx to Internal Table - with ABAP [english]

Cust&Code in SAP ABAP
Cust&Code in SAP ABAP
17 هزار بار بازدید - 3 سال پیش - In this video I show
In this video I show how to import data from an Excel file (*.xslx) into an internal table.
For this I use the class: cl_fdt_xl_spreadsheet

For the import the following steps are performed
1: Upload of the Excel file
2: Transform the data SOLIX to XSTRING
3: Create an object reference to the file
4: Read the worksheets
5: Create an object reference to the first worksheet
6: Display the data

#Excel #Import #ABAP

▬▬  Literature  📚  ▬▬▬▬▬▬▬▬▬▬▬▬▬
▶ ABAP: An Introduction 2020 https://amzn.to/45CLTqk
▶ Complete ABAP 2023 https://amzn.to/45D5UNM
▶ ABAP to the Future 2022   https://amzn.to/42cgWGs
▶ Clean ABAP 2022 https://amzn.to/3KAqmow

▬▬  My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬
▶ Microphone: https://amzn.to/3zj2UIz
▶ Headphone: https://amzn.to/3GUBRFg


▬▬  My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬
▶ Video Recorder: https://bit.ly/678fgh6
▶ Video Editor: https://bit.ly/38Rj9lb
▶ Thumbnail: https://bit.ly/CustAndCodeThumbnail
▶ Gamma AI: http://bit.ly/3nsdvgr


▬▬  Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐Become my subscriber: https://bit.ly/CustAndCodeSub
🎬All videos in English: https://bit.ly/CustAndCodeENG
☕Buy me a Coffee 😀: https://bit.ly/3dih2cl

*The links are affiliate links. There are no additional costs.
3 سال پیش در تاریخ 1400/08/23 منتشر شده است.
17,003 بـار بازدید شده
... بیشتر