Top "Phpexcel" questions

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

PHPExcel Make first row bold

I am trying to make cells in first row are bold. This is the method I have created for that …

php phpexcel
PHPExcel - creating multiple sheets by iteration

I'm trying to create multiple sheets by iteration in phpexcel: $i=0; while ($i < 10) { // Add new sheet $objWorkSheet = $objPHPExcel->…

php phpexcel
Alternative for PHP_excel

Is there any alternative for PHP_excel which can "Export to XLSX/XLS" file in a customized format? This is …

php phpexcel
Merge Cell values with PHPExcel - PHP

I have a simple table like: - id - first_name - last_name - email - phone I'm using …

php phpexcel phpspreadsheet
PHPExcel set border and format for all sheets in spreadsheet

I'm currently trying to set all borders for my spreadsheet, also formatting such as autosize. My code below is working, …

php phpexcel
PHPExcel How to apply styles and set cell width and cell height to cell generated dynamically

I have form that I generate its content to Excel through PHPExcel, my problem is that how can I set …

phpexcel
PHPExcel - set cell type before writing a value in it

Do you know how can I set the cell type before writing a value in it? I would like to …

phpexcel
how to make New lines in a cell using phpexcel

i have problem with php excel, i want to make new line in one cell but i can't, i have …

php phpexcel
How to find out how many rows and columns to read from an Excel file with PHPExcel?

With the following code, I am able to read the cells out of an Excel file with PHPExcel. I currently …

php phpexcel
PHPExcel and Text Wrapping

I know that this line of code will make the cell text-wrap: $objPHPExcel->getActiveSheet()->getStyle('D1')…

php mysql database phpexcel