topic Re: Zip excel attachment in Application Development and Automation Discussions

Zip excel attachment

Former Member — Mon, 09 Jan 2012 13:16:42 GMT

hello everyone,

I am converting an internal table to excel attachment which is to be sent as an email via a background job.

In certain case, the size of the attachment is more than the limit that is permissible on our network.

I think if i could somehow zip the attachment and reduce the file size, my requirement would be fulfilled.

is there any fm or class which can solve my purpose?

Thanx in advance.

Regards,

Xineohpi

Former Member — Mon, 09 Jan 2012 13:24:42 GMT

Hi,

If you have a netweaver system, Check the class CL_ABAP_ZIP.

First add the file(s) you want to zip with the ADD method and then receive the zipped archive with the SAVE method into a xstring.

If you have only a 4.7 System, you can copy CL_ABAP_ZIP from a netweaver system into a Z* Package Class.

or check BCS_EXAMPLE*.

Thanks & regards.

Former Member — Mon, 09 Jan 2012 13:56:40 GMT

I checked the CL_ABAP_ZIP class. How can i use it to zip the excel sheet which i am creating in my program?

and i have to send this zip file as email attachment.

Regards

Xineohpi