topic Function Module WS_EXCEL in Application Development and Automation Discussions

Function Module WS_EXCEL

Former Member — Tue, 15 Sep 2009 19:10:03 GMT

Hi all,

I need your help. I am using the FM 'WS_EXCEL' to download an internal table into an excel file. This FM creates the excel file and then automatically opens the file.

Here is the simple code that I'm using:

DATA: v_filename LIKE ibipparms-path.

v_filename = 'C:\My Documents\groupkey.xls'.

CALL FUNCTION 'WS_EXCEL'

EXPORTING

filename = v_filename

TABLES

data = i_rptd.

The file is being successfuly saved in the following path 'C:\My Documents\groupkey.xls'. However, when the FM tries to open the file it looks like is having problem with the space between 'My Documents', becuase I am getting the following 2 Windows error messages:

1. 'C:\My.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

2. 'Documents\groupkey.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

Note: If I change the path to 'C:\groupkey.xls' is working fine. But the user wants to save the file in 'My Documents' folder.

Any help is greatly appreciated.

Thanks,

Francisco

Re: Function Module WS_EXCEL

former_member194669 — Tue, 15 Sep 2009 19:30:49 GMT

Try this way


CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
	EXPORTING
		FILENAME = v_filename
	CHANGING
		DATA_TAB = i_rptd[].

then call


CALL METHOD CL_GUI_FRONTEND_SERVICES=>EXECUTE
	EXPORTING
		DOCUMENT = v_filename.

a®

Re: Function Module WS_EXCEL

Former Member — Tue, 15 Sep 2009 21:12:48 GMT

a®s thanks for your help!

This was my final code:


DATA: v_filename type STRING.

v_filename = 'C:My Documentsgroupkey.xls'. 

CALL METHOD CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD
  EXPORTING
    FILENAME = v_filename
    FILETYPE = 'DAT'
    CONFIRM_OVERWRITE = 'X'

  CHANGING
    DATA_TAB = i_rptd[].

CALL METHOD CL_GUI_FRONTEND_SERVICES=>EXECUTE
  EXPORTING
    DOCUMENT = v_filename.

Re: Function Module WS_EXCEL

Former Member — Wed, 16 Sep 2009 05:32:57 GMT

Hi,

Don't use function module WS_EXCEL.

use function module GUI_DOWNLOAD & make the file extension '.xls'.

Or you can try using FM : SAP_CONVERT_TO_XLS_FORMAT

Regards,

Tutun