Darkilliant\ImportBundle\Extractor\ExcelSplitter::split()

Complexity

Conditions	2
Paths	2

Size

Total Lines	24
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	2

Importance

Changes

0

<?php
    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;
    }