Import Export DataTable

Essential XlsIO also provides a simple API that makes 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.