How to save S_ALR_87012284 data in xlsx format in excel

[Former Member]

Hi sap friends,

I am trying to export the data for S_ALR_87012284. After exporting the data, it is coming in XLS format. 

I want to export it in XLSX format. how can I achieve it

[RaymondGiuseppi]

Which option (menu steps) did you select to export?

• Do you generate an actual Excel file (legacy : often SAP export some text delimited file with suffix xls, if you can read the file with Notepad, this is not an Excel file or you are not human)
• Navigate to find some other option to generate an XML/XLSX format file (you may be required to swith to ALV grid display)

Abap POV - S_ALR_87012284 can display an ALV grid, so 

1. with class CL_SALV_BS_RUNTIME_INFO you can get access to the data and metadata and prevent display
2. With those and a class such as CL_SALV_BS_TT_UTIL you can generate XLSX data
3. Sample: look at my (old) answer to Infoset Query report output as excel attached mail(in background - more than 255 char) (change  if_salv_bs_xml=>c_type_mhtml with c_type_xlsx) or use search tool for recent answers.

[ManjunathaV]

Hi Nand,

To export data from the SAP report S_ALR_87012284 in XLSX format, follow the below steps:

Export Data:

Once the report is generated, click on the List menu at the top of the SAP screen.
Navigate to Export > Spreadsheet.
Select Spreadsheet Format:

In the pop-up window, you will be prompted to select a format for the export. The default option might be XLS.
Click on the button to change the format. Look for an option that allows you to select the Office Open XML format, which corresponds to XLSX.
Save File:

After selecting the XLSX format, proceed to save the file.
You may be prompted to choose a location to save the exported file. Navigate to the desired directory and save the file with the .xlsx extension.

This will resolve your issue.

Regards

Manjunatha V