Stack Overflow
Stack Overflow

Questions tagged [phpexcelreader]

PHP Library for reading Excel files

133 questions
0
votes
0 answers

Displaying "ZipArchive Object" Message in php Codeigniter

I am working on a project in which i need to import data from excelsheet to database. When i execute a excelsheet it works fine and the data from the excelsheetis sucessfully imported into the table of database, but a message is dispalyed at the…
Vikas Kumar Thakur
  • 19
  • 5
0
votes
1 answer

PHPExcel - Set cells as string while uploading from Array

$objPHPExcel->getActiveSheet()->fromArray($dataArray,null,"A2") I've the above line of code. The problem is, I am not good at iterating and I want all the cell values to be set as STRING so as to avoid automated modifications of texts leading…
user4349925
0
votes
1 answer

Reading empty cells as data cells

I am reading an Excel file where sometimes PHPExcel codeplex considers an empty cell as a value cell. For example: If my Excel has 128 Columns, the maximum is DV sometime it will vary depend upon Excel and users requirement. Maximum is 126 columns.…
Jonathan John
  • 195
  • 2
  • 4
  • 12
0
votes
1 answer

How find the specific file path for an excel file with PHPExcel and HTML input file?

I have an HTML input file type "button" and when I choose a file I can only get the name of the file and cannot get the full path which seems to be required from PHPExcel to be able to read the mentioned file, how could I make this work as the…
rodzun
  • 157
  • 2
  • 3
  • 7
0
votes
1 answer

PHPExcel: how to get hidden cell values / Scientific Number in Number?

In PHPExcel is there any format available to get proper reading of the order item value as shown in picture. I read whole the document but not find any solution for this problem. For the date filled also if the data is shown ###### like way then…
Emma Miller
  • 39
  • 8
0
votes
1 answer

how to speed up PHPExcel reader

HI all expert i am newbie in php. can anyone tell me to speed up PHPExcel and this is my code ,it read 20000 rows with 4 columns . it take more than 15s. thank you so much function upload_fl($FILES){ $file = $FILES['excel']; //echo…
chea sotheara
  • 171
  • 2
  • 12
0
votes
1 answer

How to handle Norwegian / Swedish characters in PHPExcel (Getting ? mark in place of special character)

I have a issue when trying to export data from database to excel using PHPExcel. The issue is when there is some norwegian characters in the string. Firstly when I tried entering the data directly, all the the letetrs after the norwegian characters…
Anand Garg
  • 124
  • 1
  • 8
0
votes
2 answers

Search a cell by string in PHPExcel

I want to know if it's possible to get a cell by its name in an xls document, I mean Ii have this info in a excel file: Normally to get the coordinate of the cell with the value "ASUS" $objPHPExcel->getActiveSheet()->getCell('B3')->getValue();…
Juan Castillo
  • 103
  • 2
  • 9
0
votes
1 answer

All cells like strings PHP Excel

I'm trying to read some data from excel file. Everything is good if i have ex.50.44% in my excel cell PHP excel format it like float 0.0531 i dont want to format any numbers and i want all cell to be casted as string. How can i accomplish this…
mstojanov
  • 175
  • 4
  • 17
0
votes
1 answer

PHPExcel Display Charts not working

I am trying to display an Excel File generated using PHPExcel on a webpage. The image consists of a bar graph. I try to display it using $objPHPExcel = new PHPExcel (); $objWorksheet = $objPHPExcel->getActiveSheet (); $objWorksheet->fromArray (…
Anand C U
  • 885
  • 9
  • 29
0
votes
0 answers

Php excel generation and download at client or browser side

I am using PHPExcel.php and /PHPExcel/Writer/Excel2007.php in my application , in my code: $objPHPExcel = new PHPExcel(); //adding values to cells $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('b'.$position,'Total') $objWriter =…
Shekkar
  • 244
  • 3
  • 10
  • 21
0
votes
0 answers

PHP : Read Timeout error

I am facing a read timeout problem from couple of days. There is a facility to upload users in my application (Xls,xlsx are allowed extensions). This is completely admin panel. I am using PHPExcel for reading the data from the sheet and inserting…
Shilpa
  • 21
  • 4
0
votes
0 answers

PHPExcel rangeToArray get only cell values (not formulas)

How do a use rangeToArray in PHPExcel when the cells contains formulas? It returns me the error: Fatal error: Uncaught exception 'PHPExcel_Calculation_Exception' with message 'E-mail!C3 -> E-mail!C3 -> Formula Error: An unexpected error occured' in…
Erick Skrobot
  • 189
  • 4
  • 22
0
votes
0 answers

PHPExcel - Avoid storing empty cells in database after import

I'm fairly new to PHPExcel and was wondering if you would be able to assist me with the code below. Exporting with PHPExcel works perfectly, but when I am importing a xls or xlsx document, it stores the content of the sheet (which is what i want)…
Boeta
  • 5
  • 7
0
votes
1 answer

PHPExcel getHighestDataRow() is not working with .xlsx file

I am trying to get the last row that contains data in an excel workbook. I've used the function getHighestDataRow() like other advices I got from the internet. But it only work for .xls file. When I save the file to .xlsx format, the function return…
Jasmine
  • 13
  • 1
  • 5
1 2 3
…
8 9