Click here to Skip to main content
15,669,890 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I want to create excel reports and reports should be available in browser in my aspx page with some input parameters and any registered user should be able to access it from anywhere. I have 2 options in my case:
1. Creating excel report using c# code and exporting to excel (reports have graphs as well)

2. develop reports using SSRS and display in aspx page using reportviewer control.

Please let me know which is the best way. Security is main concern. if you suggest creating rdls, what extra configuration and permissions are requied to access reports.


1 solution

well, as far as i know there are only three ways of dealing with excel sheets, and I would recommend the open xml sdk (capable of using templates and adding graphs and it's fast), interopt is easy, but a pain in the ass and obdle is, let's say handicapped.

but, though it is said that "you can comfortably run Open XML SDK 2.0 based code on high volume web servers for example, a place you would not typically want to be running Microsoft Word", I think you might run into privilege issues.

search for "open xml sdk excel", there are even some webcasts and a sample of manipulating charts on -[^] by the way, tanks to Eric White for genius work on open xml.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900