topic Re: Excel in required format ( rows & columns) in Application Development and Automation Discussions

Excel in required format ( rows & columns)

kalleshraj5554 — Tue, 03 Nov 2020 14:40:59 GMT

Is it possible to print data from internal table into Excel in the required format (layout) as we want??if yes how ?? usually the data in Excel is reflected as in the format present in the internal table...but I want in different format.Kindly advise

Re: Excel in required format ( rows & columns)

Jigang_Zhang — Wed, 04 Nov 2020 08:29:16 GMT

kalleshraj5554

if you mean different excel file layout according to layout variant, you can try OO ALV refer to cl_salv_table, and set layout using set_initial_layout of cl_salv_layout

refer to this.

Re: Excel in required format ( rows & columns)

balaji_nandikolla — Wed, 04 Nov 2020 09:14:32 GMT

Kallesh,

Can you provide more info on your requirement, what exactly you are doing?

Regards,

Balaji

Re: Excel in required format ( rows & columns)

matt — Wed, 04 Nov 2020 09:16:05 GMT

abap2xlsx is the solution.. Google it.