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

Overview

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

You might also like...
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

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.

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

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

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

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

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.

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

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

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

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.

IP2Location Yii extension enables the user to find the country, region, city, coordinates, zip code, time zone, ISP

IP2Location Yii extension enables the user to find the country, region, city, coordinates, zip code, time zone, ISP, domain name, connection type, area code, weather, MCC, MNC, mobile brand name, elevation, usage type, IP address type and IAB advertising category from IP address using IP2Location database. It has been optimized for speed and memory utilization. Developers can use the API to query all IP2Location BIN databases or web service for applications written using Yii.

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

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),

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

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

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

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

Owner
Nikola Cirkovic
Web Developer
Nikola Cirkovic
IP2Location Yii extension enables the user to find the country, region, city, coordinates, zip code, time zone, ISP

IP2Location Yii extension enables the user to find the country, region, city, coordinates, zip code, time zone, ISP, domain name, connection type, area code, weather, MCC, MNC, mobile brand name, elevation, usage type, IP address type and IAB advertising category from IP address using IP2Location database. It has been optimized for speed and memory utilization. Developers can use the API to query all IP2Location BIN databases or web service for applications written using Yii.

IP2Location 7 May 21, 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

Oscar Alderete 2 Oct 25, 2021
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

null 2 Aug 11, 2022
Generate and display maps without external services or compromising on privacy.

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

null 144 Dec 29, 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

Dimitris Savvopoulos 119 Nov 29, 2022
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

OpenCage GmbH 29 Nov 15, 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

Marcus Jaschen 1.4k Dec 27, 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

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

Merge Excel Files to single excel file per columns

Max Base 3 Apr 26, 2021