class.ilAssExcelFormatHelper.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2016 ILIAS open source, Extended GPL, see docs/LICENSE */
require_once 'Modules/Test/classes/inc.AssessmentConstants.php';
require_once 'Services/Excel/classes/class.ilExcel.php';

class ilAssExcelFormatHelper extends ilExcel
{
    const escapeString = true;

    protected $stringEscaping = self::escapeString;

    public function __construct()
    {
        parent::__construct();
    }

    public function setFormattedExcelTitle($coordinates, $value)
    {
        $this->setCellByCoordinates($coordinates, $value);
        $this->setColors($coordinates, EXCEL_BACKGROUND_COLOR);
        $this->setBold($coordinates);
    }

    public function setCellByCoordinates($a_coords, $a_value)
    {
        if (is_string($a_value) && !is_numeric($a_value)) {
            $this->workbook->getActiveSheet()->setCellValueExplicit(
                $a_coords,
                $this->prepareValue($a_value),
                \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING,
                true
            );
        } else {
            parent::setCellByCoordinates($a_coords, $a_value);
        }
    }

    public function setCell($a_row, $a_col, $a_value, $datatype=null)
    {
        if (is_string($a_value) && !is_numeric($a_value)) {
            $this->workbook->getActiveSheet()->setCellValueExplicitByColumnAndRow(
                $a_col + 1,
                $a_row,
                $this->prepareValue($a_value),
                \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING,
                true
            );
        } else {
            parent::setCell($a_row, $a_col, $a_value);
        }
    }

    protected function prepareString($a_value)
    {
        if ($this->stringEscaping == false) {
            return $a_value;
        } else {
            return strip_tags($a_value);
        }
    }

    public function getStringEscaping()
    {
        return $this->stringEscaping;
    }

    public function setStringEscaping($stringEscaping)
    {
        $this->stringEscaping = $stringEscaping;
    }
}