Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

excel download problem.

Go to solution
Former Member

‎2010 Mar 15 5:58 AM

0 Likes
706

Hi,

i have developed a report using Dynamic ALV, when i used to save the output to excel, data in the output is matched with the excel. while executing the report in SAP screen it works fine. i have used REUSE_ALV_GRID.for this.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_bypassing_buffer = 'X'

i_buffer_active = ' '

i_callback_program = lv_repid

is_layout = gs_layout

it_fieldcat = gt_fieldcat

it_sort = gt_sort[]

it_events = gt_event

TABLES

t_outtab = <dyn_table>

EXCEPTIONS

program_error = 0

OTHERS = 0.

is there any settings to be done in the excel or should we add any additional parameters for local file?

pointers for this will be helpful.

Regards,

Dinesh

1 ACCEPTED SOLUTION
Read only

Go to solution
StMou
Active Participant

‎2010 Mar 15 11:04 AM

0 Likes
671

Hi,

What is your problem ?

If you don't see anything in Excel after download :

In Excel

first step

- Menu : Tools ->Macros->scurity

go to tab Trusted Publishers and flag Trust acces to Visual Basic Project

second step

allow execution of macro

- Menu : Tools ->Macros->scurity

go to tab security Level and choise medium or Low

Rgds

Hi,

i have developed a report using Dynamic ALV, when i used to save the output to excel, data in the output is matched with the excel. while executing the report in SAP screen it works fine. i have used REUSE_ALV_GRID.for this.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_bypassing_buffer = 'X'

i_buffer_active = ' '

i_callback_program = lv_repid

is_layout = gs_layout

it_fieldcat = gt_fieldcat

it_sort = gt_sort[]

it_events = gt_event

TABLES

t_outtab = <dyn_table>

EXCEPTIONS

program_error = 0

OTHERS = 0.

is there any settings to be done in the excel or should we add any additional parameters for local file?

pointers for this will be helpful.

Regards,

Dinesh

Reply
5 REPLIES 5
Read only

Go to solution
former_member194669
Active Contributor

‎2010 Mar 15 6:03 AM

0 Likes
671

Your question is not clear. I think you have issue with download.

Make it sure that COL_POS in field catalog to be filled & sequenced properly

a®

Read only

Go to solution
Kanagaraja_L
Active Contributor

‎2010 Mar 15 6:06 AM

0 Likes
671

And also check have you moved sy-repid to lv_repid ?

 lv_repid = sy-repid.

Read only

Go to solution
Former Member
In response to Kanagaraja_L

‎2010 Mar 15 9:20 AM

0 Likes
671

i have given that earlier.

Read only

Go to solution
Former Member

‎2010 Mar 15 10:49 AM

0 Likes
671

Hi ,

I am assuming that you have problem with download. Please try to download using your program from another PC.

If download is successful then you can compare the setting of excel sheet with yours or you can download using gui_download form your final internal table.

Read only

Go to solution
StMou
Active Participant

‎2010 Mar 15 11:04 AM

0 Likes
672

Hi,

What is your problem ?

If you don't see anything in Excel after download :

In Excel

first step

- Menu : Tools ->Macros->scurity

go to tab Trusted Publishers and flag Trust acces to Visual Basic Project

second step

allow execution of macro

- Menu : Tools ->Macros->scurity

go to tab security Level and choise medium or Low

Rgds