Spreadsheet Coding

Samples, Tips, and Tutorials

https://spreadsheet-coding.com/

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

Change A Spreadsheet Title

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

Snippets | July 24, 2022

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