topic excel in Application Development and Automation Discussions

excel

Former Member — Sat, 16 Dec 2006 08:37:51 GMT

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.

Re: excel

Former Member — Sat, 16 Dec 2006 08:40:38 GMT

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.

Re: excel

Former Member — Sat, 16 Dec 2006 08:42:00 GMT

use FM GUI_DOWNLOAD

pass your itab to TABLE parameter DATA_TAB

regards

shiba dutta

Re: excel

Former Member — Sat, 16 Dec 2006 08:47:49 GMT

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.

Re: excel

p291102 — Sat, 16 Dec 2006 09:03:09 GMT

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.