By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Asp.net / C# Webforms - Create excel spreadsheet and chart using a dataset

P: 1
Hello everyone, I am currently working on a project that requires a webform in asp.net using C# as the code behind. The page must allow the user to create a report in excel. This report must also generate a chart based on the input dataset. (By the way, the component must be free)
So far, I have tried a lot of components which are really good but they do not provide all the required functionality altogether and some of them have trade offs when posting them into the web server. I 'll give you some examples:

1. When using MS ReportViewer, you have all the capabilities but there is not enough documentation in order to create tables and charts dynamically. Everithing from the design to the datasource must be specified in advance.
2. CarlosAr.net provides ExcelXmlWriter, which is good because does not requires excel installed ion the client, but you can not create charts.
3. .Net provides some COM libraries for excel. Using this approach, I can do all that I want, but when it comes to run the paeg from the actual server, the functionality is not allowed due to some security issues. Besides, it requires excel to be installed on the client side.

Does anyone knows a FREE tool that provides the following functionality:

1. Allows creation of excel spreadsheets and charts without defining the dataset and datasource in advance.
2. Does not require excel to be installed on the server nor the client side.


Thanks in advanced

-Eolmos
Mar 27 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.