PhpSpreadsheet v2.1 — Quick Start

This repository includes a Composer project set to use phpoffice/phpspreadsheet:^2.1. It provides the core library under vendor/ and a minimal setup to start generating Excel files in PHP.

• PHP 8.0+ recommended

Use this repository directly without Composer:

• Clone:

  git clone https://github.com/ramyibrahim-eg/phpspreadsheet-v2.1.git
  cd phpspreadsheet-v2.1
  

• Or download the ZIP from GitHub and extract it.

• The vendor/ directory is included. Simply include the autoloader in your script:

  require __DIR__ . '/vendor/autoload.php';
  

Create a file like export.php and run it with PHP:

<?php
require __DIR__ . '/vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World!');
$sheet->setCellValue('B1', date('Y-m-d'));

$writer = new Xlsx($spreadsheet);
$writer->save(__DIR__ . '/hello_world.xlsx');

echo "File saved: hello_world.xlsx\n";

Run:

php export.php

use PhpOffice\PhpSpreadsheet\IOFactory;
$spreadsheet = IOFactory::load('hello_world.xlsx');
$sheet = $spreadsheet->getActiveSheet();
$val = $sheet->getCell('A1')->getValue();

• This repository may include vendor/ for convenience. For production projects, consider excluding vendor/ and relying on Composer to install dependencies.
• Consult the official documentation for advanced usage: https://phpspreadsheet.readthedocs.io/