<div>
Depending on the compleity, you could do it in Excel with VBA code.<br />
Since you have to match an Excel template Crystal Reports won't help<br />
<br />
mlmcc
</div>


Depending on the compleity, you could do it in Excel with VBA code.
Since you have to match an Excel template Crystal Reports won't help

mlmcc

<div>
<div class="content wysiwyg-content">
I am working on ASP.net applicaiton. I have to generate a complicated report on a predifined excel template (it is not just single page, it is a booklet). I have to get the data from SQL Server database and then fill the template with data and then download to client machine on press of button on browser.<br />
<br />
Please suggest me whether I need any 3rd party components for this? And please explain me the steps to achieve this.
</div>
</div>


I am working on ASP.net applicaiton. I have to generate a complicated report on a predifined excel template (it is not just single page, it is a booklet). I have to get the data from SQL Server database and then fill the template with data and then download to client machine on press of button on browser.

Please suggest me whether I need any 3rd party components for this? And please explain me the steps to achieve this.

Report report generation on spread sheet.

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

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

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