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

Increment Loop to a excel cells horizontally PHP

I am working in a reporting module using Laravel 5 and http://www.maatwebsite.nl/laravel-excel and my question is how to I populate a data in excel horizontally? Because, vertically it's pretty easy let's say I want to populate vertically is cell A1…
jackhammer013
  • 2,295
  • 11
  • 45
  • 95
1
vote
1 answer

PHPExcel not reading user defined date formats

Trying to parse excel sheets but running into issues with user-defined date formats. The date format does not get added to the formattedData. I have no way of knowing what cell is going to contain a date and the dates come in all types of…
Joseph Batson
  • 45
  • 2
  • 9
1
vote
1 answer

PHPExcel Codeigniter : Fatal error: Uncaught exception 'PHPExcel_Reader_Exception'

I am working on a project in which i need to import data form a excel(.xlsx) fileinto a table in database. I already write code for a controller upload.php $this->load->library('excel'); ini_set('memory_limit', '-1'); $objReader =…
Vikas Kumar Thakur
  • 19
  • 5
1
vote
1 answer

Cannot read an Excel 97-2004 Workbook

I have been struggling so much to read a Excel file which I scraped from a web page. It has the type: Microsoft Excel 97-2004 Workbook (I checked it from MS Excel). This is what I am trying with PHPExcel: $destination = APPPATH .…
Fawzan
  • 4,738
  • 8
  • 41
  • 85
1
vote
2 answers

Reading excel file and writing to database using PHPExcel with Codeigniter

I want to write some information in the excel file to my database. The excel file looks like this. ID123 | subj1 | 50 ID456 | subj2 | 60 ID786 | subj3 | 70 This is the function in view that triggers the function in the controller.
M_T
  • 65
  • 1
  • 2
  • 10
1
vote
2 answers

Treat a formula like any other text value when exporting to Excel

I've built a reporting solution where the data can be exported as Excel. Using PHPExcel, this work's beautifully. But, we had a need to build dashboard style template sheets and have them inserted into the output at runtime, including formulas. I…
Jeremy Harris
  • 24,318
  • 13
  • 79
  • 133
1
vote
1 answer

CodeIgniter: Is there a SAFE way to run a flat PHP code inside CodeIgniter?

I have been working on a flat PHP code - No MVC. It has 1 index file with a form containing a radio and a file upload option + calls fuctions from 2 other .php files containing functions, and after submitting - it upload the file, loads PHPExcel…
Imnotapotato
  • 5,308
  • 13
  • 80
  • 147
1
vote
0 answers

How to fix memory error in codeplex phpexcel?

I tried to read excel file and convert it into array. But i m getting following error. Fatal error: Allowed memory size of 1677721600 bytes exhausted (tried to allocate 38 bytes) in…
Jonathan John
  • 195
  • 2
  • 4
  • 12
1
vote
2 answers

'getHighestRow' without taking into account formatting

Using PHPExcel, I have an issue with the getHighestRow() function. If the spreadsheet is formatted beyond the last data entry, highest row does not reflect data entry but cells modification including formatting. How can I have the number of useful…
Sébastien
  • 5,263
  • 11
  • 55
  • 116
1
vote
1 answer

Mapping Table columns with data while Importing using PHPExcel

I have a php application where I import the data from excel sheet to the database. I am using phpExcel for this. I have achieved a simple import functionality for this. Now, my problem is when I import data form excel sheet to the database in…
Pritesh Usadadiya
  • 29
  • 9
1
vote
1 answer

saving the pdf using phpexcel terminate the rest of the script

the echo statement is not running and the below script is also not running header("HTTP/1.1 200 OK"); header("Pragma: public"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); …
kashif
  • 193
  • 2
  • 19
1
vote
6 answers

unable to upload an excel file in codeigniter

I have a Codeigniter project that can insert data into database through uploading an excel file and reading it with PHPExcel. It is working on my localhost however when I uploaded it in a LAMP server, It gives me an error The filetype you are…
d_unknown
  • 875
  • 3
  • 15
  • 41
1
vote
0 answers

PHPExcel trimming leading zero?

I know this has been asked a thousand times but what I am currently doing seems to be the general answer I see online and it is still not working correctly. I am populating an excel document from a SQL query in which one of the columns is a ISBN10…
Adrocks__
  • 39
  • 6
1
vote
1 answer

PHPExcel - horizontal split worksheet

I have to create an Excelsheet with PHPExcel, which has an horizont Splitscreen. For Example: Column A to C are fixed and the others are able to scroll. Loading an existing Excelfile, which already has an Sheetsplit don´t work. The import is loosing…
L. Spielauer
  • 11
  • 1
1
vote
2 answers

PHP - Excel renders PDF without image

I'm developing with the yii2 framework. I need to render some reports which should have some images. Everything is working in my excel file. But in PDF there are no images. What I have in excel: What I have in PDF: My test code looks like…
Vladimir Glechikov
  • 131
  • 1
  • 8
1 2 3
…
99 100