PHPackages alepane21/php-google-spreadsheet-client - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [PDF & Document Generation](/categories/documents) 4. / 5. alepane21/php-google-spreadsheet-client ActiveLibrary[PDF & Document Generation](/categories/documents) alepane21/php-google-spreadsheet-client ======================================= Google Spreadsheet PHP Client (forked to work on PHP 5.2.1+) 2.2.8(11y ago)016.2k↓66.7%Apache-2.0PHPPHP >=5.2.1 Since Jul 28Pushed 11y ago1 watchersCompare [ Source](https://github.com/alepane21/php-google-spreadsheet-client)[ Packagist](https://packagist.org/packages/alepane21/php-google-spreadsheet-client)[ Docs](https://github.com/alepane21/php-google-spreadsheet-client)[ RSS](/packages/alepane21-php-google-spreadsheet-client/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependenciesVersions (23)Used By (0) Introduction ============ [](#introduction) This library provides a simple interface to the Google Spreadsheet API. It's a fork of changed to be compatible with PHP 5.2.1+. There are a couple of important things to note. - This library requires a valid OAuth access token to work but does not provide any means of generating one. The [Google APIs Client Library for PHP](https://code.google.com/p/google-api-php-client/) has all the functionality required for for generating and refreshing tokens so it would have been a waste of time duplicating the official google library. - You can not create spreadsheets using this (PHP Google Spreadsheet Client) library, as creating spreadsheets is not part of the Spreadsheet API and the functionality already exists in the official Google Client Library. I strongly recommend you read through the [official Google Spreadsheet API documentation](https://developers.google.com/google-apps/spreadsheets) to get a grasp of the concepts. Usage ===== [](#usage) Installation ------------ [](#installation) Using [composer](https://getcomposer.org/) is the recommended way to install it. 1 - Add "alepane21/php-google-spreadsheet-client" as a dependency in your project's composer.json file. ``` { "require": { "alepane21/php-google-spreadsheet-client": "2.2.*" } } ``` 2 - Download and install Composer. ``` curl -sS https://getcomposer.org/installer | php ``` 3 - Install your dependencies. ``` php composer.phar install ``` 4 - Require Composer's autoloader. ``` require 'vendor/autoload.php'; ``` Bootstrapping ------------- [](#bootstrapping) The first thing you will need to do is initialize the service request factory: ``` $serviceRequest = new Google_Spreadsheet_DefaultServiceRequest($accessToken); Google_Spreadsheet_ServiceRequestFactory::setInstance($serviceRequest); ``` Retrieving a list of spreadsheets --------------------------------- [](#retrieving-a-list-of-spreadsheets) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); ``` SpreadsheetFeed implements ArrayIterator so you can iterate over it using a foreach loop or you can retrieve a single spreadsheet by name. ``` $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); ``` Retrieving a list of worksheets ------------------------------- [](#retrieving-a-list-of-worksheets) You can retrieve a list of worksheets from a spreadsheet by calling the getWorksheets() method. ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); ``` You can loop over each worksheet or get a single worksheet by title. ``` $worksheet = $worksheetFeed->getByTitle('Sheet 1'); ``` Adding a worksheet ------------------ [](#adding-a-worksheet) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $spreadsheet->addWorksheet('New Worksheet', 50, 20); ``` The only required parameter is the worksheet name, The row and column count are optional. The default value for rows is 100 and columns is 10. Deleting a worksheet -------------------- [](#deleting-a-worksheet) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); $worksheet = $worksheetFeed->getByTitle('New Worksheet'); $worksheet->delete(); ``` Working with list-based feeds ----------------------------- [](#working-with-list-based-feeds) ### Retrieving a list-based feed [](#retrieving-a-list-based-feed) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); $worksheet = $worksheetFeed->getByTitle('Sheet 1'); $listFeed = $worksheet->getListFeed(); ``` Once you have a list feed you can loop over each entry. ``` foreach ($listFeed->getEntries() as $entry) { $values = $entry->getValues(); } ``` The getValues() method returns an associative array where the keys are the column names and the values are the cell content. ### Adding a list row [](#adding-a-list-row) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); $worksheet = $worksheetFeed->getByTitle('Sheet 1'); $listFeed = $worksheet->getListFeed(); $row = array('name'=>'John', 'age'=>25); $listFeed->insert($row); ``` ### Updating a list row [](#updating-a-list-row) ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); $worksheet = $worksheetFeed->getByTitle('Sheet 1'); $listFeed = $worksheet->getListFeed(); $entries = $listFeed->getEntries(); $listEntry = $entries[0]; $values = $listEntry->getValues(); $values['name'] = 'Joe'; $listEntry->update($values); ``` ### Adding headers to a new worksheet [](#adding-headers-to-a-new-worksheet) The Google Spreadsheet API does not allow you to update a list row if headers are not already assigned. So, when you create a new worksheet, before you can add data to a worksheet using the 'Adding/Updating a list row' methods above, you need to add headers. To add headers to a worksheet, use the following: ``` $spreadsheetService = new Google_Spreadsheet_SpreadsheetService(); $spreadsheetFeed = $spreadsheetService->getSpreadsheets(); $spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet'); $worksheetFeed = $spreadsheet->getWorksheets(); $worksheet = $worksheetFeed->getByTitle('Sheet 1'); $cellFeed = $worksheet->getCellFeed(); $cellFeed->editCell(1,1, "Row1Col1Header"); $cellFeed->editCell(1,2, "Row1Col2Header"); $cellFeed->editCell(1,3, "Row1Col3Header"); $cellFeed->editCell(1,4, "Row1Col4Header"); ``` ### Health Score 34 — LowBetter than 77% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity22 Limited adoption so far Community12 Small or concentrated contributor base Maturity68 Established project with proven stability Bus Factor1 Top contributor holds 73.5% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~25 days Recently: every ~0 days Total 19 Last Release 4221d ago Major Versions 1.0 → 2.0.02014-02-22 PHP version history (2 changes)2.0.0PHP >=5.3.0 2.2.1PHP >=5.2.1 ### Community Maintainers ![](https://www.gravatar.com/avatar/404d33ea54b11be32e18ac39ad89ac7a08d3dfc794e2b90f1d51107e613daad4?d=identicon)[alepane21](/maintainers/alepane21) --- Top Contributors [![asimlqt](https://avatars.githubusercontent.com/u/1963846?v=4)](https://github.com/asimlqt "asimlqt (36 commits)")[![alepane21](https://avatars.githubusercontent.com/u/12182?v=4)](https://github.com/alepane21 "alepane21 (9 commits)")[![miku](https://avatars.githubusercontent.com/u/53705?v=4)](https://github.com/miku "miku (2 commits)")[![SgtPooki](https://avatars.githubusercontent.com/u/1173416?v=4)](https://github.com/SgtPooki "SgtPooki (1 commits)")[![UFOMelkor](https://avatars.githubusercontent.com/u/571106?v=4)](https://github.com/UFOMelkor "UFOMelkor (1 commits)") --- Tags googlespreadsheet ### Embed Badge ![Health badge](/badges/alepane21-php-google-spreadsheet-client/health.svg) ``` [![Health](https://phpackages.com/badges/alepane21-php-google-spreadsheet-client/health.svg)](https://phpackages.com/packages/alepane21-php-google-spreadsheet-client) ``` ### Alternatives [phpoffice/phpspreadsheet PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine 13.9k293.5M1.3k](/packages/phpoffice-phpspreadsheet)[openspout/openspout PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way 1.2k57.6M131](/packages/openspout-openspout)[asimlqt/php-google-spreadsheet-client Google Spreadsheet PHP Client 5492.7M7](/packages/asimlqt-php-google-spreadsheet-client)[nuovo/spreadsheet-reader Spreadsheet reader library for Excel, OpenOffice and structured text files 669863.2k8](/packages/nuovo-spreadsheet-reader)[avadim/fast-excel-writer Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP 2951.2M7](/packages/avadim-fast-excel-writer)[kartik-v/yii2-export A library to export server/db data in various formats (e.g. excel, html, pdf, csv etc.) 1623.1M35](/packages/kartik-v-yii2-export) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)