Spreadsheet Coding

Samples, Tips, and Tutorials

https://spreadsheet-coding.com/

Identify File Types

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

PhpSpreadsheet | June 21, 2020

Read Excel Files In PHP Using PHPSpreadSheet

Using the generated xlsx file from the tutorial Create Xlsx Files as a sample file, learn how to rea...

PhpSpreadsheet | June 21, 2020

Create Excel Files In PHP Using PHPSpreadSheet

Create an xlsx file with a simple "Hellow Word !" example. Requirements: Composer PHP 7.2 or ne...

PhpSpreadsheet | June 21, 2020

Install PhpSpreadsheet

Read and write different spreadsheet file formats using the pure PHP library PhpSpreadsheet. Require...

PhpSpreadsheet | June 21, 2020

  • Previous
  • 1
  • …
  • 3
  • 4
  • 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