public void SetUp()
{
var book = Workbook.Open(@"TestData\Book1.xlsx");
いろいろなデータ = book.Sheets["いろいろなデータ"];
a1 = いろいろなデータ.Cells["A1"];
b1 = いろいろなデータ.Cells["B1"];
a2 = いろいろなデータ.Cells["A2"];
b2 = いろいろなデータ.Cells["B2"];
a3 = いろいろなデータ.Cells["A3"];
b3 = いろいろなデータ.Cells["B3"];
}
private Cell GetItem(CellName cellName)
{
if (!cache.ContainsKey(cellName))
{
var cellXml =
from cell in sheet.WorksheetPart.Worksheet.Descendants<Spreadsheet.Cell>()
where cell.CellReference == cellName.ToString()
select cell;
if (cellXml.Any())
{
cache[cellName] = new Cell(sheet, cellXml.Single());
}
else
{
cache[cellName] = new Cell(sheet, cellName.ToString());
}
}
return cache[cellName];
}