PHP Library for reading Excel files
Questions tagged [phpexcelreader]
133 questions
0
votes
1 answer
How to write php excel code in phpexcel format and print dynamic label?
I have a dynamic cell coming from a database. How can I print it into Phpexcel format?
$out_table = '';
$k=0;
mysql_data_seek($query_result1,0);
while($row1=mysql_fetch_array($query_result1,MYSQL_ASSOC)){
$out_table .= "
Utsaww
- 13
- 3
0
votes
0 answers
How to search and read excel file in php
I would like someone to help me find a solution to my two problems: I have an excel file with 2 columns (A and B)
Column A contains barcode numbers that I must assign to an order number (in column B). Below an example:
COLUMN…
Taibi Slaoui
- 11
- 2
0
votes
0 answers
mathematical symbols like α β γ δ are not getting upload in database using php excel_reader2
ISOLDE α β γ δ Randomised, double blind, placebo controlled study of fluticasone propionate in patients with moderate to severe chronic obstructive pulmonary disease: the ISOLDE trial Galiè N et al α β γ δ
0
votes
1 answer
Reading Images from Excel
I am using this PHP code : https://github.com/nuovo/spreadsheet-reader
I am able to successfully fetch data using the given examples. However, there are images in some cells which also need to be shown as HTML or saved on to file. How to read the…
Sunish Menon
- 152
- 11
0
votes
0 answers
How do you process large Excel files with phpexcel
When I try to read a large Excel file (106k rows, 24MB) my php script stops without any errors or warnings. I have drilled down to find out it halts at this specific statement:
$obj = PHPExcel_IOFactory::load($filename);
The manual shows no memory…
user1729972
- 712
- 2
- 9
- 29
0
votes
0 answers
Server is showing error message of Max_execution_time:
I want to import an Excel (CSV, XLX, XLSX) file to my phpmyadmin databases. The file is 50 MB having around 5 million records. The issue is that whenever I try to upload that file, around 900 000 records are successfully inserted, but after that…
0
votes
1 answer
PHPExcel: How to check if cell value is a function
like in the title when i read an excel file i want to know if cell contain a value or a function.
Is there a bool return method in PHPExcel like this?
$cell->getValue()->isFunction();
Thanks for the answers.
Alberto Favaro
- 1,824
- 3
- 21
- 46
0
votes
0 answers
Class 'PHPExcel' not found in Excel5.php error upon loading an excel file on PHP
What could be the cause of this error upon loading a program that would get the content of an excel file and display it on PHP.
Fatal error: Class 'PHPExcel' not found in
C:\xampp\htdocs\uploader\PHPExcel\Reader\Excel5.php on line 624
Below…
user3819290
- 43
- 5
0
votes
1 answer
read data from xlsx file using PHPExcel
This is My test.xlsx sheet, I want to take only B table data from this Xlsx Sheet Using PHPExcel. (Or any other way).
Please Give Some Suggestion about My Problem.
Thank You
prabha
- 43
- 9
0
votes
1 answer
CodeIgniter file Uploading Class, error with do_upload
I want to program the function to upload excel files to a sql db.
I have a problem, because the $this->upload->do_upload('file') don't execute and I cant figure out why.
Here is my Controller:
function import(){
$this->breadcrumbs[] = array(
…
Jannik Window
- 43
- 2
- 10
0
votes
2 answers
PHPExcel error when reading calculated value
I have a cell in an excel sheet that i am trying to read.
When I use the function getCalculatedValue it's throwing following error:
Financials!LU83 -> Financials!LU81 -> Formula Error: An unexpected error occured
I wrote following function to read…
vick
- 476
- 6
- 18
0
votes
1 answer
What are the purpose of three bool value in PHPExcel reader?
I'm using PHPExcel reader for read data from Exce file in my Yii2 application.
This is the code that I've used:
$objPHPExcel = new \PHPExcel();
$fileName = Yii::getAlias('@webroot/trash/trash_vatout/') . $name;
$inputFiles =…
Blackjack
- 1,016
- 1
- 20
- 51
0
votes
2 answers
check file extension in upload form using PHP
I have to check .xlsx file extension is valid or not. I have one test.docx for the validation purposes I change the file extension test.docx to test.xlsx. So I how can handle this. I am using PHP Excel.
sandip kakade
- 1,346
- 5
- 23
- 49
0
votes
1 answer
PHPExcel library get date
Using PHPExcel, I a trying to fetch data from Excel file and save it in MySql database using the following code:
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
$i=0;
$arr…
ITSagar
- 673
- 2
- 10
- 29
0
votes
2 answers
Loop through Object in PHP
I am trying to read each element of an Object array, the code reads values from an excel file and then assign the values to a variable.
for ($row = 1; $row <= $highestRow; ++ $row) {
$fname = $worksheet->getCellByColumnAndRow(0, $row);
…
DashD
- 83
- 1
- 1
- 11