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 GetSheetNamesTest()
{
using (var excel = new OperateExcel())
{
excel.Open("template.xlsx");
var names = excel.GetSheetNames();
Assert.AreEqual(4, names.Count);
Assert.AreEqual("Sheet1", names[0]);
Assert.AreEqual("テスト", names[1]);
Assert.AreEqual("Sheet2", names[2]);
Assert.AreEqual("検索", names[3]);
}
}
public void CreateSheetTest()
{
using (var excel = new OperateExcel())
{
excel.Open();
excel.CreateSheet("first", OperateExcel.SheetPosition.First);
var names = excel.GetSheetNames();
Assert.AreEqual(2, names.Count);
Assert.AreEqual("first", names[0]);
Assert.AreEqual("Sheet1", names[1]);
excel.CreateSheet("last", 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.CreateSheet("after", 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.CreateSheet("before", 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]);
}
}
