Better way to populate an excel spreadsheet on a web server in ASP.NET than interop?

Question

Is there a better way to populate an advanced data sheet on a web server (using asp.net) than using interop?

EDIT: I did not understand very clearly what I needed:

I have a template that I should use that is provided by our client. There are some password-protected macros in the template that I do not have access to, so I cannot create an excel file. I am stuck in updating excel excel file.

Answer 1

, . xls, , , . OleDb UPDATE , .

Answer 2

Office 2007 (Word, PowerPoint Excel) OpenXML. zip XML (, ) . API (System.IO.Packaging WindowsBase.dll) XML Framework.

OpenXMLDeveloper.org .

Answer 3

:

ExcelPackage: Open XML .

Excel 2007.

Answer 4

SpreadsheetGear. Excel 2007, ADO.Net. , Excel .

. , .

Answer 5

, csv . . , , .

Answer 6

.

, , , . Excel concurrency -. , , - , .

excel. . , , excel: , , html-, xml, openxml csv , , ..
Excel ASP.NET

, , , excel. -. .

Answer 7

, .

• -.

Save the results to a database for later work.

2. Refresh Excel spreadsheet.

Run the process that updates the spreadsheets.

This will not work if the website should return the results of the spreadsheet.

Answer 8

You can use the Excel XML specification.

I have a demo on my blog on how to do this in C # 3.0, as well as a link to an example on VB 9. It uses LINQ to XML.

The concept can be easily changed to .NET 2.0.

http://www.aaron-powell.com/blog/september-2008/linq-to-xml-to-excel.aspx