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),
                                PHPExcel_Cell_DataType::TYPE_STRING,
                                true
                        );
                }
                else
                {
                        parent::setCellByCoordinates($a_coords, $a_value);
                }
        }

        public function setCell($a_row, $a_col, $a_value)
        {
                if(is_string($a_value) && !is_numeric($a_value))
                {
                        $this->workbook->getActiveSheet()->setCellValueExplicitByColumnAndRow(
                                $a_col,
                                $a_row,
                                $this->prepareValue($a_value),
                                PHPExcel_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;
        }
}