public void Select()
{
var driver = new XlsDriver();
using (var connection = driver.Connect(XlsUri))
{
connection.Open();
var dt = driver.Select(connection, "SELECT * FROM [Categories$]");
Assert.IsNotNull(dt);
Assert.IsTrue(dt.Rows.Count > 0);
connection.Close();
}
}
