Example #1
0
        public string TestGetColumnsFromAddress(string address)
        {
            //
            var utility = new ExcelAddressUtility();

            //
            var result = utility.GetColumnsFromAddress(address);

            //
            return(String.Join(",", result));
        }
Example #2
0
        public void TestGetColumnLettersForFailure(int badColumnNumber)
        {
            //
            var utility = new ExcelAddressUtility();

            //
            TestDelegate testDelegate = () => utility.GetColumnLetters(badColumnNumber);

            //
            Assert.Throws <ArgumentException>(testDelegate);
        }
Example #3
0
        public void TestGetColumnNumberForFailure(string badRowLetters)
        {
            //
            var utility = new ExcelAddressUtility();

            //
            TestDelegate testDelegate = () => utility.GetColumnNumber(badRowLetters);

            //
            Assert.Throws <ArgumentException>(testDelegate);
        }
Example #4
0
        public string TestGetColumnLetters(int columnNumber)
        {
            //
            var utility = new ExcelAddressUtility();

            //
            var result = utility.GetColumnLetters(columnNumber);

            //
            return(result);
        }
Example #5
0
        public int TestGetColumnNumber(string rowLetters)
        {
            //
            var utility = new ExcelAddressUtility();

            //
            var result = utility.GetColumnNumber(rowLetters);

            //
            return(result);
        }