public void OpenTest_Create()
{
using (var excel = new OperateExcel())
{
excel.Open();
excel.Write(Cell.R1C1(1, 1), "1", "2", "3");
excel.Write(Cell.R1C1(101, 101), "あいうえおかきくけこ");
excel.Save(CalcPath("test.xlsx"));
}
Assert.IsTrue(File.Exists(CalcPath("test.xlsx")));
using (var excel = new OperateExcel())
{
excel.Open(CalcPath("test.xlsx"));
Assert.AreEqual(1, excel.Read <int>(Cell.R1C1(1, 1)));
Assert.AreEqual("2", excel.Read <string>(Cell.R1C1(1, 2)));
Assert.AreEqual(3.0, excel.Read <double>(Cell.R1C1(1, 3)));
Assert.AreEqual("あいうえおかきくけこ", excel.Read <string>(Cell.R1C1(101, 101)));
excel.Write(Cell.R1C1(4, 4), "さしすせそ");
excel.Save();
}
using (var excel = new OperateExcel())
{
excel.Open(CalcPath("test.xlsx"));
Assert.AreEqual("さしすせそ", excel.Read <string>(Cell.R1C1(4, 4)));
}
}
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 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")));
}
}
}
public void CopyAndInsertRowTest()
{
File.Copy("template.xlsx", CalcPath("test.xlsx"));
using (var excel = new OperateExcel())
{
excel.Open(CalcPath("test.xlsx"));
excel.CopyAndInsertRow(1, 2, 2, "Sheet2");
excel.CopyAndInsertRow(2, 2, 1);
Assert.AreEqual("1", excel.Read <string>(Cell.R1C1(2, 2)));
Assert.AreEqual("4", excel.Read <string>(Cell.R1C1(2, 5)));
Assert.AreEqual("あ", excel.Read <string>(Cell.R1C1(3, 2)));
Assert.AreEqual("あ", excel.Read <string>(Cell.R1C1(4, 2)));
Assert.AreEqual("え", excel.Read <string>(Cell.R1C1(3, 5)));
Assert.AreEqual("え", excel.Read <string>(Cell.R1C1(4, 5)));
}
}
