This project has moved and is read-only. For the latest updates, please go here.

New method(s): Excel.WorkSheet.ToDataTable and/or Excel.WorkBook.ToDataSet

Jan 25, 2013 at 10:27 AM

I use ClosedXML (a lot) to load tables from Excel files into .NET DataSets, and back. This idea / suggestion if there are enough others out there who do the same.

In my work I also use a lot of xml files. For example to read in orders or to send delivery confirmations, stuff like that. .NET has these really nifty DataSet functions .ReadXML and .WriteXML, which make that work a breeze. Showing such data in any kind of grid is as simple as binding a DataSet to it.

So in the spirit of the ClosedXML library making life easier for us lazy nerds  ;-) here is the idea / request: a method that will read a table from an Excel worksheet into a .NET DataTable, which can then easily be added to a DataSet, and/or a method that reads an entire workbook into a dataset.

I already wrote my own wrapper methods, so this is no biggie, but I figure that I am not the only one who would be very happy with something like this.