ABAP2XLSX - SAP Data to Excel within ABAP

Published: 24 December 2023
on channel: ERP UP
7,250
71

Use the open source tool ABAP2XLSX to automatically export SAP data to an Excel file. With ABAP2XLSX you can easily create professional spreadsheets. In this video I will show you how you can easily transfer SAP data to an Excel file from within ABAP.

Install ABAP2XLSX:    • Install ABAP2XLSX - Create a professi...  
Install abapGit:    • Install abapGit - A Git client for AB...  
Automate SAP to Excel export:    • SAP to Excel: Automate the export of ...  
ABAP Cleaner:    • ✅ ABAP Cleaner - Clean Up with Automa...  

Like, comment and subscribe. Thank you for your support :)

▬ Content ▬▬▬▬▬▬▬▬▬▬▬▬
00:00 - Intro
01:12- ABAP2XLS program
02:14 - ZCL_EXCEL and ZCL_EXCEL_CONVERTER
03:30 - Select data (Purchase order data)
04:31 - Convert internal data to Excel
05:45 - Get active worksheet
06:26 - Freeze header row
07:03 - Excel data to xstring
08:49 - Xstring to raw/binary data
09:37 - Download Excel file
11:18 - Try/Catch
12:00 - Test Excel export
12:36 - Clean ABAP code
14:00 - Outro

▬ Music Intro/Outro ▬▬▬▬▬▬▬▬▬▬▬▬
Depth Fuse - French Fuse
Lights - Patrick Patrikios

▬ Useful links ▬▬▬▬▬▬▬▬▬▬▬▬
German Blog: https://erp-up.de/blog/
My book recommendations: https://erp-up.de/book-recommendation...
100 Tips and Tricks in SAP ERP: https://www.udemy.com/course/100-tips...

Support ERP UP: https://erp-up.de/support-erp-up/
Support ERP UP over Amazon: https://amzn.to/3f40uSG
PayPal-Donation: https://www.paypal.com/paypalme/andre...

Linkedin:   / andreas-geiger  
Xing: https://www.xing.com/profile/Andreas_...


Watch video ABAP2XLSX - SAP Data to Excel within ABAP online without registration, duration hours minute second in high quality. This video was added by user ERP UP 24 December 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,250 once and liked it 71 people.