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]); }