Last post Sep 16, 2010 12:28 AM by lasantha
Sep 07, 2010 10:34 AM|MKozlowski|LINK
I would like to have a button on the report project result form where I can click on it and have it export the project data to excel?
Any help is appreciated. I tried some code but not having success.
Sep 07, 2010 11:33 AM|felixthenoble|LINK
You have 3 options.
First, you could use Office Automation. This is not recommended since Excel and Word are not meant to be run on a web server with many different clients. http://www.eggheadcafe.com/articles/20021012.asp
Second, you can use a tool like ExcelXmlWriter. This only generates XLS (Excel 2003) files. It's fast and can be run on a web server easily since there is no office automation used. http://www.carlosag.net/Tools/ExcelXmlWriter/
Third, you can use the new Office XML to generate Excel 2007 or 2010 files. The following articles are good starting points for Office XML:
Sep 07, 2010 11:35 AMemail@example.com|LINK
How is the data in the Report form. Is it is in GRIDVIEW. If it is so, you can directly render the Grid and Excel
If it is in some other format and want to create a Excel file and export use office excel library (10 or 11) and write a excel file .
Sep 07, 2010 01:05 PM|MKozlowski|LINK
Thanks for the feedback. I was able to do it with this:
Sep 15, 2010 11:37 PM|chetan.sarode|LINK
Please refer this
Sep 16, 2010 12:28 AM|lasantha|LINK
see this post