Export of internal table (itab) to Excel (abap2xslx) [english]

[@user-vl3pl9dp4o]

Hi Thanks for your inputs and valuable info. ZCL_excel and zcl_excel_converter code is to view pls

[@CustAndCode]

Thanks! 🤗 This is part of the package abap2xslx. Search fpr them in the T-Code SE24. 🤗

[@MarkAdrian07]

Hello, how can I reuse this block of code into a subroutine to process different internal tables?

[@CustAndCode]

I myself very rarely work with subroutines. I use methods and function moduls. Here it is important to pass the things that change as parameters, in this case the name of the table. 🤗

[@MarkAdrian07]

@@CustAndCode after using it once, how would I clear everything needed to reuse it for another internal table again?

[@arnabhait6480]

Can you please also show how to add multiple header in one excel sheet

[@CustAndCode]

I am not sure what you exactly mean with "headers" Did you mean worksheets? One than more worksheets in a single excel file? 🤔

[@vandanarawat475]

@@CustAndCode Could you please create an example of downloading 3 internal table in different worksheet of .xlsx file

[@CustAndCode]

@@vandanarawat475 I can try it 😉 I set this on my "possible great videos for my TH-cam channel" list. 🤗

[@majedkhan4998]

superb .. Can we execute same report in background as data is very very huge in production server. please reply back how to execute itab to excel in backgfound job without Open Dataset AL11.

[@CustAndCode]

I think if you want to run this in background you will need the appication server. Where else should the file be written? 🤔Why don't you want to use the application server?

[@majedkhan4998]

@@CustAndCode i am using ALV Factory class , as production server volume increasing day by day , its reached to more than 100,000 Records, This daily Sales ALV report in foreground taking more time and dump or application no memory or time out error showing . my question i want to execute this report in background SM37 without application server , will it work , if yes, please guide me how to execute this report in Background Job.

[@CustAndCode]

In my opinion it will not work but why do you need the whole data what do you do with this data download it? Is it possible to select subsets of data? 🤔

[@majedkhan4998]

@@CustAndCode This data is daily sales Report from VBRP , VBAP tables with all line item , This report being used at end of month how much sale happend based on Company code, Plant , storage location etc for Business Analytical purpose.This Data is ALV output and its downloaded in Excelsheet , enduser can filter and check Total Net Price, Qty. Sales , Margin, Cost, Percentage etc.
ITs ALV report as output and exported or saved as XLS excel file.
what is select subset of data ? please expleain , workaround solution for this problem ?

[@CustAndCode]

@@majedkhan4998 Ok, I see, so you want the daily sales as an excel file? For this you don't have to use an ALV Grid. Just write a program and download it directly to a excel file, without displaying it before. 🤗

[@davutkesmuk1093]

hi how can i paint the background of all excel using abap2xlsx

[@CustAndCode]

You can change the style of a cell, the backgroundcolor for example. For this use the class zcl_excel_style. 🤗

[@davutkesmuk1093]

@@CustAndCode ok thx 😊

[@amitsen41]

Please share zcl_excel_converter code

[@CustAndCode]

This class is part of the opensource project abap2xslx. You have to install this first. After that you can use it with many other functions! 🤗

[@Explorecommonman-je6vu]

Did you have ZCL_EXCEL_CONVERTER code? If you have please share with me.