public void FindTest()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
int row, column;
excel.SelectSheet("検索");
Assert.IsTrue(excel.Find(CellsRange.ColumnRange("C"), "中川義男", out row, out column));
Assert.AreEqual(9, row);
Assert.AreEqual(3, column);
Assert.IsFalse(excel.Find(CellsRange.ColumnRange("C"), "山本", out row, out column));
Assert.IsTrue(excel.Find(CellsRange.ColumnRange("C"), "山本", out row, out column, true));
Assert.AreEqual(12, row);
Assert.AreEqual(3, column);
}
}
public void FindTest_Table()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
int row, column;
excel.SelectSheet("Sheet2");
Assert.IsTrue(excel.Find(CellsRange.A1("B2:E5"), "え", out row, out column));
Assert.AreEqual(4, row);
Assert.AreEqual(5, column);
}
}
