Data transfer from Internal table to MS-Excel

[Former Member]

Hi,

I would like to know if there are ways to transfer the contents of an internal table to an excel sheet.

Thanks in advance,

Hema

[Former Member]

hii

use GUI_DOWNLOAD

<b>http://www.thespot4sap.com/Articles/Download_to_excel.asp</b>check this link

<b>

Regards

Naresh

[former_member188685]

Hi,

check these links..

http://www.sapdevelopment.co.uk/file/file_updown.htm

Regards

vijay

Message was edited by: Vijay Babu Dudla

[rahulkavuri]

REPORT Z50657.

DATA: IMARD TYPE TABLE OF MARD WITH HEADER LINE.

START-OF-SELECTION.

SELECT * INTO TABLE IMARD UP TO 60 ROWS FROM MARD.

CALL FUNCTION 'WS_EXCEL'

EXPORTING

FILENAME = 'TS.XLS'

TABLES

DATA = IMARD.

REFER TO THIS THREAD TOO

[Former Member]

use GUI_DOWNLOAD with field_separator = 'X'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = 'C:\file.xls'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = ITAB

• EXCEPTIONS

• FILE_WRITE_ERROR = 1

• NO_BATCH = 2

regards

srikanth.

[Former Member]

Hi,

Use the following FM.

1)ws_download

2)gui_download.

i think you can met your requirement

thanks

Sunil.

[Former Member]

Hello Hema,

check these links:

www.visualsap.com/onecoltemplate.htm

regards,

keerthi.

[Former Member]

HI,

use GUI_DOWNLOAD function module

follow this steps:

pass your final internal table to that

give file name

file type as DAT

give a parameter for filepath on the selection screen.

filename = your parameter name

filetype = 'ASC'

has_field_separator = 'X'

tables = your final internal table

rgds,

latheesh