on 04-07-2009 12:21 AM
Hello.
I have a problem when I want to attach an excel file. I have configured the communication channel for sending mails with mail package.
I have done the configuration in order to get an excel file. If I test the scenario with Content_Type "text/html" I recieve correctly the information in the mail body.
When I test the scenario with Content_Type "application/vnd.ms-excel", html tags (like: <br>, , &) are not converted. The file is attached as xls, but not converted correctly.
For example, with Content_Type "text/html":
Orders:
1 00023 ER123
2 89798 EHJ21
With Content_Type "application/vnd.ms-excel":
Orders:<br>1&nbsp;&nbsp;&nbsp;00023&nbsp;&nbsp; ER123"<br>2&nbsp;&nbsp;&nbsp;89798&nbsp;&nbsp;&nbsp;EHJ21
I have tested with Content_Type for Word files and I have the same error too.
Do I have to set some special charset in the Content_Type?
Is this an Excel error?
Thanks in advance.
Edited by: Alejandro Maldonado Quezada on Apr 6, 2009 6:28 PM
Hi,
Content_Type "text/HTML" is able to convert the html tags into the desired format....however others will display your code as is or in some other undesired format.....seems you need to use some other format-conversion parameters other than html if not using text/html
Any specific reason for not using text/html??
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
try content type as application/msexcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I had a scenario like SAP R3 - XI - Mail receiver.
I have generated the Excel file attachment with the following details.
Content-Type:- application/vnd.ms-excel;name="Filename.CSV".
Content: - Field1,Field2,Field3,NewLineCharacter,Field4,Field5,Field6.
Content-disposition = attachment
In R3 NewLineCharacter = CL_ABAP_CHAR_UTILITIES=>NEWLINE.
Select KEEP ATTACHMENT option in Mail receive adaptet config.
Excel file Filename.CSV was generated as attachment as follow.
Field1 Field2 Field3
Field4 Field5 Field6
Regards,
Jagesh
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.