summaryrefslogtreecommitdiffstats
path: root/admin/survey/excel/PHPExcel/Reader/SYLK.php
diff options
context:
space:
mode:
authorAnton Luka Šijanec <anton@sijanec.eu>2024-05-27 13:12:17 +0200
committerAnton Luka Šijanec <anton@sijanec.eu>2024-05-27 13:12:17 +0200
commitf1ab2f022fdc780aca0944d90e9a0e844a0820d7 (patch)
tree79942a40514f5ab40c5901349c9fcd30c6c8dc0e /admin/survey/excel/PHPExcel/Reader/SYLK.php
parent2024-02-19 upstream (diff)
download1ka-master.tar
1ka-master.tar.gz
1ka-master.tar.bz2
1ka-master.tar.lz
1ka-master.tar.xz
1ka-master.tar.zst
1ka-master.zip
Diffstat (limited to 'admin/survey/excel/PHPExcel/Reader/SYLK.php')
-rw-r--r--admin/survey/excel/PHPExcel/Reader/SYLK.php498
1 files changed, 0 insertions, 498 deletions
diff --git a/admin/survey/excel/PHPExcel/Reader/SYLK.php b/admin/survey/excel/PHPExcel/Reader/SYLK.php
deleted file mode 100644
index cfae98f..0000000
--- a/admin/survey/excel/PHPExcel/Reader/SYLK.php
+++ /dev/null
@@ -1,498 +0,0 @@
-<?php
-/**
- * PHPExcel
- *
- * Copyright (c) 2006 - 2012 PHPExcel
- *
- * This library is free software; you can redistribute it and/or
- * modify it under the terms of the GNU Lesser General Public
- * License as published by the Free Software Foundation; either
- * version 2.1 of the License, or (at your option) any later version.
- *
- * This library is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this library; if not, write to the Free Software
- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
- *
- * @category PHPExcel
- * @package PHPExcel_Reader
- * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
- * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
- * @version 1.7.8, 2012-10-12
- */
-
-
-/** PHPExcel root directory */
-if (!defined('PHPEXCEL_ROOT')) {
- /**
- * @ignore
- */
- define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
- require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
-}
-
-/**
- * PHPExcel_Reader_SYLK
- *
- * @category PHPExcel
- * @package PHPExcel_Reader
- * @copyright Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
- */
-class PHPExcel_Reader_SYLK implements PHPExcel_Reader_IReader
-{
- /**
- * Input encoding
- *
- * @var string
- */
- private $_inputEncoding = 'ANSI';
-
- /**
- * Sheet index to read
- *
- * @var int
- */
- private $_sheetIndex = 0;
-
- /**
- * Formats
- *
- * @var array
- */
- private $_formats = array();
-
- /**
- * Format Count
- *
- * @var int
- */
- private $_format = 0;
-
- /**
- * PHPExcel_Reader_IReadFilter instance
- *
- * @var PHPExcel_Reader_IReadFilter
- */
- private $_readFilter = null;
-
-
- /**
- * Create a new PHPExcel_Reader_SYLK
- */
- public function __construct() {
- $this->_readFilter = new PHPExcel_Reader_DefaultReadFilter();
- }
-
-
- /**
- * Can the current PHPExcel_Reader_IReader read the file?
- *
- * @param string $pFileName
- * @return boolean
- * @throws Exception
- */
- public function canRead($pFilename)
- {
- // Check if file exists
- if (!file_exists($pFilename)) {
- throw new Exception("Could not open " . $pFilename . " for reading! File does not exist.");
- }
-
- // Read sample data (first 2 KB will do)
- $fh = fopen($pFilename, 'r');
- $data = fread($fh, 2048);
- fclose($fh);
-
- // Count delimiters in file
- $delimiterCount = substr_count($data, ';');
- if ($delimiterCount < 1) {
- return false;
- }
-
- // Analyze first line looking for ID; signature
- $lines = explode("\n", $data);
- if (substr($lines[0],0,4) != 'ID;P') {
- return false;
- }
-
- return true;
- }
-
-
- /**
- * Read filter
- *
- * @return PHPExcel_Reader_IReadFilter
- */
- public function getReadFilter() {
- return $this->_readFilter;
- }
-
-
- /**
- * Set read filter
- *
- * @param PHPExcel_Reader_IReadFilter $pValue
- */
- public function setReadFilter(PHPExcel_Reader_IReadFilter $pValue) {
- $this->_readFilter = $pValue;
- return $this;
- }
-
-
- /**
- * Set input encoding
- *
- * @param string $pValue Input encoding
- */
- public function setInputEncoding($pValue = 'ANSI')
- {
- $this->_inputEncoding = $pValue;
- return $this;
- }
-
-
- /**
- * Get input encoding
- *
- * @return string
- */
- public function getInputEncoding()
- {
- return $this->_inputEncoding;
- }
-
-
- /**
- * Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns)
- *
- * @param string $pFilename
- * @throws Exception
- */
- public function listWorksheetInfo($pFilename)
- {
- // Check if file exists
- if (!file_exists($pFilename)) {
- throw new Exception("Could not open " . $pFilename . " for reading! File does not exist.");
- }
-
- // Open file
- $fileHandle = fopen($pFilename, 'r');
- if ($fileHandle === false) {
- throw new Exception("Could not open file " . $pFilename . " for reading.");
- }
-
- $worksheetInfo = array();
- $worksheetInfo[0]['worksheetName'] = 'Worksheet';
- $worksheetInfo[0]['lastColumnLetter'] = 'A';
- $worksheetInfo[0]['lastColumnIndex'] = 0;
- $worksheetInfo[0]['totalRows'] = 0;
- $worksheetInfo[0]['totalColumns'] = 0;
-
- // Loop through file
- $rowData = array();
-
- // loop through one row (line) at a time in the file
- $rowIndex = 0;
- while (($rowData = fgets($fileHandle)) !== FALSE) {
- $columnIndex = 0;
-
- // convert SYLK encoded $rowData to UTF-8
- $rowData = PHPExcel_Shared_String::SYLKtoUTF8($rowData);
-
- // explode each row at semicolons while taking into account that literal semicolon (;)
- // is escaped like this (;;)
- $rowData = explode("\t",str_replace('?',';',str_replace(';',"\t",str_replace(';;','?',rtrim($rowData)))));
-
- $dataType = array_shift($rowData);
- if ($dataType == 'C') {
- // Read cell value data
- foreach($rowData as $rowDatum) {
- switch($rowDatum{0}) {
- case 'C' :
- case 'X' :
- $columnIndex = substr($rowDatum,1) - 1;
- break;
- case 'R' :
- case 'Y' :
- $rowIndex = substr($rowDatum,1);
- break;
- }
-
- $worksheetInfo[0]['totalRows'] = max($worksheetInfo[0]['totalRows'], $rowIndex);
- $worksheetInfo[0]['lastColumnIndex'] = max($worksheetInfo[0]['lastColumnIndex'], $columnIndex);
- }
- }
- }
-
- $worksheetInfo[0]['lastColumnLetter'] = PHPExcel_Cell::stringFromColumnIndex($worksheetInfo[0]['lastColumnIndex']);
- $worksheetInfo[0]['totalColumns'] = $worksheetInfo[0]['lastColumnIndex'] + 1;
-
- // Close file
- fclose($fileHandle);
-
- return $worksheetInfo;
- }
-
-
- /**
- * Loads PHPExcel from file
- *
- * @param string $pFilename
- * @return PHPExcel
- * @throws Exception
- */
- public function load($pFilename)
- {
- // Create new PHPExcel
- $objPHPExcel = new PHPExcel();
-
- // Load into this instance
- return $this->loadIntoExisting($pFilename, $objPHPExcel);
- }
-
-
- /**
- * Loads PHPExcel from file into PHPExcel instance
- *
- * @param string $pFilename
- * @param PHPExcel $objPHPExcel
- * @return PHPExcel
- * @throws Exception
- */
- public function loadIntoExisting($pFilename, PHPExcel $objPHPExcel)
- {
- // Check if file exists
- if (!file_exists($pFilename)) {
- throw new Exception("Could not open " . $pFilename . " for reading! File does not exist.");
- }
-
- // Create new PHPExcel
- while ($objPHPExcel->getSheetCount() <= $this->_sheetIndex) {
- $objPHPExcel->createSheet();
- }
- $objPHPExcel->setActiveSheetIndex( $this->_sheetIndex );
-
- $fromFormats = array('\-', '\ ');
- $toFormats = array('-', ' ');
-
- // Open file
- $fileHandle = fopen($pFilename, 'r');
- if ($fileHandle === false) {
- throw new Exception("Could not open file $pFilename for reading.");
- }
-
- // Loop through file
- $rowData = array();
- $column = $row = '';
-
- // loop through one row (line) at a time in the file
- while (($rowData = fgets($fileHandle)) !== FALSE) {
-
- // convert SYLK encoded $rowData to UTF-8
- $rowData = PHPExcel_Shared_String::SYLKtoUTF8($rowData);
-
- // explode each row at semicolons while taking into account that literal semicolon (;)
- // is escaped like this (;;)
- $rowData = explode("\t",str_replace('¤',';',str_replace(';',"\t",str_replace(';;','¤',rtrim($rowData)))));
-
- $dataType = array_shift($rowData);
- // Read shared styles
- if ($dataType == 'P') {
- $formatArray = array();
- foreach($rowData as $rowDatum) {
- switch($rowDatum{0}) {
- case 'P' : $formatArray['numberformat']['code'] = str_replace($fromFormats,$toFormats,substr($rowDatum,1));
- break;
- case 'E' :
- case 'F' : $formatArray['font']['name'] = substr($rowDatum,1);
- break;
- case 'L' : $formatArray['font']['size'] = substr($rowDatum,1);
- break;
- case 'S' : $styleSettings = substr($rowDatum,1);
- for ($i=0;$i<strlen($styleSettings);++$i) {
- switch ($styleSettings{$i}) {
- case 'I' : $formatArray['font']['italic'] = true;
- break;
- case 'D' : $formatArray['font']['bold'] = true;
- break;
- case 'T' : $formatArray['borders']['top']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'B' : $formatArray['borders']['bottom']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'L' : $formatArray['borders']['left']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'R' : $formatArray['borders']['right']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- }
- }
- break;
- }
- }
- $this->_formats['P'.$this->_format++] = $formatArray;
- // Read cell value data
- } elseif ($dataType == 'C') {
- $hasCalculatedValue = false;
- $cellData = $cellDataFormula = '';
- foreach($rowData as $rowDatum) {
- switch($rowDatum{0}) {
- case 'C' :
- case 'X' : $column = substr($rowDatum,1);
- break;
- case 'R' :
- case 'Y' : $row = substr($rowDatum,1);
- break;
- case 'K' : $cellData = substr($rowDatum,1);
- break;
- case 'E' : $cellDataFormula = '='.substr($rowDatum,1);
- // Convert R1C1 style references to A1 style references (but only when not quoted)
- $temp = explode('"',$cellDataFormula);
- $key = false;
- foreach($temp as &$value) {
- // Only count/replace in alternate array entries
- if ($key = !$key) {
- preg_match_all('/(R(\[?-?\d*\]?))(C(\[?-?\d*\]?))/',$value, $cellReferences,PREG_SET_ORDER+PREG_OFFSET_CAPTURE);
- // Reverse the matches array, otherwise all our offsets will become incorrect if we modify our way
- // through the formula from left to right. Reversing means that we work right to left.through
- // the formula
- $cellReferences = array_reverse($cellReferences);
- // Loop through each R1C1 style reference in turn, converting it to its A1 style equivalent,
- // then modify the formula to use that new reference
- foreach($cellReferences as $cellReference) {
- $rowReference = $cellReference[2][0];
- // Empty R reference is the current row
- if ($rowReference == '') $rowReference = $row;
- // Bracketed R references are relative to the current row
- if ($rowReference{0} == '[') $rowReference = $row + trim($rowReference,'[]');
- $columnReference = $cellReference[4][0];
- // Empty C reference is the current column
- if ($columnReference == '') $columnReference = $column;
- // Bracketed C references are relative to the current column
- if ($columnReference{0} == '[') $columnReference = $column + trim($columnReference,'[]');
- $A1CellReference = PHPExcel_Cell::stringFromColumnIndex($columnReference-1).$rowReference;
-
- $value = substr_replace($value,$A1CellReference,$cellReference[0][1],strlen($cellReference[0][0]));
- }
- }
- }
- unset($value);
- // Then rebuild the formula string
- $cellDataFormula = implode('"',$temp);
- $hasCalculatedValue = true;
- break;
- }
- }
- $columnLetter = PHPExcel_Cell::stringFromColumnIndex($column-1);
- $cellData = PHPExcel_Calculation::_unwrapResult($cellData);
-
- // Set cell value
- $objPHPExcel->getActiveSheet()->getCell($columnLetter.$row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
- if ($hasCalculatedValue) {
- $cellData = PHPExcel_Calculation::_unwrapResult($cellData);
- $objPHPExcel->getActiveSheet()->getCell($columnLetter.$row)->setCalculatedValue($cellData);
- }
- // Read cell formatting
- } elseif ($dataType == 'F') {
- $formatStyle = $columnWidth = $styleSettings = '';
- $styleData = array();
- foreach($rowData as $rowDatum) {
- switch($rowDatum{0}) {
- case 'C' :
- case 'X' : $column = substr($rowDatum,1);
- break;
- case 'R' :
- case 'Y' : $row = substr($rowDatum,1);
- break;
- case 'P' : $formatStyle = $rowDatum;
- break;
- case 'W' : list($startCol,$endCol,$columnWidth) = explode(' ',substr($rowDatum,1));
- break;
- case 'S' : $styleSettings = substr($rowDatum,1);
- for ($i=0;$i<strlen($styleSettings);++$i) {
- switch ($styleSettings{$i}) {
- case 'I' : $styleData['font']['italic'] = true;
- break;
- case 'D' : $styleData['font']['bold'] = true;
- break;
- case 'T' : $styleData['borders']['top']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'B' : $styleData['borders']['bottom']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'L' : $styleData['borders']['left']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- case 'R' : $styleData['borders']['right']['style'] = PHPExcel_Style_Border::BORDER_THIN;
- break;
- }
- }
- break;
- }
- }
- if (($formatStyle > '') && ($column > '') && ($row > '')) {
- $columnLetter = PHPExcel_Cell::stringFromColumnIndex($column-1);
- $objPHPExcel->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($this->_formats[$formatStyle]);
- }
- if ((!empty($styleData)) && ($column > '') && ($row > '')) {
- $columnLetter = PHPExcel_Cell::stringFromColumnIndex($column-1);
- $objPHPExcel->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($styleData);
- }
- if ($columnWidth > '') {
- if ($startCol == $endCol) {
- $startCol = PHPExcel_Cell::stringFromColumnIndex($startCol-1);
- $objPHPExcel->getActiveSheet()->getColumnDimension($startCol)->setWidth($columnWidth);
- } else {
- $startCol = PHPExcel_Cell::stringFromColumnIndex($startCol-1);
- $endCol = PHPExcel_Cell::stringFromColumnIndex($endCol-1);
- $objPHPExcel->getActiveSheet()->getColumnDimension($startCol)->setWidth($columnWidth);
- do {
- $objPHPExcel->getActiveSheet()->getColumnDimension(++$startCol)->setWidth($columnWidth);
- } while ($startCol != $endCol);
- }
- }
- } else {
- foreach($rowData as $rowDatum) {
- switch($rowDatum{0}) {
- case 'C' :
- case 'X' : $column = substr($rowDatum,1);
- break;
- case 'R' :
- case 'Y' : $row = substr($rowDatum,1);
- break;
- }
- }
- }
- }
-
- // Close file
- fclose($fileHandle);
-
- // Return
- return $objPHPExcel;
- }
-
-
- /**
- * Get sheet index
- *
- * @return int
- */
- public function getSheetIndex() {
- return $this->_sheetIndex;
- }
-
-
- /**
- * Set sheet index
- *
- * @param int $pValue Sheet index
- * @return PHPExcel_Reader_SYLK
- */
- public function setSheetIndex($pValue = 0) {
- $this->_sheetIndex = $pValue;
- return $this;
- }
-
-}