Simple solution for converting excel rows into coordinates using Google Maps API

Last update: Oct 16, 2021

Package

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.

Testing

Test can be found in /tests.

Contributing

Everyone is welcome for contribution.

Credits

Licence

GitHub

https://github.com/CirkaN/ExcelToCoordinates
You might also like...

Collection of Google Maps API Web Services for Laravel

Collection of Google Maps API Web Services for Laravel Provides convenient way of setting up and making requests to Maps API from Laravel application.

Aug 2, 2022

Http-kernel - The HttpKernel component provides a structured process for converting a Request into a Response.

HttpKernel Component The HttpKernel component provides a structured process for converting a Request into a Response by making use of the EventDispatc

Aug 13, 2022

Laravel Google Maps Package

Laravel Google Maps This repo aims to use google map features in laravel 5.x. It is easy to use and flexible, you can just install this package and en

Aug 15, 2022

An easy way to integrate Google Maps with Laravel

An easy way to integrate Google Maps with Laravel For Laravel 5.x, check version 2.35.1 For Laravel 4.x, check version 1.27.0 Think of Googlmapper as

Aug 11, 2022

Google Maps Plugin for Typemill CMS.

Google Maps Plugin for Typemill CMS.

Google Maps Plugin This plugin is developed for Typemill, a flat-file cms. How to install Download this plugin (zip). Unzip the plugin. Upload the plu

Jun 1, 2022

Use: [i] to share item and name in hand, [coor] to share you current coordinates

General Now you can share your Coordinates and Item with Prefix Example if you type [i] in message, later it will be automatically replaced into the n

Oct 15, 2021

Main component controls and coordinates saga participants

Main component controls and coordinates saga participants

Saga Orchestrator Table Of Contents Introduction Requirements About package Installation Getting started Configuration Saga creation Internal License

Jul 30, 2022

laravel package help you to implement geographical calculation, with several algorithms that help you deal with coordinates and distances.

laravel package help you to implement geographical calculation, with several algorithms that help you deal with coordinates and distances.

Geographical Calculator Geographical Calculator was developed for laravel 5.8+ to help you to implement geographical calculation, with With several al

Jul 24, 2022

List of France cities with zip codes, department codes, region codes, districts for former cities, GPS latitude longitude coordinates, and INSEE reference code.

List of France cities with zip codes, department codes, region codes, districts for former cities, GPS latitude longitude coordinates, and INSEE reference code.

May 25, 2022

EasyQuickImport — Import transactions, invoices and bills into QuickBooks Desktop from Excel or CSV

EasyQuickImport — Import transactions, invoices and bills into QuickBooks Desktop from Excel or CSV

EasyQuickImport is a tool that helps you import invoices, bills, transactions, customers and vendors into QuickBooks Desktop in multiple currencies in bulk.

Jul 1, 2022

New WordPress plugin to render a map with multiple markers using the open source maps provider OpenStreetMap

markers-on-openstreetmap New WordPress plugin to render a map with multiple markers using the open source maps provider OpenStreetMap A friend of mine

Oct 25, 2021

A weather data tile generator for digital maps using the Web Mercator projection

A weather data tile generator for digital maps using the Web Mercator projection

Weather data tile generator for Web Mercator maps This is a weather data tile generator for digital maps, which is compatible with Leaflet and in gene

Oct 31, 2021

An article about alternative solution for convert object into a JSON Object for your api.

Do we really need a serializer for our JSON API? The last years I did build a lot of JSON APIs but personally was never happy about the magic of using

Feb 1, 2022

Simple user-authentication solution, embedded into a small framework.

Simple user-authentication solution, embedded into a small framework.

HUGE Just a simple user authentication solution inside a super-simple framework skeleton that works out-of-the-box (and comes with an auto-installer),

Aug 10, 2022

YesWiki is a wiki system written in PHP, including extensions making collaboration more simple (databases, maps, easy editing, bootstrap themes,...).

YesWiki YesWiki is a Free Software under the AGPL licence, made for creating and managing your website, in a collaborative way. YesWiki allows any web

Aug 10, 2022

Library for converting units and sizes in PHP

php-conversion Library for converting units and sizes in PHP. Units supported Acceleration Angle Area Digital information Electric current Frequency F

Feb 20, 2022

ColorJizz is a PHP library for manipulating and converting colors.

#Getting started: ColorJizz-PHP uses the PSR-0 standards for namespaces, so there should be no trouble using with frameworks like Symfony 2. ###Autolo

Jun 28, 2022

Library for converting units and sizes in PHP

php-conversion Library for converting units and sizes in PHP. Units supported Acceleration Angle Area Digital information Electric current Frequency F

Mar 16, 2021

PocketMine-MP Plugin for converting items & blocks name to your language.

PocketMine-MP Plugin for converting items & blocks name to your language.

ConvertName PocketMine-MP Plugin for converting items & blocks name to your language. Usage Due to license issue, I don't put the language files direc

Aug 6, 2022
New WordPress plugin to render a map with multiple markers using the open source maps provider OpenStreetMap

markers-on-openstreetmap New WordPress plugin to render a map with multiple markers using the open source maps provider OpenStreetMap A friend of mine

Oct 25, 2021
A weather data tile generator for digital maps using the Web Mercator projection
A weather data tile generator for digital maps using the Web Mercator projection

Weather data tile generator for Web Mercator maps This is a weather data tile generator for digital maps, which is compatible with Leaflet and in gene

Oct 31, 2021
Generate and display maps without external services or compromising on privacy.
Generate and display maps without external services or compromising on privacy.

Generate and display maps without external services or compromising on privacy.

Jun 24, 2022
A Laravel package to get the user's country using the ip.

Laravel IP Service Tries to guess the country code of the client, using his IP. Installation Download and import the ip database from ip2nation.com Us

Apr 12, 2022
PHP library to access the OpenCage geocoding API
PHP library to access the OpenCage geocoding API

OpenCage Geocoding API Library for PHP A PHP library to use the OpenCage geocoding API. Build Status / Code Quality Overview This library attempts to

Jun 20, 2022
Simple Yet Powerful Geo Library for PHP

phpgeo - A Simple Geo Library for PHP phpgeo provides abstractions to geographical coordinates (including support for different ellipsoids) and allows

Jul 29, 2022
A simple wrapper for (reverse) geocoding

Geocode - A simple wrapper for (reverse) geocoding Installation composer require markuskooche/geocode Usage How to geocode use Illuminate\Support\Col

Jul 9, 2022
Merge Excel Files to single excel file per columns

Merge Excel Files to single excel file per columns

Apr 26, 2021
Parse and retrieve data from old format Excel XLS files. MS Excel 97 workbooks PHP reader.

SimpleXLS class 0.9.15 Parse and retrieve data from old Excel .XLS files. MS Excel 97-2003 workbooks PHP reader. PHP BIFF reader. No additional extens

Jul 15, 2022