topic Data transfer from Internal table to MS-Excel in Application Development and Automation Discussions

Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 10:49:52 GMT

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

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 10:53:46 GMT

hii

use GUI_DOWNLOAD

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

<b>

Regards

Naresh

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 10:53:55 GMT

Hi,

check these links..

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

Regards

vijay

Message was edited by: Vijay Babu Dudla

Re: Data transfer from Internal table to MS-Excel

rahulkavuri — Fri, 19 May 2006 10:58:12 GMT

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

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 11:03:34 GMT

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.

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 14:25:47 GMT

Hi,

Use the following FM.

1)ws_download

2)gui_download.

i think you can met your requirement

thanks

Sunil.

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 14:41:43 GMT

Hello Hema,

check these links:

www.visualsap.com/onecoltemplate.htm

regards,

keerthi.

Re: Data transfer from Internal table to MS-Excel

Former Member — Fri, 19 May 2006 14:51:32 GMT

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