ABAP2XLSX - SAP Data to Excel within ABAP

preview_player
Показать описание
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.

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 ▬▬▬▬▬▬▬▬▬▬▬▬

Рекомендации по теме
Комментарии
Автор

Install ABAP2XLSX - Create a professional Excel spreadsheet from ABAP

ERP-UP
Автор

Cool to have an example of abap2xlsx. I loved the video about the installation. But now you rocked it. You deserve a raise.

annaz
Автор

Very good video !! Thanks a lot !! 👍👍👍

sabinegeiger
Автор

good one, Andreas! I talked to your colleague Torben about to create a portuguese + spanish version for this video and expand this knowledge to latin america audience. I am working on that and of course will mention this amazing video on my own version! Thank you! =). Sérgio Paes

integrate.education.solutions
Автор

Awesomeee tutorial. Thank you!
Would it be possible to add another sheet?

nikkuchiii
Автор

Hi, Is there way to keep auto size based on the column data in worksheet?

sk
Автор

Would you please provide the code of ZCL_EXCEL_CONVERT class code.

Explorecommonman-jevu
Автор

wie kann man einige Spalten auch blockieren, sodass sie nicht bearbeitet werden können?

catherineod
Автор

Hi I need help uploading an excel to a zeta transaction

marleneflorian
Автор

Hi, i want to download report having 2 logos and address in the top can i do it with the help of abap2xlsx? how can i do it?

abhishekachar