Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel in required format ( rows & columns)

kalleshraj5554
Explorer
0 Kudos
291

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

3 REPLIES 3

Jigang_Zhang张吉刚
Active Contributor
0 Kudos
184

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.

balaji_nandikolla
Participant
0 Kudos
184

Kallesh,

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

Regards,

Balaji

matt
Active Contributor
184

abap2xlsx is the solution.. Google it.