private static void testColumns(ExcelReader target, bool xlsx)
{
string[] cols = target.GetColumnsList("Plan1");
Assert.AreEqual(3, cols.Length);
Assert.AreEqual("Header1", cols[0]);
Assert.AreEqual("Header2", cols[1]);
Assert.AreEqual("Header3", cols[2]);
cols = target.GetColumnsList("Plan2");
Assert.AreEqual(3, cols.Length);
if (target.Provider == "Microsoft.Jet.OLEDB.4.0")
{
Assert.AreEqual("F1", cols[0]);
Assert.AreEqual("F2", cols[1]);
Assert.AreEqual("F3", cols[2]);
}
else
{
Assert.AreEqual("1", cols[0]);
Assert.AreEqual("2", cols[1]);
Assert.AreEqual("3", cols[2]);
}
cols = target.GetColumnsList("Plan3");
Assert.AreEqual(2, cols.Length);
Assert.AreEqual("A", cols[0]);
Assert.AreEqual("B", cols[1]);
cols = target.GetColumnsList("Sheet1");
Assert.AreEqual(1, cols.Length);
Assert.AreEqual("F1", cols[0]);
}