public void NamedWorksheetTest()
{
string namedWorksheetReference = "'Sheet 1'!B23";
bool success = XlWriteUtilities.TryParseCellReference(namedWorksheetReference, out Cell cell);
Assert.AreEqual("Sheet 1", cell.SheetName);
Assert.AreEqual(-1, cell.SheetNum);
Assert.AreEqual(2, cell.Column);
Assert.AreEqual(23, cell.Row);
}
public void NumberedSheetTest()
{
string numberSheetReference = "1!B23";
bool success = XlWriteUtilities.TryParseCellReference(numberSheetReference, out Cell cell);
Assert.AreEqual(null, cell.SheetName);
Assert.AreEqual(1, cell.SheetNum);
Assert.AreEqual(2, cell.Column);
Assert.AreEqual(23, cell.Row);
}
public void CellReferenceParser()
{
string a1Reference = "B23";
bool success = XlWriteUtilities.TryParseCellReference(a1Reference, out Cell cell);
Assert.AreEqual(null, cell.SheetName);
Assert.AreEqual(-1, cell.SheetNum);
Assert.AreEqual(2, cell.Column);
Assert.AreEqual(23, cell.Row);
string r1c1Reference = "r12c65";
success = XlWriteUtilities.TryParseCellReference(r1c1Reference, out cell);
Assert.AreEqual(65, cell.Column);
Assert.AreEqual(12, cell.Row);
}
