topic Re: dowload data to excel multiple tabs in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771728#M1463270 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>We can provide the number of sheets required using the 'SET' property of excel.</P><P></P><P>set property of w_excel 'sheetsinnewworkbook' = 5.</P><P></P><P>Regards</P><P>harris</P></BODY></HTML> Wed, 21 Apr 2010 06:39:57 GMT Former Member 2010-04-21T06:39:57Z dowload data to excel multiple tabs https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771726#M1463268 <HTML><HEAD></HEAD><BODY><P>Hi frds,</P><P></P><P>By using OLE i can able to download dat to 3 tabs in ecel sheet But how can we add 4 th tab to excel sheet by using OLE.</P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 21 Apr 2010 06:28:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771726#M1463268 Former Member 2010-04-21T06:28:57Z Re: dowload data to excel multiple tabs https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771727#M1463269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Follow This Link,</P><P><A href="http://wiki.sdn.sap.com/wiki/display/Snippets/Multiple" target="test_blank">http://wiki.sdn.sap.com/wiki/display/Snippets/Multiple</A><EM>sheet</EM>Excel<EM>Document</EM>from<EM>SAP</EM>using+OLE</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="8887487"></A></P><P>I think These sort out Your Scenario.....</P><P></P><P>Regards,</P><P>Raghava Channooru</P></BODY></HTML> Wed, 21 Apr 2010 06:35:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771727#M1463269 Former Member 2010-04-21T06:35:45Z Re: dowload data to excel multiple tabs https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771728#M1463270 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>We can provide the number of sheets required using the 'SET' property of excel.</P><P></P><P>set property of w_excel 'sheetsinnewworkbook' = 5.</P><P></P><P>Regards</P><P>harris</P></BODY></HTML> Wed, 21 Apr 2010 06:39:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/dowload-data-to-excel-multiple-tabs/m-p/6771728#M1463270 Former Member 2010-04-21T06:39:57Z