Excel::getActiveSheet() - Code Metrics - jacques/php-reports - Measure and Improve Code Quality continuously with Scrutinizer

Excel::getActiveSheet() A
last analyzed 2019-02-21 14:07 UTC

↳ Parent: Excel

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	1
nc	1
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php
/**
 * @author    Jacques Marneweck <[email protected]>
 * @copyright 2018-2019 Jacques Marneweck.  All rights strictly reserved.
 */

namespace Jacques\Reports;

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

class Excel
{
    /**
     * @var \PhpOffice\PhpSpreadsheet\Spreadsheet|null
     */
    private $spreadsheet = null;

    /**
     * @var \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet|null
     */
    private $sheet = null;

    /**
     * Active sheet we are working on.
     */
    private $activesheet = 0;

    /**
     * Creates a new spreadsheet.
     *
     * @param string $title Title for the Worksheet
     */
    public function __construct($title)
    {
        $this->spreadsheet = new Spreadsheet();
        $this->sheet = $this->spreadsheet->getActiveSheet();

        $this->sheet->setShowGridlines(true);
        $this->sheet->setTitle($title);
    }

    /**
     * Creates a new sheet and makes the new sheet the active sheet.
     *
     * @param string $title Title for the Worksheet
     */
    public function createsheet($title)
    {
        $this->activesheet++;

        $this->spreadsheet->createsheet();
                            createsheet();
        $this->spreadsheet->setActiveSheetIndex($this->activesheet);
        $this->sheet = $this->spreadsheet->getActiveSheet();

        $this->sheet->setShowGridlines(true);
        $this->sheet->setTitle($title);
    }

    /**
     * Retreive the active sheet.
     */
    public function getActiveSheet()
    {
        return $this->spreadsheet->getActiveSheet();
    }

    /**
     * Get properties for the spreadsheet.
     */
    public function getProperties()
    {
        return $this->spreadsheet->getProperties();
    }

    /**
     * Set the active sheet index by the name of the sheet.
     *
     * @param string $name
     */
    public function setActiveSheetIndexByName($name)
    {
        $this->spreadsheet->setActiveSheetIndexByName($name);
        $this->sheet = $this->spreadsheet->getActiveSheet();
    }

    /**
     * Apply header styles over multiple rows making up the header.
     *
     * @param string $cells Columns for the first row (i.e. A1:Z1).
     */
    public function applyHeaderStyleSingleRow($cells)
    {
        $styleArray = [
            'font' => [
                'bold' => true,
            ],
            'borders' => [
                'top' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
                ],
                'bottom' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
                ],
            ],
        ];

        $this->sheet->getStyle($cells)->applyFromArray($styleArray);
                      getStyle($cells)->applyFromArray($styleArray);
    }

    /**
     * Apply header styles over multiple rows making up the header.
     *
     * @param string $firstRowCells Columns for the first row (i.e. A1:Z1).
     * @param string $lastRowCells  Columns for the last row of the header (i.e. A2:Z2).
     */
    public function applyHeaderStylesMultipleRows($firstRowCells, $lastRowCells)
    {
        $styleArray = [
            'font' => [
                'bold' => true,
            ],
            'borders' => [
                'top' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK,
                ],
            ],
        ];
        $this->sheet->getStyle($firstRowCells)->applyFromArray($styleArray);

        $styleArray = [
            'font' => [
                'bold' => true,
            ],
            'borders' => [
                'bottom' => [
                    'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
                ],
            ],
        ];
        $this->sheet->getStyle($lastRowCells)->applyFromArray($styleArray);
    }

    /**
     * Set the auto size property on a column for the column width.
     *
     * @param string $firstCell First column (i.e. A)
     * @param string $lastcell  Last column (i.e. Z)
     */
    public function applyAutoSize($firstCell, $lastCell)
    {
        $col = $firstCell;
        $lastCell++;

        while ($col != $lastCell) {
            $this->sheet->getColumnDimension($col)->setAutoSize(true);
            $col++;
        }
    }

    /**
     * Save the spreadsheet.
     *
     * @param string $filename
     */
    public function save($filename)
    {
        $writer = IOFactory::createWriter($this->spreadsheet, 'Xlsx');
        $writer = IOFactory::createWriter(/** @scrutinizer ignore-type */ $this->spreadsheet, 'Xlsx');
        $writer->save($filename);
    }

    public function __call($name, $args)
    {
        return (call_user_func_array(array($this->sheet, $name), $args));
    }
}


jacques / php-reports

Excel::getActiveSheet() A last analyzed 2019-02-21 14:07 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Excel::getActiveSheet() A
last analyzed 2019-02-21 14:07 UTC