piątek, 27 marca 2015

Excel to dataset...dataset to Excel

Na razie zbieram ciekawe linki:
http://stackoverflow.com/questions/14261655/best-fastest-way-to-read-an-excel-sheet-into-a-datatable

Biblioteka easyXLSX: http://www.easyxls.com/manual/FAQ/import-excel-to-datatable.html
http://www.codeproject.com/Questions/376355/import-MS-Excel-to-datatable
http://csharp.net-informations.com/excel/csharp-excel-oledb.htm

Dataset 2 Excel
http://stackoverflow.com/questions/5790431/export-data-from-dataset-to-excel
http://www.codeproject.com/Articles/11171/DataSet-to-Excel-in-Two-steps-with-Different-Style
https://social.msdn.microsoft.com/Forums/vstudio/en-US/ea02f8e8-edf5-4aca-8c74-ef3a94b5328d/export-dataset-into-excel-sheet-in-c?forum=csharpgeneral

ExcelDNA <-> Access
http://www.mikesdotnetting.com/article/79/import-data-from-excel-to-access-with-asp-net
https://smurfonspreadsheets.wordpress.com/category/excel/page/6/

Linq!
https://code.google.com/p/linqtoexcel/
https://msdn.microsoft.com/en-us/library/dd920313%28v=office.12%29.aspx
http://blogs.msdn.com/b/ericwhite/archive/2008/11/14/using-linq-to-query-excel-tables.aspx
http://dennis.bloggingabout.net/2008/02/29/getting-data-from-excel-the-fast-way-using-linq/

Update:
Linq:
http://geekswithblogs.net/CodeSpeaker/archive/2009/10/04/using-linq-with-excel-sheets.aspx
http://dennis.bloggingabout.net/2008/02/29/getting-data-from-excel-the-fast-way-using-linq/
http://www.nathanpjones.com/wp/2013/06/query-excel-file-using-linq/

Chyba najlepsze:
http://stackoverflow.com/questions/1485958/read-excel-using-linq
https://vimeo.com/7689508



Brak komentarzy:

Prześlij komentarz