DOWNLOAD ALV TO EXCEL

[Former Member]

I HAVE AN ALV REPORT,

<b>1.</b>1 FIELD IS EISBE LIKE MARC-EISBE,WHEN I DOWNLOAD TO EXCEL AND I WANT TO MAKE FUNC LIKE SUM IT IS NOT MAKE NOTHING, IF I HAVE VALUE 10 AND MAKE SUM I GET 0 ZERO <b>why?</b>

<b>2.</b> I WANT TO DOWNLOAD AND GET THE DATE IN THE EXCEL REPRORT

I USE THIS

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

it_fieldcat = alv_fldcat

TABLES

t_outtab = <dyn_table>.

THANKS

[Former Member]

Hi Liat,

Check this thread out

Regards,

Santosh

[Former Member]

Hi Liat,

Use this fm to download the data into excel spreadsheet.

'REUSE_ALV_GRID_DISPLAY'

as well as

CALL FUNCTION 'GUI_DOWNLOAD'

regards

[Former Member]

I HAVE TOOL BAR STANDARD AND I ASK FOR SPREADSHEET NOW I WANT TO GET TIME AND DATE IN EXCEL WITH THIS fm

HOW????

THANKS

[Former Member]

plsssssssssssssssssssS

[Former Member]

1 . After u had downloaded to excel , right click on that column , choose format and choose number and try ,

2. add 2 more fields date and time to ur internal table , if u do not want them to be displayed in alv hide them in the fieldcatalog , so that they are available only for download

[Former Member]

THANKS

HOW I CAN HIDE IT

[Former Member]

in fieldcatalog ,

wa_fieldcat-no_out = 'X'.

[Former Member]

ITRIED TO MAKE TO CHANGE THE FORMAT IN EXCEL AND IT DONT SOLVE IT?

IF I MADE IT HOW I CAN SHOW IT IN EXCEL