class.ilExcelXLSAdapter.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2012 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once "./Services/Excel/classes/class.ilExcelAdapter.php";

class ilExcelXLSAdapter extends ilExcelAdapter
{
        var $adapter;
        var $workbook;
        var $excelfile;
        var $activesheet;
        var $format_bold;
        var $format_percent;
        var $format_datetime;
        var $format_minutes;
        var $format_title;
        var $format_center;
        
        function __construct()
        {
                $worksheets = array();
                
                $this->excelfile = ilUtil::ilTempnam();
                include_once "./Services/Excel/classes/class.ilExcelWriterAdapter.php";
                $this->adapter = new ilExcelWriterAdapter($this->excelfile, FALSE);
                $this->workbook = $this->adapter->getWorkbook();
                $this->workbook->setVersion(8); // Use Excel97/2000 Format

                $this->format_bold =& $this->workbook->addFormat();
                $this->format_bold->setBold();
                $this->format_center =& $this->workbook->addFormat();
                $this->format_center->setColor('black');
                $this->format_center->setAlign('center');
                $this->format_percent =& $this->workbook->addFormat();
                $this->format_percent->setNumFormat("0.00%");
                $this->format_datetime =& $this->workbook->addFormat();
                $this->format_datetime->setNumFormat("DD/MM/YYYY hh:mm:ss");
                $this->format_minutes =& $this->workbook->addFormat();
                $this->format_minutes->setNumFormat("mm:ss");
                $this->format_title =& $this->workbook->addFormat();
                $this->format_title->setBold();
                $this->format_title->setColor('black');
                $this->format_title->setPattern(1);
                $this->format_title->setFgColor('silver');
                
                $this->addWorksheet('table 1');
        }

        public function save()
        {
                $this->workbook->close();
                return $this->excelfile;
        }
        
        public function deliver($outputfilename)
        {
                $this->workbook->close();
                ilUtil::deliverFile($this->excelfile, $outputfilename, "application/vnd.ms-excel", false, true);
                exit;
        }
        
        public function getWorksheetCount()
        {
                return count($this->workbook->worksheets());
        }
        
        public function setActiveWorksheet($index = 0)
        {
                $this->activesheet = $index;
        }
        
        protected function getActiveSheet()
        {
                $sheets = $this->workbook->worksheets();
                return $sheets[$this->activesheet];
        }
        
        public function setWorksheetTitle($title)
        {
                include_once "./Services/Excel/classes/class.ilExcelUtils.php";
                $this->getActiveSheet()->name = substr($this->convertToWindowsCharset($title), 0, 31);
        }
        
        public function addWorksheet($title = "")
        {
                include_once "./Services/Excel/classes/class.ilExcelUtils.php";
                if (strlen($title))
                {
                        $objWorksheet = $this->workbook->addWorksheet($this->convertToWindowsCharset($title));
                }
                else
                {
                        $objWorksheet = $this->workbook->addWorksheet();
                }
                $this->activesheet = $this->getWorksheetCount()-1;
                return $objWorksheet;
        }

        public function setColumnWidth($columnindex, $width)
        {
        }
        
        public function setCellValue($row, $col, $value, $format = CELL_FORMAT_NONE)
        {
                include_once "./Services/Excel/classes/class.ilExcelUtils.php";
                switch ($format)
                {
                        case CELL_FORMAT_DATETIME:
                                $this->getActiveSheet()->write($row, $col, $value, $this->format_datetime);
                                break;
                        case CELL_FORMAT_PERCENT:
                                $this->getActiveSheet()->write($row, $col, $value, $this->format_percent);
                                break;
                        case CELL_FORMAT_MINUTES:
                                $this->getActiveSheet()->write($row, $col, $value, $this->format_minutes);
                                break;
                        case CELL_FORMAT_CENTER:
                                $this->getActiveSheet()->write($row, $col, $value, $this->format_center);
                                break;
                        case CELL_FORMAT_TITLE:
                                $this->getActiveSheet()->writeString($row, $col, $this->convertToWindowsCharset($value), $this->format_title);
                                break;
                        case CELL_FORMAT_BOLD:
                                $this->getActiveSheet()->writeString($row, $col, $this->convertToWindowsCharset($value), $this->format_bold);
                                break;
                        case CELL_FORMAT_NONE:
                        default:
                                $this->getActiveSheet()->writeString($row, $col, $this->convertToWindowsCharset($value));
                                break;
                }
        }

        public function getFileExtension()
        {
                return "xls";
        }

        function convertToWindowsCharset($string) {
                $charset =  mb_detect_encoding(
                                $string,
                                "UTF-8, ISO-8859-1, ISO-8859-15",
                                true
                );
        
                $string =  mb_convert_encoding($string, "Windows-1252", $charset);
                return $string;
        }
        

        
}