public override string ToString() { string firstCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwFirst + 1, (colFirst + 1) & 0xFF)); string secondCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwLast + 1, (colLast + 1) & 0xFF)); return(string.Format("{0}:{1}", firstCell, secondCell)); }
public override string ToString() { string firstCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwFirst + 1, (colFirst + 1) & 0xFF)); string secondCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwLast + 1, (colLast + 1) & 0xFF)); //TODO: Map the ixti offset to the appropriate sheet name return(string.Format("[ixti{0}]{1}:{2}", ixti, firstCell, secondCell)); }
public string GetCellName(bool r1c1style = false) { string r1c1 = string.Format("R{0}C{1}", this.rw + 1, this.col + 1); if (r1c1style) { return(r1c1); } return(ExcelHelperClass.ConvertR1C1ToA1(r1c1)); }
public override string ToString() { string cellString = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rw + 1, (col + 1) & 0xFF)); if (string.IsNullOrEmpty(SheetName)) { string refString = string.Format("Sheet[ixti={0}]!{1}", ixti, cellString); return(refString); } else { return(string.Format("{0}!{1}", SheetName, cellString)); } }
public override string ToString() { //Special case where the area is the ENTIRE row or the ENTIRE column if (colFirst == 0 && colLast == 0xFF && rwFirst == rwLast) { return(string.Format("{0}:{0}", rwFirst + 1)); } else if (rwFirst == 0 && rwLast == 0xFFFF && colFirst == colLast) { return(string.Format("{0}:{0}", ExcelHelperClass.GetExcelA1ColNameFromColNumber(colFirst + 1))); } string firstCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwFirst + 1, (colFirst + 1) & 0xFF)); string secondCell = ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rwLast + 1, (colLast + 1) & 0xFF)); return(string.Format("{0}:{1}", firstCell, secondCell)); }
public void TestA1R1C1Conversion() { string a1cell = "A1"; string r1c1cell = "R1C1"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "C5"; r1c1cell = "R5C3"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "FE100"; r1c1cell = "R100C161"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); }
public void TestA1R1C1Conversion() { string a1cell = "A1"; string r1c1cell = "R1C1"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "C5"; r1c1cell = "R5C3"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "FE100"; r1c1cell = "R100C161"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "HZ46"; r1c1cell = "R46C234"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "IU255"; r1c1cell = "R255C255"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "AA1"; r1c1cell = "R1C27"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); a1cell = "AZ1"; r1c1cell = "R1C52"; Assert.AreEqual(a1cell, ExcelHelperClass.ConvertR1C1ToA1(r1c1cell)); Assert.AreEqual(r1c1cell, ExcelHelperClass.ConvertA1ToR1C1(a1cell)); }
public override string ToString() { //Make sure to truncate column values that use any value > 255 return(ExcelHelperClass.ConvertR1C1ToA1(string.Format("R{0}C{1}", rw + 1, (col + 1) & 0xFF))); }