topic Re: internal table into excel in Application Development and Automation Discussions

internal table into excel

Former Member — Tue, 18 Dec 2007 14:30:40 GMT

How can i converte an internal table into an excel table?

Greets Volker

former_member188829 — Tue, 18 Dec 2007 14:32:50 GMT

Hi,

Use Function Module:GUI_DOWNLOAD

Former Member — Tue, 18 Dec 2007 14:40:22 GMT

Is there another possibility??

Former Member — Tue, 18 Dec 2007 14:40:48 GMT

try this...

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\TEMP\DATA.XLS'

WRITE_FIELD_SEPARATOR = 'X'

tables

data_tab = itab "Internal table

Former Member — Tue, 18 Dec 2007 15:08:03 GMT

Hi Volker,

use GUI_DOWNLOAD function it is used to create a file in your presentation Server or use CL_GUI_FRONTEND_SERVICES class .

Plzz Reward if useful,

Mahi.

ThomasZloch — Tue, 18 Dec 2007 15:43:17 GMT

here's a nice one:

MS_EXCEL_OLE_STANDARD_DAT

Former Member — Tue, 18 Dec 2007 15:52:57 GMT

Hi Volker,

You can also try:

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = MYREPORT

I_CALLBACK_USER_COMMAND = 'USER_COMMAND'

IT_FIELDCAT = FIELDCATALOG1[]

I_SAVE = 'X'

TABLES

T_OUTTAB = ITAB

EXCEPTIONS

PROGRAM_ERROR = 1

OTHERS = 2 .

Hope this helps.

Shane