Top "Phpexcel" questions

PHPExcel toArray skip first header row

I'm uploading an excel file to website and process it for database use. I'm using toArray() function to get all …

php phpexcel phpexcelreader

Vertical Text in PHPExcel Cell

How can I print text vertically in a cell using PHPExcel class ? need to print like the above figure.

php codeigniter phpexcel

How to read excel file and display data in Yii 2?

I have tried to use PHPExcel library to read the excel file and display data from the file. But it …

php phpexcel yii2 yii-extensions yii-components

How to set money format in PhpSpreadSheet?

I'm using PHPSpreadSheet and I want to set money format for a cell. In PHPExcel you can do this by …

php phpexcel phpspreadsheet

Style a range of cells with phpexcel

I'm trying to style an excel table with phpexcel. I do this: $sheet->getStyle('A1:B2')->…

php phpexcel

copy style and data in PHPExcel

I would like to copy all the data and the style of a certain range to other cells. for example …

php phpexcel phpexcelreader

Does PHP Have a "built-in" iterator in a Foreach loop?

I'm using a foreach loop to go through the REQUEST array, as I want to have an easy way to …

php foreach iterator phpexcel

Custom PHPExcel cell format only shown after double-click

I encountered a weird problem setting a custom date format with PHPExcel: I'm writing an sql formatted date to a …

phpexcel export-to-excel

How to check if the first row or columns of Excel file is valid in Laravel Excel?

I'm trying to check if the excel file a user has uploaded has the correct columns/first row/attributes before …

laravel laravel-4 phpexcel laravel-excel

PHPExcel outputting zeros as blank cells

I'm building a WordPress plugin using PHPExcel to export reports of student attendance. So far, I'm able to successfully take …

php phpexcel