PHPOffice / PhpSpreadsheet

        return require 'data/ColumnString.php';

    }

    public function testColumnIndexFromStringTooLong()

    {

        $cellAddress = 'ABCD';

        try {

            $result = call_user_func([Cell::class, 'columnIndexFromString'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Column string index can not be longer than 3 characters');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    public function testColumnIndexFromStringTooShort()

        $this->fail('An expected exception has not been raised.');

    }

    public function testColumnIndexFromStringTooShort()

    {

        $cellAddress = '';

        try {

            $result = call_user_func([Cell::class, 'columnIndexFromString'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Column string index can not be empty');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    /**

        return require 'data/CellCoordinates.php';

    }

    public function testCoordinateFromStringWithRangeAddress()

    {

        $cellAddress = 'A1:AI2012';

        try {

            $result = call_user_func([Cell::class, 'coordinateFromString'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    public function testCoordinateFromStringWithEmptyAddress()

        $this->fail('An expected exception has not been raised.');

    }

    public function testCoordinateFromStringWithEmptyAddress()

    {

        $cellAddress = '';

        try {

            $result = call_user_func([Cell::class, 'coordinateFromString'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Cell coordinate can not be zero-length string');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    public function testCoordinateFromStringWithInvalidAddress()

        $this->fail('An expected exception has not been raised.');

    }

    public function testCoordinateFromStringWithInvalidAddress()

    {

        $cellAddress = 'AI';

        try {

            $result = call_user_func([Cell::class, 'coordinateFromString'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Invalid cell coordinate ' . $cellAddress);

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    /**

        return require 'data/CellAbsoluteCoordinate.php';

    }

    public function testAbsoluteCoordinateFromStringWithRangeAddress()

    {

        $cellAddress = 'A1:AI2012';

        try {

            $result = call_user_func([Cell::class, 'absoluteCoordinate'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    /**

        return require 'data/CellAbsoluteReference.php';

    }

    public function testAbsoluteReferenceFromStringWithRangeAddress()

    {

        $cellAddress = 'A1:AI2012';

        try {

            $result = call_user_func([Cell::class, 'absoluteReference'], $cellAddress);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    /**

        return require 'data/CellBuildRange.php';

    }

    public function testBuildRangeInvalid()

    {

        $cellRange = '';

        try {

            $result = call_user_func([Cell::class, 'buildRange'], $cellRange);

        } catch (\Exception $e) {

            $this->assertInstanceOf(Exception::class, $e);

            $this->assertEquals($e->getMessage(), 'Range does not contain any information');

            return;

        }

        $this->fail('An expected exception has not been raised.');

    }

    /**