C# (CSharp) ColumnPropertyData.GetColumnIndexFromCellAddress Beispiele

Beispiel #1

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

            index.ShouldBe(1);
        }

Beispiel #2

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

            index.ShouldBe(16385);
        }

Beispiel #3

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

            index.ShouldBe(419);
        }

Beispiel #4

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

            index.ShouldBe(16384);
        }

Beispiel #5

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

            index.ShouldBe(256);
        }