ABAP2XLSX - SAP Data to Excel within ABAP

Рет қаралды 6,422

Күн бұрын

Пікірлер: 36

@annaz9630 Жыл бұрын

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

@ERP-UP Жыл бұрын

I appreciate that 😊

@ERP-UP Жыл бұрын

Check out also this video: kzbin.info/www/bejne/p3-pfI2ihsxob7c Install ABAP2XLSX - Create a professional Excel spreadsheet from ABAP

@Baba11-ex1zl Жыл бұрын

👍

@ERP-UP Жыл бұрын

👍

@AyoubBourokbaJob Жыл бұрын

Very useful, thanks

@ERP-UP Жыл бұрын

Thank you

@sabinegeiger3442 Жыл бұрын

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

@ERP-UP Жыл бұрын

My pleasure 👍

@klarazacher9725 Жыл бұрын

Gut zu wissen, danke😊

@ERP-UP Жыл бұрын

Das freut mich 😊

@integrate.education.solutions Жыл бұрын

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

@ERP-UP Жыл бұрын

Thank you and good idea to create a spanish and portuguese version Sérgio. Muchas gracias =)

@JosefZacher-k2z Жыл бұрын

Спасибо то что надо 🎄👍

@ERP-UP Жыл бұрын

👍

@kamilzarzycki7163 4 күн бұрын

Hello Andreas. Thank you for your useful tutorial. I have one question. I have to make report to export employee data to a file, and then import it back to SAP (after changing the data in file). I separate the data with semicolon and save file in .CSV. The problem is, when I open .csv file with the data, it opens automatically with changed format in columns, e. g. text "0001" is converted to "1" . I would like to open it automatically without formating. It is possible only with function in Excel "Import data from text" and then I have to manually set every column format to text. Do you know if there is a possibility to do so with ABAP2XLSX?

@ERP-UP 4 күн бұрын

Hello Kamil, thank you for your message. Why do you want to export the data, change it outside and import it back into SAP? Why do you not change the data within ABAP/SAP and save it there? This approach would save time and is less error-prone.

@kamilzarzycki7163 4 күн бұрын

This is our client requirement, they want to be able to change the data in infotypes for their employee on a large scale. Excel is easier to change the data massively

@nikkuchiii 6 ай бұрын

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

@ERP-UP 6 ай бұрын

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

@nikkuchiii 6 ай бұрын

@@ERP-UP will check them out, thanks!

@sk16034 6 ай бұрын

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

@ERP-UP 6 ай бұрын

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.

@TobiasMüller-r7g 10 ай бұрын

Good

@ERP-UP 10 ай бұрын

Thanks

@abhishekachar4838 8 ай бұрын

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?

@ERP-UP 8 ай бұрын

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: kzbin.info/www/bejne/p3-pfI2ihsxob7cfeature=shared&t=425

@abhishekachar4838 8 ай бұрын

@@ERP-UP thanks for the reply.. it's invoice overview report

@catherineod3624 6 ай бұрын

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

@ERP-UP 6 ай бұрын

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.