Stack Overflow
Stack Overflow

Questions tagged [phpexcel]

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

PHPExcel was a library written in pure PHP that provides methods to read workbook files generated by Excel and other spreadsheet programs (Excel 95 and higher .xls and .xlsx, Excel 2003 XML, Comma-Separated Value, SYLK, Gnumeric, and Open/Libre Office Calc .ods); to manipulate spreadsheet data and formatting; and to create/write to various formats (Excel BIFF8 .xls, Excel 2007 .xlsx, Comma-Separated Value, HTML, and PDF).

It is a component of the PHPOffice suite of libraries, comprising PHPExcel, PHPWord, PHPPowerPoint, PHPProject and PHPVisio.

The last production release of PHPExcel was version 1.8.1 in year 2015 via composer and git.

The final notice from PHPExcel is:

The project has not be maintained for years and must not be used anymore. All users must migrate to its direct successor PhpSpreadsheet, or another alternative.

Popular questions

Resources

Documentation

3639 questions
1
vote
1 answer

php_excel / libxl : How to make part of the cell text bold

With PHPExcel library with RichText objects, it's possible to set specific styles to some parts of cell text. An example is given on this post : PHPExcel - How to make part of the text bold How to do this with php extension php_excel based on libxl…
Koryonik
  • 2,728
  • 3
  • 22
  • 27
1
vote
2 answers

Fatal error: Allowed memory size of 134217728 bytes exhausted in C:\wamp\www\zannier\Classes\PHPExcel\CachedObjectStorage\CacheBase.php

i try to treat a massive excel file (5500 row * 50 column) with PHP my code is correct i don't have any bug when i tried it for only 100 rows. but when i put the whole file, i have this fatal Error i tried to change the memory_limit to 256 instead…
Ahmed
  • 169
  • 1
  • 4
  • 13
1
vote
1 answer

PHPExcel date formatting in strange numbers

I have made a script using PHPExcel to convert .xls files to .csv files. The .xls file has date formatting in it, and when converted to .csv the date fields has a high number increasing 1 for every day: So how do I fix this? I want it to say it…
Da_programmer
  • 177
  • 1
  • 15
1
vote
0 answers

PHPExcel to html gives empty cells

Im Using the PHPExcel library to convert a uploaded .xlsx file to a html page. The code works but the html page also has alot of empty cells in it. what can i do so PHPExcel wil not create these? the convert $inputFileName =…
Jordi van der Hek
  • 91
  • 10
1
vote
1 answer

PHPExcel more than one image in a cell

I need to create an excel document with only 2 col. The first one will contain multiple images 150px large and the seconde one will contain a web code. For some reason only one image is added and the file appears to be currupted. Not sure what i am…
Patrick Simard
  • 2,294
  • 3
  • 24
  • 38
1
vote
1 answer

How to conditionally format duplicate values with PHPExcel

I'm trying to set conditional formatting for duplicate values using PHPExcel. The class PHPExcel_Style_Conditional exports almost all of the conditions available in Excel like OPERATOR_GREATERTHAN, OPERATOR_LESSTHAN etc. but I can't find anything to…
flu
  • 14,307
  • 8
  • 74
  • 71
1
vote
0 answers

phpexcel cannot pass ~

Somewhere in my program my phpexcel looks like this: $objPHPExcel = new PHPExcel(); foreach($arrayRawData as $HwKeyColumn => $arrayHwData){ $objPHPExcel->setActiveSheetIndex($counter) -> setCellValue($Header2 .…
aozora
  • 423
  • 3
  • 13
1
vote
1 answer

PHPExcel calculate formula cell and format currency

Now I'm reading an excel file and showing it on a html table. like this:
PlayHardGoPro
  • 2,791
  • 10
  • 51
  • 90
1
vote
1 answer

figuring out how to get row id column id with php excel

im trying to find a way to get the rowid and columnid of an excel sheet using php, something like if($date == $row){ your $rowid = 'something} ive seen something like $row =…
nonaxanon
  • 237
  • 4
  • 18
1
vote
2 answers

Best way to insert and query a lot of data MySQL

I have to read approximately 5000 rows of 6 columns max from a xls file. I'm using PHP >= 5.3. I'll be using PHPExcel for that task. I haven't try it but I think it can handle (If you have other options, they are welcome). The issue is that every…
user2430929
  • 113
  • 5
  • 15
1
vote
1 answer

PHPExcel cannot load spreadsheet with formula

When trying to create a reader for a file, I get some strange errors. I was using the dev-master branch, then switched to 1.8.1 but that didn't seem to make any difference therefore I'm thinking it's the spreadsheet that's the problem. There are…
iswinky
  • 1,951
  • 3
  • 16
  • 47
1
vote
1 answer

Warning after download and open Excel file exported from Magento

I using exporting data to excel 2007 using PhpExcel 1.8.0. Its working but Excel File is saved in Client side but when I open the downloaded Excel file, I get the warning message We found a problem with some content in 'filename.xlsx'. Do you…
user123456789
  • 189
  • 3
  • 5
  • 17
1
vote
1 answer

Get a template and dont overwrite the cells into blank spaces

I'm having a situation, that i get one template in excel, where i just want to add the information of my database, but when i do that put the template blank just with the information. Please tell me what i'm doing wrong. I'm new to…
user3617397
  • 74
  • 1
  • 6
1
vote
0 answers

Could not open file for reading! File does not exist using Symfony and PHPExcel

I have to insert data of the excel file in MySql table which can be selected from a location and I am using Symfony, PHPExcel and Ajax for this. I have created a file upload button in table. I click on choose files, select the file and click on…
Mukesh Joshi
  • 2,784
  • 4
  • 24
  • 34
1
vote
0 answers

PHPExcel: Shows image file not found error in adding image to excel sheet

I am generating an excel report where there is a column for passport size images. I want to add the images to that column one by one as per the record fetch. My code for adding the image to the sheet is this: $columnID =…
user4741577
1 2 3
…
99 100