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.