topic Re: INTERNAL TABLE INTO EXCEL in Application Development and Automation Discussions

INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 07:44:51 GMT

MAY ANY ONE SUGGEST ME HOW I CAN TRANSFER MY DATA FROM INTERNAL TABLE INTO EXCEL.

OR HOW TO CONVERT MY INTERNAL TABLE INTO EXCEL AND SAVE IT IN LOCAL DIRECTORY.

IS THERE ANY FUNCTION MODULE PRESENT FOR THIS.

I M WAITING FOR REPLY

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 07:46:27 GMT

DATA FROM INTERNAL TABLE INTO EXCEL.

USE FM gui_download.

REFER...

/people/harry.dietz/blog/2005/11/11/yet-another-from-database-or-internal-table-to-excel

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 07:46:45 GMT

GUI_DOWNLOAD and GUI_UPLOAD are used to transfer contents from file to internal and back.

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 07:50:03 GMT

Hi,

Consider these code.

<a href="/people/sap.user72/blog/2006/02/07/downloading-data-into-excel-with-format-options">/people/sap.user72/blog/2006/02/07/downloading-data-into-excel-with-format-options</a>

<a href="/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap">/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap</a>

Regards,

Arun Sambargi.

Re: INTERNAL TABLE INTO EXCEL

dani_mn — Wed, 19 Jul 2006 07:52:53 GMT

Hi,

look into this simple example.

report ZWA_TEST2.

data:  file type string,
       path type string,
       file_path type string.

data: itab type standard table of t001.

start-of-selection.

SELECT * FROM t001 INTO TABLE itab.


 call method cl_gui_frontend_services=>file_save_dialog
 changing      filename          = file
               path              = path
               fullpath          = file_path.

check not file_path is initial.

call method cl_gui_frontend_services=>gui_download
  exporting    filename                = file_Path
                WRITE_FIELD_SEPARATOR = 'X'
   changing    data_tab                = itab.

Regards,

Wasim Ahmed

Message was edited by: Wasim Ahmed

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 07:53:32 GMT

Hi,

Check this..

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

Regards

vijay

Re: INTERNAL TABLE INTO EXCEL

former_member206396 — Wed, 19 Jul 2006 07:57:53 GMT

hai check this,

there is one FM, ws_excel .

CALL FUNCTION 'WS_EXCEL'

EXPORTING

FILENAME = 'C:/RAMU.XLS'

SYNCHRON = ' '

TABLES

DATA = LT_EXCEL " internal table u want to download to excel

EXCEPTIONS
UNKNOWN_ERROR = 1
OTHERS = 2

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 08:02:05 GMT

Hi,

Use FM :- GUI_DOWNLOAD

UPLOAD / Download Programs to PC

http://abap4.tripod.com/Upload_and_Download_ABAP_Source_Code.html

http://www.sapgenie.com/abap/code/abap13.htm

http://sap.ittoolbox.com/code/archives.asp?d=3333&a=s&i=10

http://www.sap-img.com/abap/download-and-upload-your-abap-program.htm

http://www.geocities.com/rmtiwari/Resources/Utilities/WebViewer.html

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 08:04:26 GMT

Hi Pavan,

U can refer to the below code

'SAP_CONVERT_TO_XLS_FORMAT'REPORT Zxls .

parameters: p_file like rlgrap-filename default 'c:\temp\test01.xls'.

data: itab like t001 occurs 0 with header line.

CLEAR itab.

REFRESH itab.

select * from t001 into table itab.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'

EXPORTING

I_FILENAME = p_file

TABLES

I_TAB_SAP_DATA = itab

regards,

Sharat

ps: reward points if helpful

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 09:21:51 GMT

Hi,

Simple technique is USE GUI_DOWNLOAD & in the file name extension give .xls and FIELD_SEPERATOR = 'X'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = 'C:\ABC.XLS'

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

*--AND SO onn

regards,

Srikanth

Re: INTERNAL TABLE INTO EXCEL

Former Member — Wed, 19 Jul 2006 09:44:01 GMT

Hai Pavan

Check the following Code

data: v_file type string,

v_path type string,

v_file_path type string.

data: begin of it_mara occurs 0,

matnr like mara-matnr,

mbrsh like mara-mbrsh,

mtart like mara-mtart,

meins like mara-meins,

end of it_mara.

start-of-selection.

SELECT matnr

mbrsh

mtart

meins

from mara

into table it_mara

where mtart = 'ROH'.

if sy-subrc = 0.

sort it_mara by matnr.

endif.

if not it_mara[] is initial.

call method cl_gui_frontend_services=>file_save_dialog

changing filename = v_file

path = v_path

fullpath = v_file_path.

check not v_file_path is initial.

call method cl_gui_frontend_services=>gui_download

exporting filename = v_file_Path

WRITE_FIELD_SEPARATOR = 'X'

changing data_tab = it_mara[].

endif.

Regards

Sreeni