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

export the data to excel

Former Member

‎2009 Aug 31 1:49 PM

0 Likes
472

Hi Expert,

Can any one please let me know how we can download the ALV gird with drill down to Excel.

I mean the data export into the excel should also have drill down.

Let me know your thoughts

Thanks,

Prem.

3 REPLIES 3
Read only

Former Member

‎2009 Aug 31 1:51 PM

0 Likes
428

I dont think its possible.... because in normal excel sheet that is not possible right....

If you know how to do that manually in Excel then you can do that through OLE in SAP...

Read only

Former Member
In response to Former Member

‎2009 Aug 31 1:56 PM

0 Likes
428

I never used OLE.. Could you please elaborate me on how we can achieve this.

Read only

Former Member
In response to Former Member

‎2009 Aug 31 2:26 PM

0 Likes
428

I have never done any tree view in Excel manually .... So if you know how to do that manually in Excel then using OLE also it can be done, the way you can achieve it manually....

I just have an example of using OLE... but thats not for giving a tree view in Excel.....

[Click Here to see the example|/people/alvaro.tejadagalindo/blog/2009/02/05/excel-ole-and-abap--create-fancy-reports]

Regards,

Siddarth