OneSheet\Writer

Complexity

Total Complexity

12

Size/Duplication

Total Lines	120
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

75.68%

Importance

Changes	12
Bugs	5	Features	5

9 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	setfreezePaneCellId()	0	4	1
A	setFixedColumnWidths()	0	4	1
A	enableCellAutosizing()	0	5	1
A	disableCellAutosizing()	0	5	1
A	initialize()	0	7	1
A	addRows()	0	10	3
A	addRow()	0	6	2
A	writeToFile()	0	5	1

<?php

namespace OneSheet;

use OneSheet\Style\Style;
use OneSheet\Style\Styler;

/**
 * Class Writer
 *
 * @package OneSheet
 */
class Writer
{
    /**
     * @var SheetFile
     */
    private $sheetFile;

    /**
     * @var Styler
     */
    private $styler;

    /**
     * @var Sheet
     */
    private $sheet;

    /**
     * Writer constructor.
     */
    public function __construct()
    {
        $this->initialize();
    }

    /**
     * All cells _above_ this cell will be fozen/fixed.
     *
     * @param int $cellId
     */
    public function setfreezePaneCellId($cellId)
    {
        $this->sheet->setFreezePaneId($cellId);
    }

    /**
     * Set fixed column widths per cell (no ranges) and array index
     * 0 beeing the first column.
     * If used alongside cell autosizing, these should be set
     * after the last row has been added.
     *
     * @param array $columnWidths
     * @throws \InvalidArgumentException
     */
    public function setFixedColumnWidths(array $columnWidths)
    {
        $this->sheet->setFixedColumnWidths($columnWidths);
    }

    /**
     * Start recording row specs for column autosizing.
     *
     *  @return Writer
     */
    public function enableCellAutosizing()
    {
        $this->sheet->enableCellAutosizing();
        return $this;
    }

    /**
     * Stop recording row specs for column autosizing.
     *
     *  @return Writer
     */
    public function disableCellAutosizing()
    {
        $this->sheet->disableCellAutosizing();
        return $this;
    }

    /**
     * Initialize writer defaults.
     */
    private function initialize()
    {
        $this->sheetFile = new SheetFile();
        $this->sheetFile->fwrite(str_repeat(' ', pow(2, 20)) . '<sheetData>');
        $this->styler = new Styler();
        $this->sheet = new Sheet();
    }

    /**
     * @param array $rows
     * @param Style $style
     * @throws \InvalidArgumentException
     */
    public function addRows(array $rows, Style $style = null)
    {
        if (count($rows) === count($rows, COUNT_RECURSIVE)) {
            throw new \InvalidArgumentException('Array must contain arrays!');
        }

        foreach ($rows as $row) {
            $this->addRow($row, $style);
        }
    }

    /**
     * @param array $row
     * @param Style $style
     */
    public function addRow(array $row, Style $style = null)
    {
        $style = $style instanceof Style ? $style : $this->styler->getDefaultStyle();
        $this->styler->addStyle($style);
        $this->sheetFile->fwrite($this->sheet->addRow($row, $style));
    }

    /**
     * Wrap things up and write/output xlsx.
     *
     * @param string $fileName
     */
    public function writeToFile($fileName = 'dummy.xlsx')
    {
        $finalizer = new Finalizer($this->sheet, $this->styler, $this->sheetFile);
        $finalizer->finalize($fileName);
    }
}