Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel error while opening the ALV output

Go to solution
former_member617564
Participant

‎2019 Aug 28 11:48 AM

0 Kudos
579

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

Preview file
31 KB
1 ACCEPTED SOLUTION

Go to solution
raymond_giuseppi
Active Contributor

‎2019 Aug 28 11:55 AM

449

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.

2 REPLIES 2

Go to solution
raymond_giuseppi
Active Contributor

‎2019 Aug 28 11:55 AM

450

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.

Go to solution
p244500
Active Contributor

‎2019 Aug 28 5:00 PM

0 Kudos
449

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 .