PHP Library for reading Excel files
Questions tagged [phpexcelreader]
133 questions
0
votes
1 answer
How to load an Excel file using PHPExcel (Error with vml relationships)?
The question is simple : how to load this Excel workbook (http://wftda.com/stats/wftda-stats-book.xlsx) with PHP Excel without throwing any errors ?
I use the following code (which is more or less the mwe explained in the doc):
$inputFileType =…
Silverspur
- 891
- 1
- 12
- 33
0
votes
1 answer
PHPExcel Load Files More Than 15 seconds
I'm using PHPExcel version 1.7.9.
Here is my PHP code :
$temp_name = $_FILES['upload']['tmp_name'];
$fname = $_FILES['upload']['name'];
$transfer = move_uploaded_file($temp_name,TEMP_DIR.$fname);
$file_location =…
First Last
- 133
- 2
- 10
0
votes
2 answers
PHPExcel files doesn't load
i need to read from excel file using php, the problem is these two lines:
require 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';
//Rest of code
Once I add these lines my code blocks , i'm sure the path is ok , i tried…
Safaa Jebari
- 1
- 2
0
votes
1 answer
PHPExcel Reader Exception throwing
I'm trying to load an excel file to be read with PHPExcel reader object:
$inputFileName = $_FILES['excelimportfile']['tmp_name'];
//Read your Excel workbook
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
…
edam
- 910
- 10
- 29
0
votes
1 answer
PHPExcel suddenly doesnt work
my code was working before but suddenly today its not working after i change some inputs...and the worst is its not downloading anymore after i click the submit button to execute the phpexcel code...and it will only direct open to dreamweaver and…
xplody
- 103
- 1
- 13
0
votes
0 answers
Read Excel file with PHPExcel in php
Hi i am using PHPExcel to import contact in mysql from Excel files.
Up until today everything was fine ,when one client wanted to upload excel file.
I am using this code to read the excel file :
$filetype =…
user3241849
- 23
- 7
-1
votes
1 answer
How to get the font name of the excel cell
I am iterating all cells of the excel sheet and printing out the values. Same time i also want to print the font name they are using. Is there any function to get the specific cell font name in phpexcel ? Thanks.
below is the code snippet
…
Abhigyan
- 641
- 10
- 25
-1
votes
1 answer
`Allowed memory size exhausted` error when reading large excel file
I'm trying to read a large excel file using PHPExcel library. Even though I included these:
ini_set('memory_limit', '1024M');
ini_set('max_execution_time', '300');
but I'm still getting this error:
Fatal error: Allowed memory size of 1073741824…
Priya
- 1
- 3
-1
votes
1 answer
Why PHP Excel reader output one more day from CSV?
I am using excel/reader.php to read the CSV file and get the data.
The date field in CSV have value: 20/10/2014
Customer Name Date
Lorem Spem 20/10/14
and when I print this after reading the CSV using PHP:
$file_name =…
Braham Dev Yadav
- 363
- 1
- 4
- 13
-1
votes
1 answer
Hello everyone, in phpexcel with floating point
in phpexcel problem with floating point, I'm from Russia, we decided to share bits of places, to do so would have been a comma or a point depending on the country 99,667 or 99.667
$sheet->setCellValueByColumnAndRow(
$i + 1,
…
Ivan Smorodin
- 151
- 3
- 14
-2
votes
1 answer
PHPExcel xlsx file into array ....Reader_Exception: Could not open
1.8.0"
the goal of my web application is to have a button that the user clicks on.
The code behind will start to scan all the folders that are in the main rdv folder.
in the rdv folder it contains three folders named 1000, 1001, 1002 these contain…
MI7QC
- 1
- 1
-2
votes
1 answer
What's wrong with this xls?
When I open this xls with Microsoft Excel the next message appears: "The file format and extension of "proof.xls" do not match. The file could be corrupted or unsafe. Unless you trust its source, do not open it. Do you want to open it anyway?".…
JBoY
- 51
- 3
- 13
-2
votes
3 answers
PHP read large excel file error
I'm trying to create a application for load and read a large excel file (more than 60,000 rows) using PHPExcel library. I am getting internal server. It works fine upto 600 rows. But its not working for large files. Please help.
Or any other php…
pearl
- 41
- 5