Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

Report report generation on spread sheet.

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.
1 Solution
I did something very similar with openXML.

There is a 3rd party component from independsoft. This makes life a bit easier but has a timing problem with updating references. I would recommend using openXML. There are lots of samples in the net.

It is a bit more complicated if you want to use a template as base but you can do nearly everything what you could do with Excel also.
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

GouthamAnandAuthor Commented:
Thanks a lot

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now