• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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