Excel in required format ( rows & columns)

[kalleshraj5554]

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

[Jigang_Zhang张吉刚]

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]

Kallesh,

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

Regards,

Balaji

[matt]

abap2xlsx is the solution.. Google it.