示例#1
0
        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)));
            }
        }