Darkilliant\ImportBundle\Extractor\ExcelSplitter

Complexity

Total Complexity

3

Size/Duplication

Total Lines	42
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	split()	0	24	2

<?php

namespace Darkilliant\ImportBundle\Extractor;

use Cocur\Slugify\Slugify;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Csv as CsvWriter;

class ExcelSplitter
{
    /** @var Slugify */
    private $slugify;

    public function __construct(Slugify $slugify)
    {
        $this->slugify = $slugify;
    }

    /**
     * @param $filePath
     *
     * @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     *
     * @return array
     */
    public function split($filePath): array
    {
        $files = [];

        $xlsFilePath = realpath($filePath);
        $xlsWorkSheet = IOFactory::load($filePath);
        /** @var CsvWriter $csvWriter */
        $csvWriter = IOFactory::createWriter($xlsWorkSheet, 'Csv');
        foreach ($xlsWorkSheet->getWorksheetIterator() as $sheetIndex => $workSheetTab) {
            $csvWriter->setSheetIndex($sheetIndex);

            $sheetName = strtolower($this->slugify->slugify($workSheetTab->getTitle()));
            $filePath = sprintf(
                '%s_%s.csv',
                pathinfo($xlsFilePath, PATHINFO_DIRNAME).'/'.pathinfo($xlsFilePath, PATHINFO_FILENAME),
                $sheetName
            );

            $csvWriter->save($filePath);

            $files[] = ['sheet_name' => $sheetName, 'filepath' => $filePath];
        }

        return $files;
    }
}