Web service Excel conversion

Question

I have ASP.NET web service, which is creating file in XML table format.

I need to convert this file into Excel 2003 format.

What can I use instead of Microsoft.Interop library?

UPDATE: I also need to copy format from the original file.

Answer 1

you can read the data from xml using linq and then insert it on the run using linq to excel with the dll provided in the post above.

also take a look at this article i hope it helps

http://blogs.msdn.com/b/bethmassi/archive/2007/10/30/quickly-import-and-export-excel-data-with-linq-to-xml.aspx

Answer 2

Have you tried OpenXML? Here is an example

With Office 2007

Look here for Cell Formatting