Stack Overflow
Stack Overflow

Questions tagged [phpexcelreader]

PHP Library for reading Excel files

133 questions
0
votes
1 answer

PHPExcel issue when loading file (that makes no sense)

So the following code: $csv_reader = PHPExcel_IOFactory::createReader("CSV"); $temp = rand(); echo $temp; echo "
"; $php_excel = $csv_reader->load("foo.csv"); echo $temp; Outputs this (as expected): 207192412 207192412 Whereas the following…
Kosta Kontos
  • 4,152
  • 7
  • 25
  • 28
0
votes
2 answers

How to apply styles in PHPExcel

I am working with PHPExcel & i want to give same style to some cells. I have tried below code, but it applies style to only A1. $objPHPExcel->getActiveSheet()->getStyle('A1','B2','B3','c4')->getAlignment()->setIndent(1);
SureshK
  • 123
  • 1
  • 4
  • 17
0
votes
2 answers

PHPExcel not working php 5.2 AppServ

I am using php 5.2.6 in AppServ on a Windows machine and PHPExcel does not seem to work and produces no errors. I have error_reporting set to E_ALL. On my Linux machine where I am using php 5.6 and using vagrant/homestead the same code works just…
Tyler
  • 3,713
  • 6
  • 37
  • 63
0
votes
1 answer

Import date from excel in php retuns wrong date

In my excel sheet the date is "12/15/2014". After i uploaded it into form the date returns "16/12/2014" in output form. how can i get actual results that's appear on excel sheet.
Rajkumar
  • 1
  • 2
0
votes
3 answers

PHPExcel detect if the cell value is formated to date or not

Good day guys i have a problem on how to detect if the cell value is formated to date or not when i been upload a date value i use this code $data = $objWorksheet->getCellByColumnAndRow($col, $row); when a cell value is formated into date the…
itsmecidz
  • 93
  • 1
  • 2
  • 15
0
votes
1 answer

Excel File parsing issue using PHPExcelReader

I am facing a peculiar problem in parsing an excel file (.xls) using PHPExcelReader which actually Spreadsheet_Excel_Reader class. I have used it so many times in different applications and every time I was fine. I am working for an app where there…
Mohaimen
  • 159
  • 1
  • 3
  • 12
0
votes
2 answers

Get the value from Excel Sheet as Date in PHP

I use PhpExcelReader-- include 'excel_reader.php'; // include the class // creates an object instance of the class, and read the excel file data $excel = new PhpExcelReader; Data Read and Function Call-- …
MuteX
  • 183
  • 1
  • 1
  • 13
0
votes
0 answers

PHP EXCEL multiple files and sheets

Before you answer. Please remember its xls and not csv. Plus data is multiple sheets and multiple columns. I have 50 Excel files in one folder. Data is in different columns. Info1 - Label a1 data b1 sheet1 Info2 - Label a2 data b2 sheet1 Info3 -…
Paul van Zyl
  • 33
  • 8
0
votes
1 answer

Read excel data Sheet by sheet using codeigniter and mysql and phpexcel

I am done with basic import to database. I have explained in the following example where I got stuck up ... For example, I have an xls file named project.xls and it has 6 sheets. I have populated all 6 sheet names in dropdown. If I select sheet2…
svl
  • 11
  • 1
  • 8
0
votes
1 answer

How to read the $_FILES['name']['tmp_name'] using jQuery

I'm making an application to import excel to database using excel_reader2.php. I created a form for uploading excel file and when the file that I want to upload selected, I want to read data boundsheet of the excel file. which become problems when I…
d'art
  • 87
  • 1
  • 9
0
votes
2 answers

codeigniter do_upload is missing argument 1 on ubuntu server

i have a question about codeigniter, why i have missing argument on do_upload excel file , on localhost it's work but after copy into linux server it have error like this : A PHP Error was encountered Severity: Warning Message: Missing argument 1…
Learn Again
  • 17
  • 1
  • 5
0
votes
2 answers

Convert HTML file to Excel using PHPExcel

I have required to convert html file (test.html) to excel in PHPExcel myhtml file text.html it is save test.php but containt of html please idea how to implement in this
Hiren Patel
  • 59
  • 1
  • 3
  • 9
0
votes
0 answers

PHPExcel ,double as string, from CSV to database

I want to load a CSV file to my Mysql database using PHPExcel, here is my code : $inputFileName = '/tmp/charges1.csv'; //PHPExcel_Cell::setValueBinder( new PHPExcel_Cell_MyValueBinder()); try { $inputFileType…
elarichi.y
  • 57
  • 8
0
votes
0 answers

Detect if cell is Currency format

I have a PHP application that parses Excel files. It reads every cell from Excel so given that it might read dates, int/number, currency, string, etc. Can I detect if the format of a currency cell? For example, I can detect the date as…
shanks
  • 75
  • 8
0
votes
1 answer

phpexcel Fatel Error when opening file

I am trying to open an excel file on my hard drive and getting. Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1032 bytes) in C:\WEB\Classes\PHPExcel\Cell.php on line 1228
jimneely
  • 39
  • 8
1 2 3
…
8
9