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.