MVC2: SQL Server table --> Excel Spreadsheet

is there an easy way to export a SQL Server table into a xls spreadsheet?

T开发者_运维技巧hanks

---

NPoi or EPPlus. You should create the spredsheet in memory and send it via the File action result.

---

found a nice and easy solution

http://blog.wiredworx.co.uk/website-and-seo/c-tutorials-and-tips-visual-studio/exporting-to-an-excel-file-from-asp-net-mvc/