public void ReadRowTestOne()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
excel.SelectSheet("Sheet2");
var row = excel.ReadRow(4, ColumnsRange.A1("B:B"));
Assert.AreEqual("あ", row[0]);
Assert.AreEqual(1, row.Count);
}
}
public void ReadRowTest()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
excel.SelectSheet("Sheet2");
var row = excel.ReadRow(4, ColumnsRange.A1("B:F"));
Assert.AreEqual("あ", row[0]);
Assert.AreEqual("い", row[1]);
Assert.AreEqual("う", row[2]);
Assert.AreEqual("え", row[3]);
Assert.AreEqual("", row[4]);
Assert.AreEqual(5, row.Count);
}
}