Serialize\ExcelSerializer::serializeData()

Complexity

Conditions	8
Paths	14

Size

Total Lines	43
Code Lines	27

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function serializeData($type, $array)
    {
        if($this->supportsType($type) === false)
        {
            return null;
        }
        if(count($array) === 0)
        {
            return null;
        }
        $data = $this->getArray($array);
        $ssheat = new \PHPExcel();
        $sheat = $ssheat->setActiveSheetIndex(0);
        $keys = array_shift($data);
        $rowCount = count($data);
        $colCount = count($keys);
        for($i = 0; $i < $colCount; $i++)
        {
            $sheat->setCellValueByColumnAndRow($i, 1, $keys[$i]);
        }
        for($i = 0; $i < $rowCount; $i++)
        {
            for($j = 0; $j < $colCount; $j++)
            {
                $colName = $keys[$j];

$colName is not used, you could remove the assignment.

                $sheat->setCellValueByColumnAndRow($j, 2+$i, $data[$i][$j]);
            }
        }
        if(strcasecmp($type, 'xlsx') === 0 || strcasecmp($type, 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') === 0)
        {
            $writer = \PHPExcel_IOFactory::createWriter($ssheat, 'Excel2007');
            ob_start();
            $writer->save('php://output');
            return ob_get_clean();
        }
        else
        {
            $writer = \PHPExcel_IOFactory::createWriter($ssheat, 'Excel5');
            ob_start();
            $writer->save('php://output');
            return ob_get_clean();
        }
    }
}