How to download data into XLSX file in ABAP ECC 6.0 using FM: GUI_DOWNLOAD or any other FunctionModules

19709 Views

Hi ABAP Exterts,

Any one help on this , there is a requirement to download the data into XLSX file only.

I am able to to download the data into XLS file using the FM: GUI_DOWNLOAD in SAP ECC 6.0and also opening the file . But when i download the data into XLSX file . I am able to download the data into GUI_DOWNLOAD. But while opening the file i am getting the below mentioned error.

'Excel cannot open the file 'filename.xlsx' 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'

Ok buttom is coming not able to open the file.

When i use the FM: SAP_CONVERT_TO_XLS_FORMAT to download the XLS it self it is going abap DUMP that file type error.

Any one help any Function Module or how to download data through abap programing into XLSX file.

Thanks.

Murali.

Message was edited by: Matthew Billingham - adjusted wording...