class.ilExcelXMLAdapter.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 ilExcelXMLAdapter extends ilExcelAdapter
{
        var $objPHPExcel;
        
        function __construct()
        {
                $worksheets = array();
                
                include_once './Services/Excel/PHPExcel/1.7.6/Classes/PHPExcel.php';
                
                include_once './Services/Excel/PHPExcel/1.7.6/Classes/PHPExcel/Writer/Excel2007.php';

                // set cache to temp dir to prevent memory exhaustion
                $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
                $cacheSettings = array();
                PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

                // Create new PHPExcel object
                $this->objPHPExcel = new PHPExcel();
                
                // Set properties
                $this->objPHPExcel->getProperties()->setCreator("ILIAS Open Source");
                $this->objPHPExcel->getProperties()->setLastModifiedBy("ILIAS Open Source");
                $this->objPHPExcel->getProperties()->setTitle($this->strFormKey);
                $this->objPHPExcel->getProperties()->setSubject($this->strFormKey);
                $this->objPHPExcel->getProperties()->setDescription($this->strFormKey);
                $this->objPHPExcel->getProperties()->setKeywords("Office 2007 ILIAS Open Source");
                $this->objPHPExcel->getProperties()->setCategory("wcms data storage");

                $this->objPHPExcel->setActiveSheetIndex(0);
        }

        public function save()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $objWriter = new PHPExcel_Writer_Excel2007($this->objPHPExcel);
                $tempname = ilUtil::ilTempnam() .".xlsx";
                $objWriter->save($tempname);
                return $tempname;
        }
        
        public function deliver($outputfilename)
        {
                $tempname = $this->save();
                header('Content-Type: appplication/excel');
                header('Content-Transfer-Encoding: binary');
                header('Content-Disposition: attachment; filename="' . $outputfilename . '"');
                header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
                header('Pragma: public');
                header('Expires: 0');
                print file_get_contents($tempname);
                unlink($tempname);
                exit;
        }
        
        public function getWorksheetCount()
        {
                return $this->objPHPExcel->getSheetCount();
        }
        
        public function setActiveWorksheet($index = 0)
        {
                $this->objPHPExcel->setActiveSheetIndex($index);
        }
        
        public function setWorksheetTitle($title)
        {
                try
                {
                        $this->objPHPExcel->getActiveSheet()->setTitle(substr($title, 0, 31));
                }
                catch (Exception $e)
                {
                        
                }
        }

        public function setColumnWidth($columnindex, $width)
        {
                if (strcmp($width, 'auto') == 0)
                {
                        $this->objPHPExcel->getActiveSheet()->getColumnDimension($this->getCellTitle($columnindex))->setAutoSize(true);
                }
                else
                {
                        $this->objPHPExcel->getActiveSheet()->getColumnDimension($this->getCellTitle($columnindex))->setWidth($width);
                }
        }
        
        public function addWorksheet($title = "")
        {
                $objWorksheet = $this->objPHPExcel->createSheet();
                try
                {
                        $objWorksheet->setTitle(substr($title, 0, 31));
                }
                catch (Exception $e)
                {
                        
                }
                return $objWorksheet;
        }
        
        public function setCellValue($row, $col, $value, $format = CELL_FORMAT_NONE)
        {
                $cell = $this->getCellTitle($col).($row+1);
                $this->objPHPExcel->getActiveSheet()->setCellValue($cell, $value);
                switch ($format)
                {
                        case CELL_FORMAT_DATETIME:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME);
                                break;
                        case CELL_FORMAT_PERCENT:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE);
                                break;
                        case CELL_FORMAT_MINUTES:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->getNumberFormat()->setFormatCode('hh:mm');
                                break;
                        case CELL_FORMAT_TITLE:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->applyFromArray($this->formatCellTitle());
                                break;
                        case CELL_FORMAT_CENTER:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->applyFromArray($this->formatCellCenter());
                                break;
                        case CELL_FORMAT_BOLD:
                                $this->objPHPExcel->getActiveSheet()->getStyle($cell)->applyFromArray($this->formatCellBold());
                                break;
                        case CELL_FORMAT_NONE:
                        default:
                                break;
                }
        }
        
        protected function formatCellTitle()
        {
                return array(
                        'font'    => array(
                                'bold'      => true,
                                'color'     => array(
                                        'argb' => 'FF000000'
                                )
                        ),
                        'fill' => array(
                                'type' => PHPExcel_Style_Fill::FILL_SOLID,
                                'color' => array(
                                        'argb'=>'80AAAAAA'
                                ),
                        ),
                        'alignment' => array(
                                'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
                        )
                );
        }

        protected function formatCellCenter()
        {
                return array(
                        'font'    => array(
                                'bold'      => false,
                                'color'     => array(
                                        'argb' => 'FF000000'
                                )
                        ),
                        'alignment' => array(
                                'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
                        )
                );
        }

        protected function formatCellBold()
        {
                return array(
                        'font'    => array(
                                'bold'      => true,
                                'color'     => array(
                                        'argb' => 'FF000000'
                                )
                        )
                );
        }

        protected function formatCellPercent()
        {
                return array(
                        'font'    => array(
                                'bold'      => true,
                                'color'     => array(
                                        'argb' => '00000080'
                                )
                        ),
                        'alignment' => array(
                                'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
                        )
                );
        }
        
        public function getFileExtension()
        {
                return "xlsx";
        }
        
        private function getCellTitle($index)
        {
                if ($index < 26) {
                        return chr(65 + $index);
                } elseif ($index < 702) {
                        return chr(64 + ($index / 26)).chr(65 + $index % 26);
                }
                return chr(64 + (($index - 26) / 676)).chr(65 + ((($index - 26) % 676) / 26)).chr(65 + $index % 26);
        }
}