topic Re: Multiple worksheet Spreadsheet attachment in Application Development and Automation Discussions

Multiple worksheet Spreadsheet attachment

Former Member — Mon, 15 Jul 2013 22:01:41 GMT

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.

Re: Multiple worksheet Spreadsheet attachment

stefan_schmcker — Mon, 15 Jul 2013 22:37:27 GMT

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

Re: Multiple worksheet Spreadsheet attachment

saranwin — Tue, 16 Jul 2013 01:43:38 GMT

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+Non+Editable+Columns+(Password+protected)+Using+ABAP+OLE

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

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

let me know if you need any more help.

Regards,

Saravanan Madhappan

Re: Multiple worksheet Spreadsheet attachment

Former Member — Tue, 16 Jul 2013 14:18:08 GMT

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.

Re: Multiple worksheet Spreadsheet attachment

Former Member — Tue, 16 Jul 2013 14:19:32 GMT

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.

Re: Multiple worksheet Spreadsheet attachment

stefan_schmcker — Tue, 16 Jul 2013 14:33:07 GMT

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