Populate Excell Sheet using ASP.NET/VB.NET

[Guest]

I have an Excel sheet that I want to be able to make changes to it
using ASP/VB.NET (like updating cells values and maybe formulas). Once
it's done; I want to save it and then launch the changed file to the
user.

How do I do that? Any examples available?

 

[Mark Rae]

I have an Excel sheet that I want to be able to make changes to it
using ASP/VB.NET (like updating cells values and maybe formulas). Once
it's done; I want to save it and then launch the changed file to the
user.

How do I do that? Any examples available?

http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

This might be your best bet. You can open Excel as an ADO.NET data source:
http://groups.google.com/group/micr...14d90e974e5/571439ff12d7473d#571439ff12d7473d

Here are some other articles that may help as well:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx