Top "Phpexcel" questions

A PHP library to create, read, edit and write spreadsheet files for MS Excel and other spreadsheet programs

PHPSpreadsheet auto row height not works with LibreOffice latest version

I am using PHPSpreadsheet now, I am trying to get rows to auto height. It is working fine in MSOffice …

php codeigniter phpexcel libreoffice phpspreadsheet
PHPExcel how to set collapse and expands for groups of row?

Suppose I want to set collapse and expand for row 2 up to 4 as one group, and 8 up to 12 the second …

php laravel laravel-5.1 phpexcel laravel-excel
PhpExcel new line in cell

What I do: query data from db explode data and insert \n prepare array open tamplate insert array into tamplate …

php phpexcel phpoffice
Class 'PHPExcel_IOFactory' not found - CakePHP & PHPExcel

Background I have issues using PHPExcel's IOFactory in my app. My PHPExcel helper works if I want to generate an …

cakephp phpexcel cakephp-2.2
PHPExcel - format for the column

I need to set for all columns format: FORMAT_NUMBER I can do it for one cell. But I can …

php phpexcel phpexcel-1.8.0
PHPExcel create/style/save PDF Documentation

I'm using the PHPExcel library in a couple of project and love the functionality it provides. Currently I needed to …

php pdf pdf-generation phpexcel pdftk
PHPExcel Bar chart using PHPExcel

I have completed my work till gets the SQL table data in excel but I also want to convert data …

php phpexcel bar-chart phpexcel-1.8.0
PHPExcel how to solve the encoding issue when reading a file

I was working on an Yii2 API where i need to upload a .csv or .xlsx file and read from …

php yii2 phpexcel phpexcelreader
Not able to create multiple worksheet in PHP Excel

Hi I am creating multiple worksheet in PHP Excel but it is not working. I am facing one issue "You …

php web phpexcel phpspreadsheet