ALV Excel View Problem

Former Member — Wed, 04 Feb 2009 02:09:53 GMT

Hi All,

I have a problem with the ALV display problem.

When I click on the 'Microsoft Excel View' button at the top of the ALV display, I can view the data in Excel View.

However, when my user click it on his computer, he saw the excel view is blank without data (even there are data at the initial ALV display screen).

May I know what is the root cause of this problem? I've no idea of how to investigate it or solve it.

Many Thanks.

Re: ALV Excel View Problem

Former Member — Wed, 04 Feb 2009 03:20:00 GMT

Hi Irene,

I think it is Excel security problem. Try this one. open excel sheet and GOTO Tools FROM menu and MACRO.....SECURITY here click on Trusted publishers and tick the checkboxes both....

May be it solve ur problem b/c previous i encountred same problem with users..

SKSK.

Edited by: SK SK on Feb 4, 2009 4:20 AM

Re: ALV Excel View Problem

Former Member — Wed, 04 Feb 2009 03:43:16 GMT

HI try with this code------

&----

*& Report ZTEST_DOWNLOAD1

&----

report ztest_download1.

tables : trdir.

type-pools: slis.

types: begin of gt_output,

progname type progname,

strct_type(14) type c,

strct_name(50) type c,

serial(8) type c,

mainfieldname(50) type c,

offset(17) type c,

leng(8) type c,

decimals(8) type c,

inttype(15) type c,

datatype(9) type c,

scrtext_m type scrtext_m,

tabname type tabname,

fieldname type fieldname,

rollname type rollname,

domname type domname,

default(100) type c,

end of gt_output.

types: begin of gt_header,

name(300) type c,

end of gt_header.

data : gi_output type standard table of gt_output,

wa_output type gt_output,

gi_header type standard table of gt_header.

data: d_filename like ibipparms-path,

gi_fieldcat type slis_t_fieldcat_alv,

wa_fieldcat type slis_fieldcat_alv,

wa_header type gt_header.

selection-screen:

begin of block b1 with frame title text-001.

parameter: program(150) type c default 'ZTOOL_TEST'.

select-options so_incl for trdir-name default 'ztool_test' no intervals .

selection-screen begin of line.

parameters :pa_check as checkbox default 'X'.

selection-screen comment (29) text-t01.

parameters :pa_path type rlgrap-filename default 'D:\TRIAL.XLS'.

selection-screen end of line.

selection-screen end of block b1.

at selection-screen.

perform download_excel_template.

at selection-screen on value-request for pa_path.

perform f4_file_help.

&----

*& Form F4_file_help

&----

text

----

--> p1 text
<-- p2 text

----

form f4_file_help .

call function 'KD_GET_FILENAME_ON_F4'

exporting

program_name = sy-repid

dynpro_number = syst-dynnr

field_name = pa_path

changing

file_name = d_filename

exceptions

mask_too_long = 1

others = 2.

if sy-subrc <> 0.

MESSAGE ID gv_msgid TYPE 'I' NUMBER 000.

endif.

endform. "f4_file_help

form download_excel_template .

refresh gi_header.

wa_header-name = text-t01.