Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

excel

Former Member

‎12-16-2006 8:37 AM

0 Kudos

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.

4 REPLIES 4

Former Member

‎12-16-2006 8:40 AM

0 Kudos

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

‎12-16-2006 8:42 AM

0 Kudos

use FM GUI_DOWNLOAD

pass your itab to TABLE parameter DATA_TAB

regards

shiba dutta

Former Member

‎12-16-2006 8:47 AM

0 Kudos

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
Active Contributor

‎12-16-2006 9:03 AM

0 Kudos

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.