PHP Library for reading Excel files
Questions tagged [phpexcelreader]
133 questions
0
votes
0 answers
Error While loading excel sheet Using phpexcel
I am trying to load excel sheet (generated by other application) using phpexcel library, with following code:
$objReader = new PHPExcel_Reader_Excel2007();
$objReader->setReadDataOnly(true);
$objPHPExcel =…
0
votes
1 answer
Can't import large file PHP excel
I'm trying to upload 10k+ data in my database (using PHP and Mysql). However the file seems to be too large. If I reduce the size of the file to about 9300 records it works just fine but above that my code seems to fail at the following line…
Bobby
- 496
- 5
- 18
0
votes
1 answer
PHPExcel unable to read file
I'm using CakePHP 3.2 and PHPExcel library to import data from excel sheet to database.
I have the library at
/vendor/PHPExcel/Classes/PHPExcel.php
/vendor/PHPExcel/Classes/PHPExcel/IOFactory.php
and the action in controller is
public function…
Anuj TBE
- 9,198
- 27
- 136
- 285
0
votes
2 answers
JavaScript xlsx file upload
How can i do xlsx file upload from web page to server ?
I have issue about read Excel file. I have a php code but i need upload file from web page to my server . Because if i dont upload it, I cannot read file.
this is my php code. In this code i…
Somomo1q
- 655
- 2
- 10
- 19
0
votes
0 answers
Cannot retrieve UTF-8 from excel file with PHPExcel
I'm trying to import a Excel file to my PHP application with PHPExcel but It cannot work correctly with UTF-8 data.
This is my data
Độc quyền
and this is what I retrieve:
Äá»™c quyá»n
This is my code:
$cell =…
Ruồi Trâu
- 91
- 2
- 10
0
votes
2 answers
How to convert the php excel read date to Y-m-d format?
strong text
nclude 'PHPExcel/IOFactory.php';
// This is the file path to be uploaded.
$inputFileName = 'admin/' . $_SESSION['file_name'];
try {
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
} catch (Exception $e) {
die('Error…
Rahul K Raj
- 1
- 2
0
votes
0 answers
Extend class CI_controller PHPExcel gives format error or invalid extension error
I am trying to export Excel using CodeIgniter with fillowing code give me bad output it was working fine few day ago but for now it gives me error
Jignesh Aakoliya
- 33
- 2
- 17
0
votes
0 answers
PHPExcel export as CSV with ISO-8859-1 encoding
I have a web page where I have some text boxes and then export button at the end. The function of this is to generate CSV of input data. This works well for an English language input but this creates some problem when I type German language…
Jaswinder Singh
- 53
- 1
- 7
0
votes
1 answer
PHPExcel Load error - Cell coordinate must be a range of cells
Good Afternoon All,
I am working on an issue in PHPExcel. Using the following code:
try {
$inputFileType = PHPExcel_IOFactory::identify($fileLocation);
$objReader =…
Paul Reilly
- 11
- 2
0
votes
1 answer
Memory while reading large Excel 2007 (.xlsx)
I'm using PHPExcel which I've used before many times. The problem I have now is when reading Excel2007 files (.xlsx - format). What I'm doing is simply looping the the .xlsx file and creating an array by row/column and then print_r()-ing the results…
Jordan Davis
- 1,485
- 7
- 21
- 40
0
votes
0 answers
It seems to be generating a file, then "internal server error" when generating an .xls
I do not know much about this, then I would appreciate if you help.
I'm trying to generate xls more than 2205 rows.
on my localhost, it takes 6 minutes to create the file. on my server after 2 minutes an error.
in my localhost it works fine, but…
user5115790
0
votes
1 answer
Read excel with PHPExcel dependent on another file
I started working with PHPExcel to read a file.
In my first steps, I would get a portion of the file because there is another that is not of my usefulness. I saw that the rangeToArray function was useful for this.
Just as a test, I tried to obtain…
urreta17
- 183
- 4
- 20
0
votes
0 answers
how unprotect excel file while load it with PHPExcel
i have excel file downloaded from web and its protected.
if i open that file and disable protection PHPExcel_IOFactory::load can open it
but there is anyway to PHPExcel unprotect file itself?
because i want my php code to download it automatically…
user1772630
- 36
- 7
0
votes
1 answer
Differences between PHPExcel and PHPExcelReader
I'm on a project in my work where I have intended to read data from an .xls file.
I have seen the existence of some libraries, but it has generated some doubts.
For example: PHPExcel and PHPExcelReader, are they the same?
I have not found much…
urreta17
- 183
- 4
- 20
0
votes
1 answer
I am trying to import a csv file and save the data into the database. I got everything working except the data on column A is missing leading Zeroes
$objReader = PHPExcel_IOFactory::createReader('CSV');
$objPHPExcel = $objReader->load($fileName);
$worksheet = $objPHPExcel->getActiveSheet();
$rowCount = 0;
foreach ($worksheet->getRowIterator() as $row) {
if ($rowCount != 0){
…
phpNoobie
- 1
- 1