<div>
Why not use Excel to connect to your Oracle datasource? &nbsp;Then query thru Excel directly?
</div>


Why not use Excel to connect to your Oracle datasource?  Then query thru Excel directly?

<div>
I have SQL server as a back end and I can only call the store procedure and get the data from it. <br />
I have no rights to do any thing extra
</div>


I have SQL server as a back end and I can only call the store procedure and get the data from it.
I have no rights to do any thing extra

<div>
<div class="content wysiwyg-content">
I have requirement, I need to call a store procedure which returns me a data set.<br />
<br />
Now my client does not want to use any third party tools and they want to export this store proc data into multiple sheet in a single excel file and then allow user to download it.<br />
<br />
Any one please what are best options for me to go ahead on this. <br />

</div>
</div>


I have requirement, I need to call a store procedure which returns me a data set.

Now my client does not want to use any third party tools and they want to export this store proc data into multiple sheet in a single excel file and then allow user to download it.

Any one please what are best options for me to go ahead on this. 


Exporting data in Multiple excel Sheet from asp.net

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.