123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478 |
- <?php
- if (!defined('PHPEXCEL_ROOT')) {
-
- define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../../');
- require(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
- }
- class PHPExcel_Reader_SYLK extends PHPExcel_Reader_Abstract implements PHPExcel_Reader_IReader
- {
-
- private $inputEncoding = 'ANSI';
-
- private $sheetIndex = 0;
-
- private $formats = array();
-
- private $format = 0;
-
- public function __construct()
- {
- $this->readFilter = new PHPExcel_Reader_DefaultReadFilter();
- }
-
- protected function isValidFormat()
- {
-
- $data = fread($this->fileHandle, 2048);
-
- $delimiterCount = substr_count($data, ';');
- if ($delimiterCount < 1) {
- return false;
- }
-
- $lines = explode("\n", $data);
- if (substr($lines[0], 0, 4) != 'ID;P') {
- return false;
- }
- return true;
- }
-
- public function setInputEncoding($pValue = 'ANSI')
- {
- $this->inputEncoding = $pValue;
- return $this;
- }
-
- public function getInputEncoding()
- {
- return $this->inputEncoding;
- }
-
- public function listWorksheetInfo($pFilename)
- {
-
- $this->openFile($pFilename);
- if (!$this->isValidFormat()) {
- fclose($this->fileHandle);
- throw new PHPExcel_Reader_Exception($pFilename . " is an Invalid Spreadsheet file.");
- }
- $fileHandle = $this->fileHandle;
- rewind($fileHandle);
- $worksheetInfo = array();
- $worksheetInfo[0]['worksheetName'] = 'Worksheet';
- $worksheetInfo[0]['lastColumnLetter'] = 'A';
- $worksheetInfo[0]['lastColumnIndex'] = 0;
- $worksheetInfo[0]['totalRows'] = 0;
- $worksheetInfo[0]['totalColumns'] = 0;
-
- $rowData = array();
-
- $rowIndex = 0;
- while (($rowData = fgets($fileHandle)) !== false) {
- $columnIndex = 0;
-
- $rowData = PHPExcel_Shared_String::SYLKtoUTF8($rowData);
-
-
- $rowData = explode("\t", str_replace('¤', ';', str_replace(';', "\t", str_replace(';;', '¤', rtrim($rowData)))));
- $dataType = array_shift($rowData);
- if ($dataType == 'C') {
-
- 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;
-
- fclose($fileHandle);
- return $worksheetInfo;
- }
-
- public function load($pFilename)
- {
-
- $objPHPExcel = new PHPExcel();
-
- return $this->loadIntoExisting($pFilename, $objPHPExcel);
- }
-
- public function loadIntoExisting($pFilename, PHPExcel $objPHPExcel)
- {
-
- $this->openFile($pFilename);
- if (!$this->isValidFormat()) {
- fclose($this->fileHandle);
- throw new PHPExcel_Reader_Exception($pFilename . " is an Invalid Spreadsheet file.");
- }
- $fileHandle = $this->fileHandle;
- rewind($fileHandle);
-
- while ($objPHPExcel->getSheetCount() <= $this->sheetIndex) {
- $objPHPExcel->createSheet();
- }
- $objPHPExcel->setActiveSheetIndex($this->sheetIndex);
- $fromFormats = array('\-', '\ ');
- $toFormats = array('-', ' ');
-
- $rowData = array();
- $column = $row = '';
-
- while (($rowData = fgets($fileHandle)) !== false) {
-
- $rowData = PHPExcel_Shared_String::SYLKtoUTF8($rowData);
-
-
- $rowData = explode("\t", str_replace('¤', ';', str_replace(';', "\t", str_replace(';;', '¤', rtrim($rowData)))));
- $dataType = array_shift($rowData);
-
- 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;
-
- } 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);
-
- $temp = explode('"', $cellDataFormula);
- $key = false;
- foreach ($temp as &$value) {
-
- if ($key = !$key) {
- preg_match_all('/(R(\[?-?\d*\]?))(C(\[?-?\d*\]?))/', $value, $cellReferences, PREG_SET_ORDER+PREG_OFFSET_CAPTURE);
-
-
-
- $cellReferences = array_reverse($cellReferences);
-
-
- foreach ($cellReferences as $cellReference) {
- $rowReference = $cellReference[2][0];
-
- if ($rowReference == '') {
- $rowReference = $row;
- }
-
- if ($rowReference{0} == '[') {
- $rowReference = $row + trim($rowReference, '[]');
- }
- $columnReference = $cellReference[4][0];
-
- if ($columnReference == '') {
- $columnReference = $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);
-
- $cellDataFormula = implode('"', $temp);
- $hasCalculatedValue = true;
- break;
- }
- }
- $columnLetter = PHPExcel_Cell::stringFromColumnIndex($column-1);
- $cellData = PHPExcel_Calculation::unwrapResult($cellData);
-
- $objPHPExcel->getActiveSheet()->getCell($columnLetter.$row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
- if ($hasCalculatedValue) {
- $cellData = PHPExcel_Calculation::unwrapResult($cellData);
- $objPHPExcel->getActiveSheet()->getCell($columnLetter.$row)->setCalculatedValue($cellData);
- }
-
- } 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);
- if (isset($this->formats[$formatStyle])) {
- $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;
- }
- }
- }
- }
-
- fclose($fileHandle);
-
- return $objPHPExcel;
- }
-
- public function getSheetIndex()
- {
- return $this->sheetIndex;
- }
-
- public function setSheetIndex($pValue = 0)
- {
- $this->sheetIndex = $pValue;
- return $this;
- }
- }
|