topic Re: Function module to download data from internal table to excel sheet in Application Development and Automation Discussions

Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:33:01 GMT

Hi all,

I have an internal table with data. I need to download these data to an excel sheet.

Please let me know the function module for this.

Thanks

Saravana

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:35:02 GMT

Use the fun module

GUI_DOWNLOAD

EXCEL_OLE_STANDARD_GET

to transfer from Internal table to EXCEL

Reward points for useful Answers

Regards

Anji

Re: Function module to download data from internal table to excel sheet

varma_narayana — Mon, 25 Jun 2007 06:39:59 GMT

to download data into an Excel file

You can use the GUI_DOWNLOAD fUNCTION MODULE

Specify the filename as YourFile.xls

Regards.

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:40:32 GMT

hi,

use gui_download.

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:42:08 GMT

Use "GUI Download".

Thanks and Regards,

Kunjal Patel

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:43:26 GMT

Hi,

Use GUI_DOWNLOAD.

and

MS_EXCEL_OLE_STANDARD_DAT

Re: Function module to download data from internal table to excel sheet

varma_narayana — Mon, 25 Jun 2007 06:44:50 GMT

to download data into an Excel file

You can use the GUI_DOWNLOAD fUNCTION MODULE

Specify the filename as YourFile.xls

You can also try with FM

EXCEL_OLE_STANDARD_DAT

Regards.

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:45:42 GMT

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

filename = 'C:\REPORT.XLS'

FILETYPE = 'ASC' " file type as ASCI

APPEND = ' '

WRITE_FIELD_SEPARATOR = 'X'

HEADER = '00'

TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH =

tables

data_tab = IT_PR " internal table having data

FIELDNAMES =

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

regards

ravish

reward points if useful

Re: Function module to download data from internal table to excel sheet

Former Member — Mon, 25 Jun 2007 06:55:57 GMT

Hi,

try this function module.. to convert the sap data to Excell...

SAP_CONVERT_TO_CSV_FORMAT

SAP_CONVERT_TO_XLS_FORMAT

and to use this function module use the type pools TRUXS.

Hope this helps you..

- Kothai