Stack Overflow
Stack Overflow

Questions tagged [phpexcelreader]

PHP Library for reading Excel files

133 questions
1
vote
1 answer

PHPExcel - Populate data from Array

I have so far successfully exported data from Mysql into Excel via PHPExcel, made my tables, formatted, and everything is hunky dory. However, so far any attempt at making graphs from said tables failed miserably. Not only, after days on end of…
user3375601
  • 119
  • 2
  • 9
1
vote
0 answers

How to generate xml using PHPExcel

I am using PHPEXcel library to convert Excel files (.xls, .xlsx) to XML. I have written below code to convert Excel file to arrays. but finding issues with how to convert that array in XML format.
Adoshi
  • 33
  • 6
1
vote
1 answer

PHPExcel not recalulating and shows always the same value

I am on a project and I am reading values from an excel document. When using the getCalculatedValue function it does always return the same value. I tried the getOldCalculatedValue function without success. I read somewhere that it will be helpful…
Demetris
  • 11
  • 2
1
vote
0 answers

Could not open file for reading! File does not exist using Symfony and PHPExcel

I have to insert data of the excel file in MySql table which can be selected from a location and I am using Symfony, PHPExcel and Ajax for this. I have created a file upload button in table. I click on choose files, select the file and click on…
Mukesh Joshi
  • 2,784
  • 4
  • 24
  • 34
1
vote
0 answers

PHPExcelReader files doesn't load

I am using PHPExcelReader to read an Excel sheet. Here is my code.
Rose18
  • 2,892
  • 8
  • 47
  • 98
1
vote
0 answers

last character is missing from every single cell value in import file using php-excel-reader

I am using php-excel-reader library for import data from xls file. I am exporting xls file from CRM and when I upload it to server for import data php-excel-reader read every single cell value but I am not getting last character of…
Ghanshyam Katriya
  • 1,071
  • 1
  • 11
  • 37
1
vote
1 answer

PHPExcel file Uploader

When i trying to upload temp.xlsx in PHPExcel script it will return an error like Fatal error: Class 'PHPExcel_Shared_String' not found in /home/demo/public_html/include/Classes/PHPExcel/Autoloader.php on line 36 on my server. But when i run same…
Bhavik Chudasama
  • 53
  • 1
  • 9
1
vote
0 answers

PHPExcel Read Styles, Formulas, and Filters to Recreate existing Excel File

I have an Excel file which uses the default tables in Excel to create a variety of styles including row striping (conditional formatting), filters, and cell styles. I would like to be able to duplicate this report (and several others) using…
Loren
  • 9,783
  • 4
  • 39
  • 49
1
vote
1 answer

Code Igniter : error in reading .xslx file (file is not readable)

------------------ error ----------------------------- The filename ./upload/1407500591-CI1.xlsx is not readable ------------------- details-------------------------- when I try to upload file, it uploads in ./upload directory. but when I try to…
user3886556
  • 239
  • 3
  • 13
1
vote
0 answers

php-excel-reader How can I get a position of TextBox

Is there any way to get a position of TextBox of xls file via php-excel-reader? I need to get a text of that TextBox example image so for example I need "2a" but box "2a" is empty but there is a TextBox on it. So how can I get this value if I know…
Renat Magadiev
  • 31
  • 3
1
vote
2 answers

Return message if reading an empty file

I am using PHP Excel library. I want to show a error message to the user when user uploads an empty file for reading. I google'd for it but couldn't get relevant answer. When a new excel file is created it has a default filesize of 9KB in windows. I…
VishwaKumar
  • 3,433
  • 8
  • 44
  • 72
1
vote
0 answers

PHPExcel - Get cell value from another sheet

I've been debugging for hours, and cannot seem to figure out the problem. $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcelReader = $objReader->load($inputFileName); …
JCastell
  • 1,135
  • 1
  • 10
  • 11
1
vote
1 answer

PHPExcel cache error

When I enable the cache options to improve memory usage: $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp; $cacheSettings = array( 'memoryCacheSize' => '32MB'); PHPExcel_Settings::setCacheStorageMethod($cacheMethod,…
xmarston
  • 853
  • 3
  • 12
  • 36
1
vote
0 answers

phpexcel showing zero rows even when 150 rows are present in the excel file

I am using PHPexcelReader for importing excel files.everything is working fine when maxcol value i give as 92 but when the maxcolvalue is 206,the numver of rows of excel file is showing 0 even when there are 150 rows. $maxcols=206 echo…
R R
  • 2,999
  • 2
  • 24
  • 42
0
votes
0 answers

Import excel file 2nd sheet into mysql

i want to import excel into mysql. I can import the data which is the file only have 1 sheet, my code was like : function import(){ if(isset($_FILES["file"]["name"])){ $path = $_FILES["file"]["tmp_name"]; $object =…
Belsazer Razer B
  • 21
  • 4
1 2 3
…
8 9