C# (CSharp) ColumnPropertyData.GetColumnIndexFromCellAddress示例

示例#1

        public void IndexConverter_A()
        {
            var index = ColumnPropertyData.GetColumnIndexFromCellAddress("A");

            index.ShouldBe(1);
        }

示例#2

        public void IndexConverter_XFEWithRow()
        {
            var index = ColumnPropertyData.GetColumnIndexFromCellAddress("XFE234");

            index.ShouldBe(16385);
        }

示例#3

        public void IndexConverter_PC()
        {
            var index = ColumnPropertyData.GetColumnIndexFromCellAddress("PC");

            index.ShouldBe(419);
        }

示例#4

        public void IndexConverter_XFD()
        {
            var index = ColumnPropertyData.GetColumnIndexFromCellAddress("XFD");

            index.ShouldBe(16384);
        }

示例#5

        public void IndexConverter_IVWithRow()
        {
            var index = ColumnPropertyData.GetColumnIndexFromCellAddress("IV22334");

            index.ShouldBe(256);
        }