suggest replacement.

Former Member — Tue, 15 Apr 2008 06:24:52 GMT

Hi ,

please suggest replacement for function module ws_excel.

Thanks,

Rajesh.

Re: suggest replacement.

Former Member — Tue, 15 Apr 2008 06:26:36 GMT

You have to use the follwoing in place of WS_EXCEL :CL_GUI_FRONTEND_SERVICES=>DIRECTORY_EXIST.

GUI_DOWNLOAD

CL_GUI_FRONTEND_SERVICES=>EXECUTE.

Also check FM RH_START_EXCEL_WITH_DATA.

Re: suggest replacement.

Former Member — Tue, 15 Apr 2008 06:56:31 GMT

you can use function module 'GUI_DOWNLOAD' & class method CL_GUI_FRONTEND_SERVICES=>EXECUTE.

for example :

CALL FUNCTION 'WS_EXCEL'

EXPORTING

FILENAME = 'D:\FILE1.xls'

SYNCHRON = ' '

TABLES

DATA = itab

EXCEPTIONS

UNKNOWN_ERROR = 1

OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

replacement ;

data : l_filename type string.

l_filename = 'D:\FILE1.xls'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = l_filename

TABLES

DATA_TAB = itab

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.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>EXECUTE

EXPORTING

DOCUMENT = 'D:\FILE1.xls'

OPERATION = 'OPEN'

EXCEPTIONS

CNTL_ERROR = 1

ERROR_NO_GUI = 2

BAD_PARAMETER = 3

FILE_NOT_FOUND = 4

PATH_NOT_FOUND = 5

FILE_EXTENSION_UNKNOWN = 6

ERROR_EXECUTE_FAILED = 7

SYNCHRONOUS_FAILED = 8

NOT_SUPPORTED_BY_GUI = 9

others = 10

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

reward if useful

Re: suggest replacement.

Former Member — Tue, 15 Apr 2008 06:58:16 GMT

Hi,

Try the below:

*GUI_DOWNLOAD *

CL_GUI_FRONTEND_SERVICES=>EXECUTE..

Thanks,

Sriram Ponna.

topic suggest replacement. in Application Development and Automation Discussions

suggest replacement.

Re: suggest replacement.

Re: suggest replacement.

Re: suggest replacement.