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
Thank you very much. Within the ABAP program ZABAP2XLSX_DEMO_SHOW you have a lot of examples in ABAP2XLSX. Have a closer look at these programs. There other sheets have been added: ZDEMO_EXCEL3 ZDEMO_EXCEL4 ZDEMO_EXCEL9 ZDEMO_EXCEL19
To wrap text, you can use the demo program ZDEMO_EXCEL14. The abap2xlsx library can approximately calculate the width of a column based on the texts it contains. To enable this functionality, you need to install True Type fonts in SE73. For guidance, refer to the demo program ZDEMO_EXCEL31. If the fonts are not installed, the calculation will rely on the number of characters, assuming they all have the same width and font size. For ALV (ABAP List Viewer), you can also use CL_SALV_TABLE=>TO_XML to create an XLSX file. To apply a style to all cells, you have also two options: 1. Set a default style using SET_DEFAULT_STYLE in ZCL_EXCEL. 2. Use the CHANGE_AREA_STYLE method to modify the style of a range of cells, as demonstrated in ZDEMO_EXCEL40.
Gute Frage. Schaue einmal, ob Du die Antwort in den SCN Artikeln findest: community.sap.com/t5/application-development-blog-posts/abap2xlsx-generate-your-professional-excel-spreadsheet-from-abap/ba-p/12949863 ABAP2XLSX auf GitHub: github.com/abap2xlsx/abap2xlsx Im Zweifel kann man die Spalten auch nachträglich manuell sperren. Hierzu in Excel die gewünschten Spalten auswählen und dann "Zellen formatieren > Schutz > Gesperrt" wählen.
Without seeing or knowing what kind of report it is, I can't give an exact answer. But it sounds feasible. Look at this video: ua-cam.com/video/qNFKZlQg59U/v-deo.htmlfeature=shared&t=425
![Import Excel *.xlsx to Internal Table - with ABAP [english]](http://i.ytimg.com/vi/L8zlde5JC-Y/mqdefault.jpg)
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](http://i.ytimg.com/vi/8nvCW-l2Jdc/mqdefault.jpg)
Cool to have an example of abap2xlsx. I loved the video about the installation. But now you rocked it. You deserve a raise.
I appreciate that 😊
Check out also this video: ua-cam.com/video/qNFKZlQg59U/v-deo.html
Install ABAP2XLSX - Create a professional Excel spreadsheet from ABAP
Very useful, thanks
Thank you
Very good video !! Thanks a lot !! 👍👍👍
My pleasure 👍
Спасибо то что надо 🎄👍
👍
👍
👍
Gut zu wissen, danke😊
Das freut mich 😊
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
Thank you and good idea to create a spanish and portuguese version Sérgio.
Muchas gracias =)
Awesomeee tutorial. Thank you!
Would it be possible to add another sheet?
Thank you very much.
Within the ABAP program ZABAP2XLSX_DEMO_SHOW you have a lot of examples in ABAP2XLSX.
Have a closer look at these programs. There other sheets have been added:
ZDEMO_EXCEL3
ZDEMO_EXCEL4
ZDEMO_EXCEL9
ZDEMO_EXCEL19
@@ERP-UP will check them out, thanks!
Good
Thanks
Hi, Is there way to keep auto size based on the column data in worksheet?
To wrap text, you can use the demo program ZDEMO_EXCEL14.
The abap2xlsx library can approximately calculate the width of a column based on the texts it contains. To enable this functionality, you need to install True Type fonts in SE73. For guidance, refer to the demo program ZDEMO_EXCEL31. If the fonts are not installed, the calculation will rely on the number of characters, assuming they all have the same width and font size.
For ALV (ABAP List Viewer), you can also use CL_SALV_TABLE=>TO_XML to create an XLSX file.
To apply a style to all cells, you have also two options:
1. Set a default style using SET_DEFAULT_STYLE in ZCL_EXCEL.
2. Use the CHANGE_AREA_STYLE method to modify the style of a range of cells, as demonstrated in ZDEMO_EXCEL40.
wie kann man einige Spalten auch blockieren, sodass sie nicht bearbeitet werden können?
Gute Frage. Schaue einmal, ob Du die Antwort in den SCN Artikeln findest: community.sap.com/t5/application-development-blog-posts/abap2xlsx-generate-your-professional-excel-spreadsheet-from-abap/ba-p/12949863
ABAP2XLSX auf GitHub: github.com/abap2xlsx/abap2xlsx
Im Zweifel kann man die Spalten auch nachträglich manuell sperren. Hierzu in Excel die gewünschten Spalten auswählen und dann "Zellen formatieren > Schutz > Gesperrt" wählen.
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?
Without seeing or knowing what kind of report it is, I can't give an exact answer. But it sounds feasible.
Look at this video: ua-cam.com/video/qNFKZlQg59U/v-deo.htmlfeature=shared&t=425
@@ERP-UP thanks for the reply.. it's invoice overview report
ZCL_EXCEL and ZCL_EXCEL_CONVERTER can share code for this class
It' s the class of ABAP2XLSX. Install it as shown and you can analyze the code. See ua-cam.com/video/qNFKZlQg59U/v-deo.htmlsi=WHe5AkroEoftZetz
Would you please provide the code of ZCL_EXCEL_CONVERT class code.
It' s the class of ABAP2XLSX. Install it as shown and you can analyze the code. See ua-cam.com/video/qNFKZlQg59U/v-deo.htmlsi=WHe5AkroEoftZetz
Hi I need help uploading an excel to a zeta transaction
Sure, that is possible:
- Upload the excel file
- Convert binary data into xstring
- Work with excel data within ABAP