Download classical report output to an excel file
I want to download the output of classical report to an excel file. I have used the following function:
CONCATENATE 'e:\' 'sap.txt' INTO fna.
CALL FUNCTION 'GUI_DOWNLOAD'
filename = fna
FILETYPE = 'ASC'
data_tab = it_final.
IF sy-subrc = 0.
MESSAGE s005 with fna.
now this function is coverting the output into a normal text file in a notepad.. When I give the file type as 'XLS', it gives an error saying that the value of parameter filetype is not correct.
please tell me about what can be the possible method for fulfilling my requirement
Give the file name as SAP.xls not SAP.txt.
Give FILETYPE = 'ASC'.