Multiple worksheet Spreadsheet attachment

[Former Member]

Hi,

I have a requirement where we need to append data from a couple of tables in to separate worksheets which would be a part of single excel spreadsheet. This spreadsheet should be sent via email to respective IDs.

I have tried this via Microsoft OLE but that could not be done in the background without opening excel application. Is there any method that can be used to send the spreadsheet from SAP.

Thanks in advance.

Niranchan.

[stefan_schmcker]

Good evening Niranchan,

google for ABAP2XLSX or follow this link: https://cw.sdn.sap.com/cw/groups/abap2xlsx

______________________________________

live long and prosper

Stefan Schmöcker

[Former Member]

Stefan,

Yes. I saw ABAP2XLSX but I'm not sure if I'll be allowed to do that here. Is there any other option apart from ABAP2XLSX?

Thanks for your response.

[stefan_schmcker]

Good afternoon Niranchan,

as far as I know there is currently no other method to create multi-sheet EXCEL files in background.

______________________________________

live long and prosper

Stefan Schmöcker

[saranwin]

Hi Niranchan,

Check the below existing forums.

http://scn.sap.com/message/1817441

http://wiki.sdn.sap.com/wiki/display/Snippets/Download+Data+into+Multiple+Sheet+Excel+Document+with+...

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+OLE+-+Download+tables+to+multiple+worksheets+in+E...

http://wiki.sdn.sap.com/wiki/display/Snippets/Read+multiple+sheets+of+an+Excel+file+into+SAP+through...

let me know if you need any more help.

Regards,

Saravanan Madhappan

[Former Member]

Saravanan,

Thanks for replying. I'll not be able to user OLE since this needs to be scheduled as a batch job. I've checked these forums before posting and did not find much help. If its online, OLE can be implemented and this works but I'm not sure when this is executed as a batch job.

Thanks.