topic Re: multiple tabs excel attachment in mail in Application Development and Automation Discussions

multiple tabs excel attachment in mail

Former Member — Fri, 01 Mar 2019 09:49:41 GMT

I have a requirement where I need to download an excel from existing report with multiple tabs and attache that excel in my new program and send that through mail.That excel with multiple tabs they are using OLE .Pls help me to do further.

Re: multiple tabs excel attachment in mail

Jelena_Perfiljeva — Thu, 14 Mar 2019 16:30:44 GMT

Use ABAP2XLSX (Google it).

Re: multiple tabs excel attachment in mail

Former Member — Mon, 18 Mar 2019 07:27:49 GMT

Hi Jelena,

I have used XML to create excel with multiple worksheets and attached that excel to send mail but the problem is while opening the attachment in mail It shows some error .If,I send the excel attachment with only header part, I am able to get the file but with data it's showing like this. pls help me to do further

Regards,

Rajeshwari Thangavel

Re: multiple tabs excel attachment in mail

matt — Mon, 18 Mar 2019 07:48:19 GMT

1) Use comment to reply to an answer. Not answer

2) Then your XML is wrong.

Furthermore, using abap2xlsx to avoid these kinds of problems.

Re: multiple tabs excel attachment in mail

matt — Mon, 18 Mar 2019 07:53:38 GMT

Funny thing. When I typed in exactly raji_1096 's subject for this question, I got these answered questions suggested.

multiple tabs excel attachment in mail
Data in xml attachment in mail is coming in undesired format ( like chinese characters).
Send email with 1 excel file and multiple sheet
Unable to display column as Numeric in Excel attachment
Send Multiple sheets excel and multiple attachments in mail
Attach excel with multiple tabs from desktop to mail and send it
How to send XL with multiple worksheets on e_mail
how to send .XLSX File with multiple worksheets as an attachment

So, 5 out of 8 suggestions exactly match the OP's question.

Re: multiple tabs excel attachment in mail

Sandra_Rossi — Mon, 18 Mar 2019 08:12:22 GMT

So, did you look at the log?

Re: multiple tabs excel attachment in mail

Sandra_Rossi — Mon, 18 Mar 2019 08:22:03 GMT

Why don't you use ABAP2XLSX instead of XML ? This way, you'll never get an error like that !

Re: multiple tabs excel attachment in mail

Former Member — Mon, 18 Mar 2019 09:45:45 GMT

Thanks for your reply.

I am not able to get the log from that path.I am able get the excel when passing only header if I pass the data to the excel, I am getting that dump.Do you have any reason for this dump?

I am using XML because I am not that much aware of abap2xlsx.

can you pls provide a sample code for abap2xlsx

Re: multiple tabs excel attachment in mail

matt — Mon, 18 Mar 2019 10:08:53 GMT

Abap2xlsx comes with examples.

Re: multiple tabs excel attachment in mail

Former Member — Mon, 18 Mar 2019 11:10:31 GMT

I am new to SAP ABAP. I am not much aware of OO concepts .

abap2xlsx I don't know how to start

Re: multiple tabs excel attachment in mail

matt — Mon, 18 Mar 2019 12:53:28 GMT

"I am new to SAP ABAP. I am not much aware of OO concepts ."

It's part and parcel of ABAP nowadays. Anyway, using classes is relatively simple compared to writing them, so you only need the basics.

Search and you'll find tutorials, demos and blogs.

Re: multiple tabs excel attachment in mail

Sandra_Rossi — Mon, 18 Mar 2019 13:29:31 GMT

Rajeshwari Thangavel Like Matthew said: "Abap2xlsx comes with examples." You don't really need to be an expert in OO for understanding these demo programs.