How can I write to an Excel spreadsheet using Linq?

Asked 2009-10-06T20:03:44.767

I'm writing an app where I need to retrieve some rows from a DB and dump them into an Excel spreadsheet. I'm using Linq to retrieve these rows.

Is it possible to dump these rows directly into their counterparts in the Excel sheet (where one cell in Excel corresponds to one cell from the DB)?

c# linq excel interop

Edit Report

1 Answer

The quickest solution will be to create a csv file:

col1, colb, colc
col1, colb, colc

Excel works very well with csv files.

answered 2009-10-06T20:08:21.737