function test($name, $lc, $lp) { static $i = 0; echo "==={$i}===\n"; $i++; $o = new SplFileInfo($name); var_dump($o); $c = clone $o; var_dump($c); var_dump($o === $c); var_dump($o == $c); var_dump($o->getPathname() == $c->getPathname()); try { $f = new SplFileObject($name); var_dump($name); var_dump($f->getPathName()); $l = substr($f->getPathName(), -1); var_dump($l != '/' && $l != '\\' && $l == $lc); var_dump($f->getFileName()); $l = substr($f->getFileName(), -1); var_dump($l != '/' && $l != '\\' && $l == $lc); var_dump($f->getPath()); $l = substr($f->getPath(), -1); var_dump($l != '/' && $l != '\\' && $l == $lp); } catch (LogicException $e) { echo "LogicException: " . $e->getMessage() . "\n"; } try { $fo = $o->openFile(); var_dump($fo->getPathName(), $fo->getFileName(), $fo->getPath()); } catch (LogicException $e) { echo "LogicException: " . $e->getMessage() . "\n"; } }
/** * Construct CSV reader * * @param \SplFileObject $file Excel file * @param int $headerRowNumber Optional number of header row * @param int $activeSheet Index of active sheet to read from */ public function __construct(\SplFileObject $file, $headerRowNumber = null, $activeSheet = null) { $reader = \PHPExcel_IOFactory::createReaderForFile($file->getPathName()); $reader->setReadDataOnly(true); $excel = $reader->load($file->getPathname()); if (null !== $activeSheet) { $excel->setActiveSheetIndex($activeSheet); } $this->worksheet = $excel->getActiveSheet()->toArray(); if (null !== $headerRowNumber) { $this->setHeaderRowNumber($headerRowNumber); } }
/** * @param \SplFileObject $file Excel file * @param integer $headerRowNumber Optional number of header row * @param integer $activeSheet Index of active sheet to read from * @param boolean $readOnly If set to false, the reader take care of the excel formatting (slow) */ public function __construct(\SplFileObject $file, $headerRowNumber = null, $activeSheet = null, $readOnly = true) { $reader = \PHPExcel_IOFactory::createReaderForFile($file->getPathName()); $reader->setReadDataOnly($readOnly); /** @var \PHPExcel $excel */ $excel = $reader->load($file->getPathname()); if (null !== $activeSheet) { $excel->setActiveSheetIndex($activeSheet); } $this->worksheet = $excel->getActiveSheet(); $this->maxColumn = $this->worksheet->getHighestColumn(); $this->maxRow = $this->worksheet->getHighestRow(); if (null !== $headerRowNumber) { $this->setHeaderRowNumber($headerRowNumber); } }
public function __construct(\SplFileObject $file, $headerRowNumber = null, $activeSheet = null, $readOnly = true, $maxRows = null, $maxCol = null) { $this->file = $file; $this->activeSheet = $activeSheet; $this->reader = \PHPExcel_IOFactory::createReaderForFile($file->getPathName()); $this->reader->setReadDataOnly($readOnly); if (!is_null($headerRowNumber)) { $this->headerRowNumber = $headerRowNumber; $headerReader = clone $this->reader; $headerReader->setReadFilter(new ReadFilter($headerRowNumber + 1)); /** @var \PHPExcel $excel */ $excel = $headerReader->load($file->getPathname()); if (null !== $activeSheet) { $excel->setActiveSheetIndex($activeSheet); } $rows = $excel->getActiveSheet()->toArray(); $this->columnHeaders = $rows[$headerRowNumber]; //set max col from header length if not already given if (is_null($maxCol)) { $maxCol = \PHPExcel_Cell::stringFromColumnIndex(count($this->columnHeaders) - 1); } } $this->setBoundaries($maxRows, $maxCol); }
function outputImage($pic) { if (!is_object($pic)) { $pic = new SplFileObject($pic); } $picPath = $pic->getPathName(); $picExt = strtolower(substr($picPath, -3)); //jeko moved strtolower only used for preg_match and mime type // IE gets paths to images, cool kids get base64 image data if (preg_match('%(jpg|png|gif)%', $picExt)) { //sm_com preg_match once if (isIE()) { return $picPath; } else { //sm_com removed if !isIE() $picData = base64_encode(file_get_contents($picPath)); return "data:image/" . $picExt . ";base64," . $picData; //sm_com removed switch: } } else { return false; //sm_com or throw an error (it's not an acceptable image type or not an image) } }