public void OpenTest_Open()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
excel.SelectSheet("テスト");
Assert.AreEqual("ほげほげ", excel.Read <string>(Cell.A1("B2")));
}
}
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 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);
}
}
public void CopySheetTestReal()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
excel.CopySheet("コピーした奴", "検索", OperateExcel.SheetPosition.First);
excel.CreateSheet("新規作成奴", OperateExcel.SheetPosition.AfterCurrentSheet);
excel.SelectSheet("新規作成奴");
excel.Write(Cell.A1("A1"), "おおおお");
excel.Save("testCopy.xlsx");
}
}
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);
}
}
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 CopySheetTest()
{
using (var excel = new OperateExcel())
{
excel.Open();
excel.Write(Cell.A1("B2"), "あいうえお");
excel.CopySheet("first", "Sheet1", OperateExcel.SheetPosition.First);
var names = excel.GetSheetNames();
Assert.AreEqual(2, names.Count);
Assert.AreEqual("first", names[0]);
Assert.AreEqual("Sheet1", names[1]);
excel.CopySheet("last", "Sheet1", OperateExcel.SheetPosition.Last);
names = excel.GetSheetNames();
Assert.AreEqual(3, names.Count);
Assert.AreEqual("first", names[0]);
Assert.AreEqual("Sheet1", names[1]);
Assert.AreEqual("last", names[2]);
excel.CopySheet("after", "Sheet1", OperateExcel.SheetPosition.AfterCurrentSheet);
names = excel.GetSheetNames();
Assert.AreEqual(4, names.Count);
Assert.AreEqual("first", names[0]);
Assert.AreEqual("Sheet1", names[1]);
Assert.AreEqual("after", names[2]);
Assert.AreEqual("last", names[3]);
excel.CopySheet("before", "Sheet1", OperateExcel.SheetPosition.BeforeCurrentSheet);
names = excel.GetSheetNames();
Assert.AreEqual(5, names.Count);
Assert.AreEqual("first", names[0]);
Assert.AreEqual("before", names[1]);
Assert.AreEqual("Sheet1", names[2]);
Assert.AreEqual("after", names[3]);
Assert.AreEqual("last", names[4]);
foreach (var name in names)
{
excel.SelectSheet(name);
Assert.AreEqual("あいうえお", excel.Read <string>(Cell.A1("B2")));
}
}
}
