public void ConvertToTitleTest() { var test = new P0168_ExcelSheetColumnTitle(); Assert.AreEqual("A", test.ConvertToTitle(1)); Assert.AreEqual("AB", test.ConvertToTitle(28)); Assert.AreEqual("AZ", test.ConvertToTitle(52)); Assert.AreEqual("ZY", test.ConvertToTitle(701)); Assert.AreEqual("AAA", test.ConvertToTitle(703)); }
public void TitleToNumberTest() { var test = new P0171_ExcelSheetColumnNumber(); var title = new P0168_ExcelSheetColumnTitle(); for (int i = 1; i < 26 * 26 * 26 + 1; i++) { Assert.AreEqual(i, test.TitleToNumber(title.ConvertToTitle(i))); } }