cirkovic/excel-to-coordinates

Package for converting address to the geo location coordinates based on address provided in excel file

dev-master 2021-10-16 17:48 UTC

Requires

• php: ^7.4
• ext-json: *
• guzzlehttp/guzzle: ^7.0
• phpoffice/phpspreadsheet: ^1.18

Requires (Dev)

• friendsofphp/php-cs-fixer: ^2.17
• phpunit/phpunit: ^9.5
• symfony/var-dumper: ^5.3
• vimeo/psalm: ^4

MIT

• Nikola Cirkovic

README

Usage

Start by creating a new instance of ExcelToCoorindates class:

$excel_to_cordinates = new ExcelToCoordinates();

Methods

        ->setExcelPath(__DIR__ . "/../example/addresses.xlsx") // (required)  path to the excel file
        ->setAddressIterator('A') // (required) The address iterator, for better understanding please check the example excel file provided in /example
        ->setPostCodeIterator('B') // (required) The Post Code Iterator 
        ->setCountryIterator('C') // (required) The country Iterator
        ->setGoogleApiCode('') // (required) Google API Key
        ->setStartRow(1) // (required) row from where you want to start 
        ->setEndRow(2) // (required) row where converting will stop
        ->loadData() // (required) main function which will return array of geo coordinates

Installation

`composer require cirkovic/excel-to-coordinates`

Requirements

* php 7.4
* ext-json

Support

Atleast for now package only supports XLSX file, for other formats please open issue or create PR with tests.

CSV Coming soon.

Testing

Test can be found in /tests.

Contributing

Everyone is welcome for contribution.

Credits

• Cirkovic Nikola
• All Contributors

Licence

For terms please see the LICENSE*.TXT files at the root of this distribution.