public void ParseCellTest()
{
Assert.AreEqual(0, Cell.Parse("A").Col);
Assert.AreEqual(25, Cell.Parse("Z").Col);
Assert.AreEqual(26, Cell.Parse("AA1").Col);
Assert.AreEqual(52, Cell.Parse("BA1").Col);
}
public CellData this[String location]
{
get {
var cell = Cell.Parse(location);
return(this[cell]);
}
}
public static Range Parse(string range)
{
int colon = range.IndexOf(':');
if (colon != -1)
{
var c1 = Cell.Parse(range, 0, colon);
var c2 = Cell.Parse(range, colon + 1, range.Length - colon - 1);
return(new Range
{
Cell1 = c1, Cell2 = c2
});
}
else
{
var c = Cell.Parse(range);
return(new Range
{
Cell1 = c,
Cell2 = c.Clone()
});
}
}
public SheetRange this[String c1, String c2]
{
get { return(new SheetRange(this, new Range {
Cell1 = Cell.Parse(c1), Cell2 = Cell.Parse(c2)
})); }
}
public Range(String cell1, String cell2)
{
Cell1 = Cell.Parse(cell1);
Cell2 = Cell.Parse(cell2);
}