public void Reference1() { XlCell cell = xs.AddCell(1, 1, 1, XlContentType.Integer); cell.Reference = "A1"; Assert.AreEqual("A1", cell.Reference); Assert.AreEqual(1, cell.Row); Assert.AreEqual(1, cell.Col); cell.Reference = "B2"; Assert.AreEqual("B2", cell.Reference); Assert.AreEqual(2, cell.Row); Assert.AreEqual(2, cell.Col); cell.Reference = "BB48"; Assert.AreEqual("BB48", cell.Reference); Assert.AreEqual(48, cell.Row); Assert.AreEqual(54, cell.Col); cell.Reference = "AR1"; Assert.AreEqual("AR1", cell.Reference); Assert.AreEqual(1, cell.Row); Assert.AreEqual(44, cell.Col); cell.Reference = "XFD010"; Assert.AreEqual("XFD10", cell.Reference); Assert.AreEqual(10, cell.Row); Assert.AreEqual(16384, cell.Col); }
public DummySchemaRowData(XlSchema schema, int rowIndex) { int columnIndex = 1; foreach (XlColumn column in schema.Columns) { XlCell cell = new XlCell(0U, column.Type, GetValue(column.Type, rowIndex, columnIndex++)); _list.Add(cell); } }
public void Reference() { XlCell cell = xs.AddCell(DateTime.Now, 1, 1, XlContentType.Date); Assert.AreEqual("A1", cell.Reference); cell.Col = 15; cell.Row = 2; Assert.AreEqual("O2", cell.Reference); cell.Col = 78; cell.Row = 3; Assert.AreEqual("BZ3", cell.Reference); }
public SchemaRowData(XlSchema schema, List <string> items) { int columnIndex = 0; foreach (XlColumn column in schema.Columns) { string item; if (items[columnIndex] != null) { item = items[columnIndex]; } else { item = ""; } XlCell cell = new XlCell(0U, column.Type, item); _list.Add(cell); columnIndex++; } }
public void Reference0() { XlCell cell = xs.AddCell(DateTime.Now, 1, 1, XlContentType.Date); cell.Reference = "asdasd a"; }
public void Constructor1() { XlCell cell = xs.AddCell(DateTime.Now, 0, 0, XlContentType.Date); }
public void Constructor0() { XlCell cell = xs.AddCell(1, 1, 1, XlContentType.Integer); Assert.IsNotNull(cell); }