Application Development 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
Showing results for 
Search instead for 
Did you mean: 

ALV Grid output to Excel Spreadsheet

Former Member
0 Kudos

I have one that is hopefully easy for you guys and when I search on the forum nothing comes up.

Maybe I am searching wrong.

When you have a program that outputs to an ALV grid, there is a button you can output to a file.

Like an excel document. Icon is a document with an x on it.

First time you run it, it will give you the option of excel, star office, or all available formats.

There is also a button at the bottom that says Always Use Selected Format. User

wants to change this, but once the option is gone, you cannot undo it.

How do I basically deactivate the button to not always use the selected format???

Any suggestions would be terrific.

Thanks for your help.

Steve

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Steve,

Try running report SALV_BS_ADMIN_MAINTAIN as indicated in [Note 1080608|https://service.sap.com/sap/support/notes/1080608].

I found this Note with the following search string: "Always Use Selected Format ALV Excel". You may also want to consider doing a search on the report name "SALV_BS_ADMIN_MAINTAIN" for further information.

Also check [Note 1157927|https://service.sap.com/sap/support/notes/1157927] "Export Excel: Reset export parameter from ALV list."

Best Regards,

Jamie

Edited by: James Gaddis on Nov 19, 2008 2:47 PM - Added another Note reference

3 REPLIES 3

Former Member
0 Kudos

Steve,

Try running report SALV_BS_ADMIN_MAINTAIN as indicated in [Note 1080608|https://service.sap.com/sap/support/notes/1080608].

I found this Note with the following search string: "Always Use Selected Format ALV Excel". You may also want to consider doing a search on the report name "SALV_BS_ADMIN_MAINTAIN" for further information.

Also check [Note 1157927|https://service.sap.com/sap/support/notes/1157927] "Export Excel: Reset export parameter from ALV list."

Best Regards,

Jamie

Edited by: James Gaddis on Nov 19, 2008 2:47 PM - Added another Note reference

Former Member
0 Kudos

Try this

it has all the information about ALV

Regards

Neha

Former Member
0 Kudos

Thanks everyone for the great responses. OSS Note fixed my issue.

Best Regards,

Steve