excel

[Former Member]

hi experts,

how to send the final list what we get in output to excel sheet.give me the syntax as well as explaination.

thanks in advance.

[Former Member]

Hi,

You need to use ALV output to get this, u'll get a button in the application toolbar to download directly from the list & the the rest will be taken care of by the Predefined ALV functions.

[Former Member]

use FM GUI_DOWNLOAD

pass your itab to TABLE parameter DATA_TAB

regards

shiba dutta

[Former Member]

use this FM

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\CUSERROR.XLS'

• APPEND = 'A'

WRITE_FIELD_SEPARATOR = '#'

tables

data_tab = MESSTAB.

where messtab is an internal table where u will be having final datas.

[p291102]

Hi,

U can see there itself some save into local file some green file. From there itself u can save the file into to select the SPREADSHEET button. It will go to automatically in excel format and save with the .xls file.