Spreadsheet Coding

Samples, Tips, and Tutorials

https://spreadsheet-coding.com/

Write Google Sheets Data To A Multiple Range Horizontally Using Google Sheets API PHP Client

Write data horizontally on multiple ranges on a Google Sheet Spreadsheet through Google Sheets API P...

Google Sheets API PHP Client | August 10, 2022

Write Excel Files Data Horizontally In PHP Using PHPSpreadSheet

Use PhpSpreadsheet in PHP to create and write data to excel files horizontally, starting from left t...

PhpSpreadsheet | July 28, 2022

Merge Cells

PhpSpreadsheet (Excel Files) // Merge cells from A1 to D5 $sheet->mergeCells('A1:D5'); [you_...

Snippets | July 25, 2022

Write Cell Data Horizontally

PhpSpreadsheet (Excel Files) // Set cell values for A1-D1 foreach (range('A', 'D') as $letter) {...

Snippets | July 24, 2022

Write Google Sheets Data To A Single Range Horizontally Using Google Sheets API PHP Client

Very similar with the Create A "Hello World" SpreadSheet Using Google Sheets API PHP Client tutorial...

Google Sheets API PHP Client | July 24, 2022

Change A Spreadsheet Title

PhpSpreadsheet (Excel Files) // Set the properties or metadata of the file $spreadsheet->getP...

Snippets | July 24, 2022

Change Google Spreadsheet Title Using Google Sheets API PHP Client

Rename Google Spreadsheets using the method spreadsheets.batchUpdate with request UpdateSpreadsheetP...

Google Sheets API PHP Client | July 23, 2022

Create A “Hello World” SpreadSheet Using Google Sheets API PHP Client

Another most common use of the Google Sheets API is to write SpreadSheet cell values. Since we have ...

Google Sheets API PHP Client | July 17, 2022

Create A Blank SpreadSheet Using Google Sheets API PHP Client Library

The next thing to do after all the set up and configuration, from Creating a Google Cloud Project up...

Google Sheets API PHP Client | July 13, 2022

Obtain Google API Access Token Through Command Line Using PHP

To test your Google Credential OAuth Client ID, you can quickly make a php script to see if you can ...

Google Sheets API PHP Client | July 10, 2022

Install The Google Client Library Specifying Google Sheets

We will only be needing the Online Spreadsheet Editor of Google, otherwise known as Google Sheets, f...

Google Sheets API PHP Client | July 7, 2022

Enable Google Sheets API

Once you have created your Google Cloud Project, created your Google OAuth Credential with Google OA...

Google Sheets API PHP Client | July 4, 2022

Create A Google Credential OAuth Client ID

To be able to connect your PHP Web Application to Google Cloud and access your enabled Google Sheets...

Google Sheets API PHP Client | July 3, 2022

Create A Google OAuth Consent Screen

Part of creating an "external" web application to make use of the Google Sheets, users must give con...

Google Sheets API PHP Client | July 3, 2022

Create A Google Cloud Project

To be able to code with PHP and a Google Sheet, a Google Cloud project is needed. Learn how to creat...

Google Sheets API PHP Client | July 2, 2022

Delete Columns In Xlsx Files

Update an existing xlsx file and remove a specific column dynamically using PhpSpreadsheet, this is ...

PhpSpreadsheet | July 2, 2022

Delete Rows In Xlsx Files

Remove a row, or multiple rows from an existing xlsx file by programmatically updating it using PhpS...

PhpSpreadsheet | June 30, 2022

Insert Columns In Xlsx Files

Insert additional columns in xlsx files in PhpSpreadsheet. Requirements: Composer PHP 7.2 or ne...

PhpSpreadsheet | June 27, 2022

  • 1
  • 2
  • 3
  • …
  • 5
  • Next
Top Tutorials
  • Identify File Types

    In cases the file is yet to be identified, the method IOFactory::identify() can be used to automatic

  • Create Xlsx Files With Drop Down List Data Validation

    Code to write down selections where users can pick an option from, not allowing any data not within

  • Merge Cells In Excel Files In PHP Using PHPSpreadSheet

    Using the generated file from the tutorial Create Xlsx Files With Different Cell Background Colors,

  • Create Xlsx Files With Auto Column Width Settings

    Code an xlsx file in PhpSpreadsheet to automatically adjust a column width based on the maximum numb

  • Create Excel Files With Header And Footer In PHP Using PHPSpreadSheet

    With the simple setOddHeader() and setOddFooter() functions in PhpSpreadsheet, set a detailed docume

PhpSpreadsheet Quick Start

  • How To Install PhpSpreadsheet
  • How To Create Excel Files In PHP Using PHPSpreadSheet
  • How To Identify File Types
  • How To Read Excel Files In PHP Using PHPSpreadSheet
  • How To Read Excel Files In PHP Using PHPSpreadSheet's IOFactory Class
  • How To Update Excel Files In PHP Using PHPSpreadSheet
  • How To Set Metadata Of Excel Files In PHP Using PHPSpreadSheet
  • How To Create Excel Files With Header And Footer In PHP Using PHPSpreadSheet

Google Sheets API PHP Client Quick Start

  • How To Create A Google Cloud Project
  • How To Create A Google OAuth Consent Screen
  • How To Create A Google Credential OAuth Client ID
  • How To Enable Google Sheets API
  • How To Install The Google Client Library Specifying Google Sheets
  • How To Obtain Google API Access Token Through Command Line Using PHP
  • How To Create A Blank SpreadSheet Using Google Sheets API PHP Client Library
©2022 Spreadsheet Coding