Search code examples
asp.net-mvclinq-to-excel

Can I use LinqToExcel for saving edited data to excel?

I am using LinqToExcel for sorting of data. I want to save sorted data back to excel. For that is there any function in LinqToExcel

Solution

  • As mentioned on the LinqToExcel project page, it is designed for querying data, not modifying data. So no, there is not anything built into LinqToExcel to allow this.

    To modify an Excel sheet, you will need to use either the Visual Studio Tools for Office (VSTO), Open Office XML, or a third-party library that wraps one of these.