topic Re: export the data to excel in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140655#M1366919 <HTML><HEAD></HEAD><BODY><P>I dont think its possible.... because in normal excel sheet that is not possible right....</P><P></P><P>If you know how to do that manually in Excel then you can do that through OLE in SAP...</P></BODY></HTML> Mon, 31 Aug 2009 12:51:04 GMT Former Member 2009-08-31T12:51:04Z export the data to excel https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140654#M1366918 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P></P><P>Can any one please let me know how we can download the ALV gird with drill down to Excel. </P><P>I mean the data export into the excel should also have drill down.</P><P></P><P>Let me know your thoughts</P><P></P><P></P><P>Thanks,</P><P>Prem.</P></BODY></HTML> Mon, 31 Aug 2009 12:49:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140654#M1366918 Former Member 2009-08-31T12:49:07Z Re: export the data to excel https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140655#M1366919 <HTML><HEAD></HEAD><BODY><P>I dont think its possible.... because in normal excel sheet that is not possible right....</P><P></P><P>If you know how to do that manually in Excel then you can do that through OLE in SAP...</P></BODY></HTML> Mon, 31 Aug 2009 12:51:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140655#M1366919 Former Member 2009-08-31T12:51:04Z Re: export the data to excel https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140656#M1366920 <HTML><HEAD></HEAD><BODY><P>I never used OLE.. Could you please elaborate me on how we can achieve this.</P></BODY></HTML> Mon, 31 Aug 2009 12:56:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140656#M1366920 Former Member 2009-08-31T12:56:32Z Re: export the data to excel https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140657#M1366921 <HTML><HEAD></HEAD><BODY><P>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....</P><P></P><P>I just have an example of using OLE... but thats not for giving a tree view in Excel.....</P><P></P><P>[Click Here to see the example|/people/alvaro.tejadagalindo/blog/2009/02/05/excel-ole-and-abap--create-fancy-reports]</P><P></P><P>Regards,</P><P>Siddarth</P></BODY></HTML> Mon, 31 Aug 2009 13:26:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/export-the-data-to-excel/m-p/6140657#M1366921 Former Member 2009-08-31T13:26:41Z