I_OI_SPREADSHEET - Inputs on insert/delete rows in excel spreadsheet

[kirankerudi]

Hello Experts,

I have a question regarding the excel generation using the interface I_OI_SPREADSHEET. I have stored the template in OAOR and based on this template, I need to generate excel.

I could only think of below two options with respect to inserting the items/rows :

Option 1: I have both Header and Footer at fixed position. Now based on the number of items/rows I need to delete extra rows, so that the Footer is just below the last item.

Option 2: I fix only the Header position and based on the items/rows the footer will be below the last item.

I was not able to find ways to achieve either of these options. Can this be achieved with the interface I_OI_SPREADSHEET? If yes, what methods help?

Thank you!

[kirankerudi]

Hello Experts,

I have a question regarding the excel generation using the interface I_OI_SPREADSHEET. I have stored the template in OAOR and based on this template, I need to generate excel.

I could only think of below two options with respect to inserting the items/rows :

Option 1: I have both Header and Footer at fixed position. Now based on the number of items/rows I need to delete extra rows, so that the Footer is just below the last item.

Option 2: I fix only the Header position and based on the items/rows the footer will be below the last item.

I was not able to find ways to achieve either of these options. Can this be achieved with the interface I_OI_SPREADSHEET? If yes, what methods help?

Thank you!

[FredericGirod]

Do you know ABAP2XLS ?

[kirankerudi]

Hi Frederic,

I have used abap2xlsx and I agree it’s the great tool. Unfortunately, in my current company we cannot install custom third party packages.

Hope you understand..

Thank you!

[FredericGirod]

kiran.rk2, yes I could understand 🙂 but I cannot help you on your request. Maybe search for your interface usage on ABAP Code. Maybe you will find a demo