Excel

Perigee provides several easy methods to read Excel files into DataTables or DataSets.

//Get a memory stream of the object to read
using MemoryStream ms = new MemoryStream(File.ReadAllBytes("ExcelFile.xlsx"));

//Read "DataSheet"
var DT = ExcelReader.ReadDataTable(ms, "DataSheet", out DynamicDataTable ddt, TrimCells: true);

//Read two sheets, and return the data set
var dataSet = ExcelReader.ReadDataSet(ms, new List<string>() { "DataSheet", "Lookup" });