topic Re: open Excel file file from abap report program in Application Development and Automation Discussions

open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 06:50:20 GMT

Hi Experts,

I want to show excel file from abap report program, but excel file exists in the following location.

'https://www.sdn.sap.com/test.xls'.

what are the steps to follow to display excel file from abap report program.

please help me out.

Thanks

Sridhar

Re: open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 07:02:50 GMT

U have to search some standd function module s there...U call FM and get the file.

Regarda:

Prabu

Re: open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 07:04:21 GMT

Generally we will use WS_EXECUTE function module using paramter PROGRAM = 'path of the file'.

But as this FM is OBSOLETE now we have to go for classes.

call method cl_gui_frontend_services=>execute

exporting

application = ls_file_path

parameter = lv_file

synchronous = 'X' "lv_modal

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

others = 8.

if sy-subrc <> 0.

Re: open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 07:08:28 GMT

Hi,

try this:

CL_GUI_FRONTEND_SERVICES=>EXECUTE(

EXPORTING

DOCUMENT = 'https://www.sdn.sap.com/test.xls'

EXCEPTIONS

CNTL_ERROR = 1 ).

Regards, Dieter

Re: open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 07:10:27 GMT


DATA: d_string TYPE string.

CONCATENATE '\\Hrdoc\PRINTFILES\PRINT'w_printfileno'.doc' INTO text.

  d_string = text.

  CALL METHOD cl_gui_frontend_services=>execute

   EXPORTING

     document = d_string

   EXCEPTIONS

     OTHERS   = 1.

Re: open Excel file file from abap report program

Former Member — Thu, 11 Sep 2008 07:48:56 GMT

Hi,

use the below function module to upload the excel file.

WS_DOWNLOAD

to get the file name use the below function module in at selection screen.

call function 'KD_GET_FILENAME_ON_F4'

exporting

mask = ',Text files, *.txt'

static = 'X'

changing

file_name = p_pfile.

Regards,

sunil

Re: open Excel file file from abap report program

vinod_vemuru2 — Thu, 11 Sep 2008 07:57:30 GMT

Hi,

Check FM ALV_XXL_CALL. U can pass fieldcat and output table to this FM to display data in excel.

U can also check WS_EXECUTE. But All WS_ FMs are obsolete.

Thanks,

Vinod.

Re: open Excel file file from abap report program

Former Member — Tue, 06 Jan 2009 11:53:48 GMT

solved