Excel-File per Email with class CL_DOCUMENT_BCS

[frank_bork]

Hi all,

What I need is an excel file with subtotals as EMail-Attachment.

I created an ALV-List with the subtotals, converted the ALV to BIN-Data via Method CL_SALV_TABLE->TO_XML and created the attachment in the mail via class CL_DOCUMENT_BCS.

The Email is looking fine and the excel Attachment is there.

But If I try to open the attachment in SOST I get the following Message:

Excel cannot open the file ''Attachment_20150129111717.173_X.XLS' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

If I open the file the excel is showing the correct data including the subtotals.

Is there any posiibilty to avoid the message above?

Remark: I can open the file without any problems with office version 2003, but in all newer versions I get the above message.

Thanks a lot.

Kind regards

Frank

[former_member200338]

Refer to link below.

[frank_bork]

Thanks for your quick answer.

I found a solution in the method CL_SALV_TABLE->TO_XML to avoid the message in excel

[Former Member]

Hi Frank,

What other solution you found ? Kindly share the same. I am getting the same problem and cannot use tool like abap2xls etc.

Thanks

Rakesh