Stack Overflow
Stack Overflow

Questions tagged [phpexcelreader]

PHP Library for reading Excel files

133 questions
1
vote
1 answer

how to get the values separatedly when multiple column value are stored in a row of excel in php

This is my excel sheet from where m trying to get the L and M column but only the second value in my case the values are L6= 3.74 and M6= 457.27 This is my current code $sheet = $objPHPExcel->getSheet(); $highestRow = $sheet->getHighestRow(); for…
Monika Nishad
  • 181
  • 8
1
vote
0 answers

Split a large Excel file into multiples files using PHP

I'm trying to split an Excel into multiple files like in this Github code My data has been split, but in all files it has the same information and not CHUNK ONE: LINE 1 - 1000 CHUNK TWO: LINE 1001 - 2000, someone can help me? Below is my code: …
Guilherme Prado
  • 31
  • 10
1
vote
0 answers

insert batch multiple table Codeigniter in multiple table database with spreadsheet_excel_reader

have a great day with your code. Today I'm stuck with spreadsheet_excel_reader and insert_batch() when your upload file xls and automatic insert into two database say table_one and table_two with the same file xls, and how to get different insert to…
muhammad toha
  • 23
  • 3
1
vote
1 answer

spreadsheet excel reader not reading sheet if it has data on row 65536

I am trying to read spreadsheet(.xls) using spreadsheet_excel_reader. My code is a below : setOutputEncoding('CP1251'); $data->read('test.xls'); echo…
Harjeet Jadeja
  • 1,594
  • 4
  • 19
  • 39
1
vote
1 answer

Search and fetch record from xlsx file in php

I have an Excel file with .xlsx extension containing record of about 150000 (17 MB). Excel file is having (name, place, pincode) columns. I want to search file with pincode and retrieve a that specific row which matches my pincode. I have tried…
vivek321
  • 169
  • 3
  • 18
1
vote
1 answer

How to check the condition using xls file in php

Here i am using xls file reader in php it is working fine,i have make one logic,xls file i am geting the badge number(4565) and month(01-2017) now i want check the if the badge number and month already data exist or not , suppose data is exixts…
subikshan M
  • 263
  • 6
  • 17
1
vote
3 answers

php spreadsheet excel reader returning anonymous values

I am using php spreadsheet excel reader to read a excel file and do some manipulation. It was working fine and suddenly started to return value 'General' in case of integer columns Sample rows from excel: Code: $dataFields =…
abhinsit
  • 3,214
  • 4
  • 21
  • 26
1
vote
2 answers

Unable to read excel file by using phpExcel on server

Hello i am using phpexcel reader to read xlsx content on my server IE go-daddy. I tried the very attached code locally and its working very fine. But on server its showing blank output with no errors. set_include_path(get_include_path() .…
santoshu
  • 51
  • 6
1
vote
1 answer

Convert excel xlsx to xsl in php for php-excel-reader

I have to code a PHP platform for importing an Excel file (quite heavy) to fill an SQL server database. To do so I used the library PHP-excel-reader (https://code.google.com/archive/p/php-excel-reader/downloads) to be able recover the value of…
Jonathan Moy
  • 319
  • 3
  • 9
1
vote
0 answers

excel_reader2.php - Parse error: syntax error, unexpected 'new' (T_NEW) in /includes/excel_reader2.php on line 916

I am trying to access an excel file with excel_reader2.php include. But I get this error: Parse error: syntax error, unexpected 'new' (T_NEW) in >/home/user/public_html/includes/excel_reader2.php on line 916 This is line 916: function…
idoen
  • 53
  • 1
  • 8
1
vote
1 answer

Excel to PHP - MYSQL

Below data is in Excel file , i need that value(23,34..etc) should be output when any one select that resp data from drop-down(PHP File) In excel: Update Excel file : Link for Excel file : ------------------------------|------------------ …
user3209031
  • 837
  • 1
  • 14
  • 38
1
vote
2 answers

i want to get data from php file with ajax once per 5 min

I'm get data from excel file with php.After this data get from php file with ajax.In fact, I want to get data from excel file once per 5 min and print page.How can i do? data.php include "Classes/PHPExcel/IOFactory.php"; try { …
Harun Keleşoğlu
  • 9
  • 1
  • 10
1
vote
0 answers

"Undefined index:" when trying to load .xlsx file using PHPExcel

I'm trying to import an .xlsx file into my app. So far it went well with simple files but now I have a complex (formulas, images, charts etc) file and it throws me "Undefined index:" with error in Excel2007.php at line…
Alexandru Coman
  • 165
  • 1
  • 14
1
vote
1 answer

PhpExcel on Google App Engine Error: Invalid or uninitialized Zip object

I am trying to parse an XLSX file with PhpExcel on Google App Engine. When I run the script it gives me this error: Invalid or uninitialized Zip object. I've read other questions but they don't seem to help ( PHPExcel Google App Engine not saving…
Ren
  • 431
  • 6
  • 15
1
vote
1 answer

Using PHPexcel reader convert int value to datetime and print it correctly

require_once 'PHPExcel.php'; require_once 'PHPExcel/IOFactory.php'; //Values $path = getcwd(); $latest_ctime = 0; $latest_filename = ''; $d = dir($path); while (false !== ($entry = $d->read())) { …
Pramod S
  • 94
  • 11
1 2
3
…
8 9