Stack Overflow
Stack Overflow

Questions tagged [phpexcelreader]

PHP Library for reading Excel files

133 questions
25
votes
3 answers

Adding Image to the Excel in phpexcel in php

I am taking the example from phpexcel I just tried with passing value in GET Method, I am done with that. Now i am trying to add image in the a3 coloumn. Reference Code :
AngularAngularAngular
  • 3,589
  • 5
  • 25
  • 41
20
votes
3 answers

PHPExcel - Incorrect data population during excel report generation

I am working on a project in Symfony 2.1.PHPExcel version is 1.8.0. I use Doctrine to retrieve the data from Db and filter if required. $em = $this->getDoctrine()->getManager(); $guardquery = $em->createQueryBuilder() …
Basher51
  • 1,319
  • 1
  • 17
  • 28
9
votes
3 answers

copy style and data in PHPExcel

I would like to copy all the data and the style of a certain range to other cells. for example I want to copy from A4: I15 and then paste exactly want I copied the contents and styles from A16. How can I do it?. this is what I want to copy: I know…
user5115790
8
votes
2 answers

PHPExcel exceeds memory usage only with XLS files

I'm having a memory issue with PHPExcel when processing an XLS file. I have to work with quite big files (between 50k and 200k rows, and 9-10 cols) so I had to use ReadFilters to solve the memory issue. However, although it worked pretty well with…
sergio0983
  • 1,232
  • 8
  • 15
7
votes
3 answers

PHPExcel toArray skip first header row

I'm uploading an excel file to website and process it for database use. I'm using toArray() function to get all rows in a php array. But I want to skip the first row ( header title row). The rest of rows will be stored in array. How can I skip the…
Sohan Patel
  • 259
  • 1
  • 3
  • 13
5
votes
2 answers

PHPExcel how to solve the encoding issue when reading a file

I was working on an Yii2 API where i need to upload a .csv or .xlsx file and read from it using PHPExcel(DEPRECATED now , but i am stuck with it as new one PhpSpreadsheet requires PHP version 5.6 or newer) and return the array of data . This was…
Joel Joseph
  • 5,889
  • 4
  • 31
  • 36
5
votes
1 answer

PHP: How do I can get data as string format from Excel data with scientific notation / exponential format?

I've a project in Yii2 that using PHPExcel library for read an Excel file. I've a Transaction Id column that contain data in General format cell. Screenshoot of my Excel file: You can see above, if I input 15 characters of number and put two dots…
Blackjack
  • 1,016
  • 1
  • 20
  • 51
5
votes
1 answer

How do I use PHPExcel to read data from an Excel file?

I want to read data from an Excel file in PHP so that I can process the data and insert it into a DB. Looking around SO, it looks like PHPExcel is the premier library for this task. I went to the PHPExcel GitHub page…
HartleySan
  • 7,404
  • 14
  • 66
  • 119
5
votes
1 answer

PHPExcel - How can i change color, border and background of chart using phpexcel library?

I am working with PHPExcel library, I am not able to change the color of the graph. let me know if anyone have a solution to it? Check in this screen I want to change colors which are blue, red and green:
Shailesh Patel
  • 51
  • 1
  • 3
5
votes
1 answer

Read merged cells PhPExcel

I'm trying to read a merged cell in phpexcel, my problem is that the cell is merged on A:B:C:D:E:F ( can't argue with what they want ) $i= 0; foreach ($worksheet->getRowIterator() as $row) { if ($i > 10) break ; $i ++; $cellIterator =…
Seyes Radhouene
  • 143
  • 1
  • 10
4
votes
2 answers

Excel Total Hours Calculation using PHPExcel in HH:MM format with HH greater than 24 hours

I want to plot total hours in Excel using PHPExcel which is not subjected only to 24 hour format i.e. there can be hours which is greater than 24 hours eg. 49:20. Currently I'm able to plot and display hours below 24 hours format. As well as display…
Mudassir Khan
  • 318
  • 1
  • 11
4
votes
1 answer

PHPexcel get highest sheet index range

I am using PHPExcel for import data from excel file. but I find some problems where the data was dynamically repeated per sheets and I wanted to take the last sheet to process. Is there any idea or method to get the highest sheet index ?
Mochamad Zaula
  • 63
  • 2
  • 7
4
votes
1 answer

Reading in formula results containing named ranges with PHPExcel

I'm working on a project where I need to export a spreadsheet, populate it manually and then import it again back in to the system. I'm using PHPExcel to do all the hard work. The spreadsheet is basically a set of questions which need answering.…
Adam Holmes
  • 1,783
  • 3
  • 20
  • 32
4
votes
1 answer

PHPExcel: HTML to Excel, writing remove the CSS in excel file

I want to export(force download) HTML(with CSS) to EXCEL sheet, for now I am using the PHPExcel library to perform this, it generate the excel file but remove the CSS (using inline with html tags), can anyone guide me, that how to keep CSS in excel…
Qazi
  • 5,015
  • 8
  • 42
  • 62
2
votes
1 answer

Reading large .xls file with PHP

At the moment I am doing a mass interface of files/data and some files are in XLS format, which I need to normalize them into csv (so basically, convert XLS to CSV files) The problem is that PHPExcel (and similar libraries) load the entire sheet…
Oliver M Grech
  • 3,071
  • 1
  • 21
  • 36
1
2 3
…
8 9