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 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");
}
}
