topic Re: Excel error while opening the ALV output in Application Development and Automation Discussions

Excel error while opening the ALV output

Former Member — Wed, 28 Aug 2019 10:48:34 GMT

Hi Gurus,

I have developed a program to send the ALV output mail.After receiving mail if am trying to open the attached excel sheet getting below error.

Please suggest how to remove.

Regards,

Chitme

Re: Excel error while opening the ALV output

RaymondGiuseppi — Wed, 28 Aug 2019 10:55:36 GMT

I suppose you didn't attach an Excel file, but an XML or mHTML file, but with a suffix .XLS or .XLSX, so Excel implicitly called cause of suffix raise the warning. (It's a FAQ)

Hint: for a true XLSX file (sorry for XLS, proprietary format, you need OLE) look for recent SAP provided classes or Abap2Xlsx library.

Re: Excel error while opening the ALV output

Nawanandana — Wed, 28 Aug 2019 16:00:01 GMT

may be your excel attachment corrupted in email. check that In the internal table to build excel file, wild characters were present if its take it off .