Import Excel *.xlsx to Internal Table - with ABAP [english]
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.
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
بـار بازدید شده