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]; }