private List <Object> _ListPOIS() { var driver = new XlsDriver(); var conn = driver.Connect(@"C:\Users\Entrevista\Documents\Visual Studio 2015\Projects\MapsTest\MapsTest\bin\Data\ds.xls"); conn.Open(); var dt = driver.ListData(conn, "POIs"); var data = new List <Object>(); foreach (DataRow row in dt.Rows) { IDictionary <string, object> props = new Dictionary <string, object>(); foreach (DataColumn col in dt.Columns) { props.Add(col.ColumnName.Replace(" ", "").Replace("(", "").Replace(")", ""), row[col.Ordinal]); } data.Add(props); return(data); } conn.Close(); return(data); }
public void ListData() { var driver = new XlsDriver(); using (var connection = driver.Connect(XlsUri)) { connection.Open(); var dt = driver.ListData(connection, "POIs"); Assert.IsNotNull(dt); Assert.IsTrue(dt.Rows.Count > 0); connection.Close(); } }