Import Export DataTable

Essential XlsIO also has some helper methods that make working with ADO.NET datasources very easy. It only takes one line of code to import an ADO.NET datatable into a worksheet. You could also export the data as well. There are similar methods for working with other data sources like DataView, DataColumn, Arrays etc.