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
2 answers

How to put line breaks every 30 records

I have a program that writes MySQL data to Excel via PHPExcel and I am having no errors but the problem is they don't have any line breaks in every 30 records. How can I achieve this programmatically in PHPExcel? This is my code: require…
Newbie N
  • 91
  • 1
  • 2
  • 11
1
vote
0 answers

Using PHP to fetch from Oracle into Excelsheet using PHPExcel, with data more then 65k row?

I'm using PHP OCI8 to retrieve data from oracle database into MS Excel Spreadsheet by using PHP Excel Function. The data consist of 23 column and more then 65k row. I consider this as big data and its fail to write to Excel and showing this…
Mohd Shahzuan Azmi
  • 11
  • 2
1
vote
1 answer

PHPExcel Writer create blank file

i try to create new excel file using phpexcel writer
Maksud Mansuri
  • 631
  • 13
  • 26
1
vote
0 answers

ms excel file doesn't load in PHPExcel

ms excel file doesn't load in PHPExcel but when i create excelsheets using libreoffice in linux it's load and upload in database. $temp=$_FILES['file']['tmp_name']; $destination = "/var/www/html/recovery"; …
Maksud Mansuri
  • 631
  • 13
  • 26
1
vote
1 answer

How to get column index of current cell of an excel using PHPExcel?

I am trying to get the index of the current active cell using PHPExcel. What I've tried so far is: // Get worksheet dimensions $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); …
rythm
  • 13
  • 1
  • 5
1
vote
1 answer

Phpexcel xls file showing garbage data while downloading

I am using PHPExcel 1.8.0 in my project. When I want to generate and download a .xls file with some data from my database, the file is downloaded with garbage data. Here is my code: $result = mysql_query("select * from my_table"); ob_start(); …
Md. Shamvil Hossain
  • 340
  • 6
  • 24
1
vote
0 answers

PHPExcel delete rows in a loop

is there a more efficient way to delete rows in a loop than this workaround? /** * Delete all rows that are identified on the 'D' * column with a $tag String value * @param String $tag */ protected function deleteRowsByTag( $tag ) { $found…
Igor L.
  • 3,159
  • 7
  • 40
  • 61
1
vote
0 answers

PHPExcel not well-formed

Hello I'm trying to generate and download excel file via Ajax, but unfortunately I'm getting this error not well-formed and nothing more specific.. I've checked all the variables etc and I'm sure that there aren't missing any required values.. So…
Sangsom
  • 257
  • 6
  • 15
1
vote
1 answer

Codeigniter + PHPExcel Library Issue

I am using PHPExcel library as shown here. But, tt's not working as expected. When I searched, someone has suggested replacing PHPEXcel_IOFactory to IOFactory. It downloads the file, but it couldn't be opened. Any suggestions? Here is my library…
Satish Saini
  • 2,880
  • 3
  • 24
  • 38
1
vote
1 answer

PHPExcel File format or extension is not valid 2

I'm using phpexcel for export my query in excel file; however after I created file(which is xslx format), I can not open my file in excel. It gives "the file format or extension is not valid. If i try to open with OpenOffice Calc it opens correctly.…
Dauezevy
  • 1,012
  • 4
  • 22
  • 46
1
vote
1 answer

phpexcel memory exhausted with 128Mb memory reading only first row of a big file

I've a memory problem with an xlsx file of about 95.500 rows and 28 columns. To handle such big file (more than 10 MB xlsx) i wrote below code but when i execute the code and calling the load method i receive a memory exhausted error even with only…
Marco
  • 487
  • 2
  • 6
  • 25
1
vote
1 answer

PHPExcel Multi Sheet Loop Issue

I'm developing a small class that will allow you to pass queries and it will create a worksheet for each query. FYI: This class is still in development and I will be reducing down into smaller functions. My issue is that for some reason my sheet…
M H
  • 2,179
  • 25
  • 50
1
vote
2 answers

PHPExcel pop up progress bar or waiting icon while generating excel file

I using PHPExcel to generate excel file, but due to some excel file is quite big, it takes time to generate. When excel file is generating, I wish to add a popup that shows either progress bar or a waiting icon. I've tried all the solution I found…
Elise
  • 65
  • 3
  • 9
1
vote
0 answers

PHPExcel: Is it possible to remove a whole row (not only empty cells)

I work with PHPExcel, and I want to remove (copletlly delete a row). I currently use $objPHPExcel->getActiveSheet()->removeRow($i); which does empty the cells, but I want to completlly remove the rows. I run a function that uses this code line,…
Imnotapotato
  • 5,308
  • 13
  • 80
  • 147
1
vote
1 answer

PHPExcel - Populate data from Array

I have so far successfully exported data from Mysql into Excel via PHPExcel, made my tables, formatted, and everything is hunky dory. However, so far any attempt at making graphs from said tables failed miserably. Not only, after days on end of…
user3375601
  • 119
  • 2
  • 9
1 2 3
…
99 100