Stack Overflow
Stack Overflow

Questions tagged [phpexcel-1.8.0]

PHPExcel is an excel file generating library developed using PHP. PHPExcel-1.8.0 is the latest stable release with many fixes from the earlier 1.7.x version. The major fix is in the password protection update to support in new versions of MS Excel

It providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP

66 questions
1
vote
1 answer

Alternative for "PHPExcel_Cell_DataType::TYPE_STRING" in loop

I am creating an excel sheet using PHPExcel. As we need good optimization, I am avoiding the looping in its maximum. But I am not able to optimize the below code anymore. $activeSheet->fromArray($excel_rows, null,…
Arun
  • 3,640
  • 7
  • 44
  • 87
1
vote
1 answer

PhpSpreadsheet's COUNTIF Function php

I am working with PhpSpreadsheet(PHPExcel) to do an Excel in PHP and I got stuck when I needed to use COUNTIF. Here is my code: $spreadsheet->getActiveSheet()->setCellValueByColumnAndRow(59,5,"=COUNTIF(BH7:BH125,'<>0')"); //BH POSITION It doesn't…
ToniTJK
  • 181
  • 1
  • 3
  • 11
1
vote
1 answer

PHP excel weird characters

I'm using the basic phpexcel 01simple-download-xlsx.php as Is Didnt add any code of my own for now .. And I get unexpected results // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Set document properties …
lior r
  • 2,220
  • 7
  • 43
  • 80
1
vote
0 answers

PHPExcel in Zend2 doesn't work when use service locator

I'm trying to get a Excel book working with Zend Framework 2.4.11 and phpoffice/phpexcel 1.8.1. My controller code is like this: public function exportAction() { $phpExcel = new \PHPExcel(); $phpExcel->setActiveSheetIndex(0); …
Carles
  • 11
  • 1
1
vote
1 answer

How to validate whole column in phpexcel

I am working on the phpexcel to create excel sheet and i have to validate that sheet for some columns. I tried for the below code $objValidation = $objPHPExcel->getActiveSheet()->getCell('D1')->getDataValidation(); It gives me cell D1 validated but…
varad mayee
  • 619
  • 7
  • 19
1
vote
1 answer

PHPExcel getConditionalStyles() method returns empty array

I've applied a conditional formatting rule for column B in the excel sheet. When I'm trying to get the conditional styles of that particular cell, I get an empty array. I am using the below code to get the conditional styles. $conditionalStyles =…
dr_dev
  • 492
  • 3
  • 17
1
vote
2 answers

PHPExcel - format for the column

I need to set for all columns format: FORMAT_NUMBER I can do it for one cell. But I can not do for the whole column B. $objPHPExcel->getActiveSheet()->getStyle('B2')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER); How…
Dima Kuzmin
  • 161
  • 1
  • 2
  • 10
1
vote
0 answers

PHPExcel chart using logarithmic scale

Using PHPExcel 1.8.1 to create a chart. However I am not able to find the option to enable logarithmic scaling on said chart. These are the axis properties I have found…
lthrhx
  • 90
  • 1
  • 9
1
vote
0 answers

PHPexcel read date format float return

Im a bit rusty using PHP and new to PHPexcel. I read all the realted posts of PHP Excel and still have no clue on how to solve my problem. The problem is that im reading an excel spreadsheet and showing it on HTML format. The problem is that the…
Nicolas Pisetta
  • 11
  • 2
1
vote
1 answer

PHPExcel writing strange characters

I have a PHP file with a query in sqlsrv, runs well, generated an Excel file with either PHPExcel or without the library, the Excel file is generated either but in the next cell down after writing the results writes strange symbols like this:…
Ricardo Romero
  • 21
  • 7
1
vote
0 answers

How can i loop the data in the cell using PhpExcel and Codeigniter

It only shows one data in a single cell. But all i want is to loop it to display all the data in my database Here is a piece of my Code in Controller. function firstDebit(){ $series=$this->uri->segment(3);…
Irene
  • 137
  • 2
  • 14
1
vote
0 answers

Unable to write to ExcelSheet using PHPEXCEL1.8

I am trying to write data to an excel sheet that is already created and the values entered on the field will be stored on the excel sheet and i am using PHPExcel 1.8 but unable to write to EXCEL sheet. Here is the code : index.php
kurri sudarshan reddy
  • 103
  • 1
  • 5
0
votes
0 answers

Save File in PHPExcel

Is it posibble to save existing file with out creating the writer object in PHPExcel? $filename = 'test.xlsx'; $phpExcel = PHPExcel_IOFactory::load($filename); $phpExcel->save($filename);
junaid khalil
  • 1
0
votes
0 answers

How to export data in excel dynamically using PHPSpreadsheet/PHPExcel in PHP?

I have some data which I am trying to export in an excel sheet with help of PHP, data is dynamic so I am facing difficulties while exporting them. I have tried both in PHPExcel (which is deprecated) and in PHPSpreadsheet too. I have tried lots of…
Utsav Upadhyay
  • 415
  • 6
  • 21
0
votes
0 answers

Encoding problem in PHPExcel. Some encodings work, some don't work

I wrote the code, it works as intended. One of the significant problems is character encoding. At the moment in the result file I get: Our Mothers, Our Fathers Unsere M 'ü' tter, Unsere V 'ä' ter 2013 Drama, War In excel file I see only Special…
Radosław Gzyl
  • 1
  • 2
1
2
3 4 5