Spreadsheet Coding

Samples, Tips, and Tutorials

https://spreadsheet-coding.com/

Sample Page

This is an example page. It's different from a blog post because it will stay in one place and will...

| June 20, 2020

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