How to Install PHPOffice on NixOS

PHPOffice is a collection of libraries used to manipulate various document formats including Excel, Word, and PowerPoint. These libraries are built specifically for PHP-based web applications.

Here is a step-by-step guide to installing PHPOffice on NixOS Latest:

1. Update Your System

Open a terminal window and run the following command to update your system:

sudo nixos-rebuild switch

This will ensure that your system is up-to-date and that all necessary dependencies are installed.

2. Install Composer

Composer is a dependency management tool used for PHP projects. PHPOffice requires Composer to be installed on your system. Run the following command:

sudo curl -sS https://getcomposer.org/installer | php -- --install-dir=/usr/bin --filename=composer

This will download and install Composer on your system.

3. Download PHPOffice from Github

Use the following command to clone PHPOffice from Github:

git clone https://github.com/PHPOffice/PhpSpreadsheet.git

This will download the latest version of PHPOffice to your system.

4. Install PHPOffice Dependencies

PHPOffice requires several dependencies to be installed on your system. Use the following command to install these dependencies:

sudo apt-get install php-zip php-xml libapache2-mod-php

5. Install PHPOffice via Composer

Navigate to the directory where you cloned PHPOffice and use the following command to install PHPOffice via Composer:

cd PhpSpreadsheet
sudo composer install

This will install all necessary dependencies for PHPOffice.

6. Test Your Installation

Use the following command to test your installation:

cd /var/www/html
sudo nano index.php

Add the following code to the index.php file:

<?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 !');
$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');
?>

Save the file and exit. Now run the following command:

sudo php -S localhost:8000

Open a web browser and navigate to http://localhost:8000/. You should see a file called hello world.xlsx downloaded to your computer. This means PHPOffice has been successfully installed on your system.

Congratulations! You have successfully installed PHPOffice on NixOS.