Last post Oct 26, 2007 10:22 AM by Davefriend
Oct 25, 2007 12:40 PM|Davefriend|LINK
I have a project which needs to generate 100+ excel reports at run time. The application needs to take input from web page, then connect to oracle database and retrieve dataset, using the data to populate a few worksheets then save the workbook
as excel report, then again for the next report. The problem I have here is I don't have office excel 2003 installed on server, Is there an example similar to my applicaiton I can reference? My project envrionment is .net 2.0, excel 2003 and VSTO 2005.
Oct 25, 2007 01:10 PM|jguadagno|LINK
You can purchase a server control that generates Excel files (http://officewriter.softartisans.com/)
There are also plenty of forum messages regarding generating Excel files.
Oct 25, 2007 03:55 PM|Davefriend|LINK
Thanks for the reply, I have googled on solutions to my project. I have also considered using OWC, yet I have one single problem with it - I can not load image into excel file with OWC. Do you have some particular link I can follow? Thanks a lot.
Oct 25, 2007 04:12 PM|jguadagno|LINK
This is a popular one:
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx I do not know if it supports images. Other than that, I have not had the need yet. Sorry
Oct 26, 2007 10:22 AM|Davefriend|LINK
Great, thanks for the reference.