Top "Phpexcel" questions

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

How can insert formula in excel sheet using phpexcel

I have checked many sites for solution of my problem but not found proper solution. I want to insert formula …

php phpexcel
Php Excel set whole column data alignment not working

I am Using this code For E column data set to right align but Its not showing me effect $objPHPExcel-&…

php phpexcel
Correct format for strings / numbers beginning with zero?

I'm trying to use PHP to create a file containing a list of phone numbers. It's working OK however if …

php phpexcel
PHPExcel modify existing .xlsx file with multiple worksheet

require_once '../Classes/PHPExcel/IOFactory.php'; /** PHPExcel */require_once '../Classes/PHPExcel.php'; $excel2 = PHPExcel_IOFactory::createReader('Excel2007'); $…

php wordpress phpexcel
How to get the number of columns of worksheet as integer (28) instead of Excel-letters ("AB")?

Given: $this->objPHPExcelReader = PHPExcel_IOFactory::createReaderForFile($this->config['file']); $this->objPHPExcelReader->setLoadSheetsOnly(array($this->config[…

php phpexcel
PHPExcel set border color of a cell

How to set border color of a cell? I used this code, but it's not working: $objPHPExcel->getActiveSheet() -&…

phpexcel
Using PHPExcel to make automatic generated excel files

I want to have my excel file filled with some data which I get from my database, for example the …

php mysql phpexcel
Setting autosize column phpExcel

How do I make PHPExcel create the column width automatically I don't like having to go in by hand and …

php phpexcel
How to fix memory getting exhausted with PHPExcel?

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1078799 bytes) in D:\xampplite\htdocs\Scraper\PHPExcel\Reader\Excel2007.…

php memory-management phpexcel
PHPExcel how to get column index from cell

PHPExcel $cell->getColumn() returns 'A', 'B', 'C', ... which is the best way to get the integer (0, 1, 2, ...) from the cell. …

php phpexcel