Unmerge Cells In Excel Files In PHP Using PHPSpreadSheet

After the tutorial Merge Cells In Xlsx Files in PhpSpreadsheet, unmerging cells in xlsx files in PhpSpreadsheet is the next example to read. The file from Merge Cells In Xlsx Files will be used as a sample to unmerged the cells in an xlsx file.

Requirements:

Composer
PHP 7.2 or newer

Before Cell Unmerging

Step 1.

Setup dependencies.

{
    "require": {
        "phpoffice/phpspreadsheet": "^1.3"
    }
}

composer.json

Step 2.

Install phpspreadsheet.

$ composer install

command line

Step 3.

Create a new PHP file, and start coding.

<?php

// Autoload dependencies
require 'vendor/autoload.php';

// Import the IOFactory class
use \PhpOffice\PhpSpreadsheet\IOFactory;

// Import the Xlsx writer class
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// Full path of the file to be indentified
$inputFileName = 'merge-cells-in-xlsx-files.xlsx';

// Identify the file type using the IOFactory object
$inputFileType = IOFactory::identify($inputFileName);

// Create the reader object
$reader = IOFactory::createReader($inputFileType);

// Load the file to read
$spreadsheet = $reader->load($inputFileName);

// Retrieve the current active worksheet
$sheet = $spreadsheet->getActiveSheet();

// Unmerge cells from A1 to D5
$sheet->unmergeCells('A1:D5');

// Write a new .xlsx file
$writer = new Xlsx($spreadsheet);

// Save the new .xlsx file
$writer->save('unmerge-cells-in-xlsx-files.xlsx');

unmerge-cells-in-xlsx-files.php

Test.

Run the following codes.

$ php unmerge-cells-in-xlsx-files.php

command line

Result.

Open the generated file unmerge-cells-in-xlsx-files.xlsx.