multiple tabs excel attachment in mail

[former_member574546]

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.

[Jelena]

Use ABAP2XLSX (Google it).

[matt]

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

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

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

[former_member574546]

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

[matt]

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.

[Sandra_Rossi]

So, did you look at the log?

[Sandra_Rossi]

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

[former_member574546]

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

[matt]

Abap2xlsx comes with examples.

[former_member574546]

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

abap2xlsx I don't know how to start

[matt]

"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.

[Sandra_Rossi]

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.