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
PHPExcel set same properties, content etc on multiple sheets at once

Is there anyway to set the same properties (colors, row height, alignments) and content (hear names) for all sheets at …

php settings phpexcel worksheet