public void SpreadsheetReadFile() { var excelMapper = new ExcelMapper(); excelMapper.Add("A", "HotelKey", ExcelMapper.Type.String); excelMapper.Add("B", "HotelName", ExcelMapper.Type.String); excelMapper.Add("C", null, ExcelMapper.Type.String); excelMapper.Add("D", "LocationType", ExcelMapper.Type.String); excelMapper.Add("E", "Address_1", ExcelMapper.Type.String); excelMapper.Add("F", "Address_2", ExcelMapper.Type.String); excelMapper.Add("G", "Address_3", ExcelMapper.Type.String); excelMapper.Add("H", "Address_4", ExcelMapper.Type.String); excelMapper.Add("I", "Phone", ExcelMapper.Type.String); excelMapper.Add("J", "Fax", ExcelMapper.Type.String); excelMapper.Add("K", "Email", ExcelMapper.Type.String); excelMapper.Add("L", "Website", ExcelMapper.Type.String); excelMapper.Add("M", "StarRating", ExcelMapper.Type.Int); excelMapper.Add("N", "Category", ExcelMapper.Type.String); excelMapper.Add("O", "Latitude", ExcelMapper.Type.Double); excelMapper.Add("P", "Longitude", ExcelMapper.Type.Double); excelMapper.Add("Q", "CityCode", ExcelMapper.Type.String); excelMapper.Add("R", "CityName", ExcelMapper.Type.String); excelMapper.Add("S", "CountryCode", ExcelMapper.Type.String); excelMapper.Add("T", null, ExcelMapper.Type.String); excelMapper.Add("U", "CountryName", ExcelMapper.Type.String); JsonConvert.SerializeObject(excelMapper); var fileName = @"E:\Source\Netbiis-Git\dotnet-spreadsheet\src\Netbiis.Spreadsheet\Netbiis.SpreadsheetTest\Files\HotelProvider.xlsx"; var fileStream = new FileStream(fileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite); var spreadsheet = new Excel(); var hotelProvider = spreadsheet.ReadFile <HotelProvider>(fileStream, excelMapper, true); }