PhpSpreadsheet
PhpSpreadsheet copied to clipboard
PHPOffice
A pure PHP library for reading and writing spreadsheet files
This is a bug report ### What is the expected behavior? Import data using MS Excel Power Query correctly. ### What is the current behavior? I lose some data when...
This is: ``` - a bug report or a feature request ``` i need to get values of dropdown list in xlsx file but with $test = $validation->getFormula1(); i get...
in order to fully use the repo. there should be away to detect and read the sheet tables and styles, specially when importing the files, because currently all sheets with...
Fix #4025. With Conditional Formatting, Excel can change Font, Fill, Borders, and NumberFormat. It does not support Alignment nor Protection, at least not natively. This PR removes all code supporting...
This has come up a number of times, most recently with issue #3901, and also issue #3659, and issue #1834. It will certainly come up more often in days to...
Continuing work started with PR #4016. Improve documentation within program by making explicit what types of values are allowed for variables described as "mixed". In order to avoid broken functionality,...
Hello fellows, I am trying to use the library on one of my projects and when i tried to use setCellValueByColumnAndRow it says the following: Fatal error: Uncaught Error: Call...
``` $spreadsheet= IOFactory::load($this->file); $i= 0; dd($spreadsheet->getActiveSheet($row)->getDrawingCollection()); foreach ($spreadsheet->getActiveSheet()->getDrawingCollection() as $drawing) { if ($drawing instanceof MemoryDrawing) { ob_start(); call_user_func( $drawing->getRenderingFunction(), $drawing->getImageResource() ); $imageContents = ob_get_contents(); ob_end_clean(); switch ($drawing->getMimeType()) { case MemoryDrawing::MIMETYPE_PNG...
This is: - [ ] a bug report - [x] a feature request - [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet) ### What is the expected...
