PHPExcel: How to set the date format for a cell

I need to save a date to Excel file, it must be output in format "dd/mm/yyyy" (or the local date format of the user), and to be treated as a date so a column of them could be sorted correctly. Here is the code: <?php include_once("../PHP

Read only one line of a large Excel file with PHPExcel

I'm using PHPExcel library to read data from Excel files. My file is about 5mb, 70 columns and 20000 rows big. The code for loading the file is: $sheetnames = array('Classification'); $excelFile = Yii::app()->basePath . '/categories/'. $region .'.xls

PHPExcel multiple foreach loops

I want to display all the rows from a table with the corresponding column names above, which works. The problem is that it removes the first row from the results below the column names. It's as if the column row is somehow counted as a row in the whi

PHPExcel Load the image of the external URL

Does anyone know how to make setPath() method able to load an image from outside server? Because all images is store on other server.I don't have any idea how to do that. Please help me. thanks <pre> $objDrawing = new PHPExcel_Worksheet_Drawing(); $

How to optimize my query to get results faster?

I am scanning the words on many web pages and then store them in MySQL db. I have three tables: words: (wordid, word) pages: (pageid, page) map: (wordid, pageid, freq) freq field is for holding occurences of a word in a page. Then using PHPExcel, I a

PHPExcel breaks the page in wordpress

I'm trying to use the library PHPExcel inside wordpress. I created a class to parse the csv file, but just call the method to read the file PHPExcel_IOFactory::load($file) or even to identify the file, page breaks. The problem is that I do not get an

Integrate PHPExcel into Zend Framework 2

Using composer I have downloaded the PHPExcel class. The directory structure is codeplex +-phpexcel +-PHPExcel now I am confuse how to enable PHPExcel class in application.config.php OR should i remove the extra folder structure? I know it's a basic

PHPExcel setAutoSize for merged cells

Code without merge $objPHPExcel = new PHPExcel(); $sheet = $objPHPExcel->getActiveSheet(); $sheet->setCellValueByColumnAndRow(0, 1, "test test test test test test test test"); $sheet->getColumnDimension('A')->setAutoSize(true); $objW

Class 'PHPExcel_IOFactory' Not Found - CakePHP & amp; PHPExcel

Background I have issues using PHPExcel's IOFactory in my app. My PHPExcel helper works if I want to generate an excel document from scratch (my app creates about 20 excel sheets per week, with no issues). Why do you need It? I need to now combine so

put footer in all pages printed using phpexcel

What I want to achieve: I am currently using PHPExcel and I want to display the filename and the page numbers in all the right hand side footer of all the printed pages. Basically the format should be filename.xlsx Page 1 / 2 where filename.xlsx is t

reading the xls date in php

I'm using php-excel-reader to read an XLS file in my php script, everything is working fine, except for reading a date. It simply return an undefined object. The XLS file isn't made on my computer and I don't know with witch version it was created. I

getHighestColumn in xlsx does not work

Have this code, using PHPExcel public function getHighestColumn() { return $this->objPHPExcel->setActiveSheetIndex(0)->getHighestColumn(); } public function getHighestRow() { return $this->objPHPExcel->setActiveSheetIndex(0)->getHighestR

PHPExcel: Automatically download and open an Excel file

i have managed to create and save an excel file: // Rename the file $fileName = URL . "MODEL/case" . $caseNO . ".xlsx"; // Write the file $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType); $objWriter->save($file

phpexcel - use it with an excel template (missing graphic) php

I have tried to use phpexcel with my own template file. phpexcel loads the file and writes data to some cells A2, A3, A4 for example.. and opens an output file with the new data. my template file has chart built-in.. all i want to phpexcel to do is t

Import an Excel file into a MySQL table with PHPExcel

Ok so I have been able to get php to show the data in excel .xls sheet but this same data I wanna be able to insert into my table. I can't seem to figure that part out, here's what I got so far: $path = $_GET['file']; include("../class/sql.php")

PHP & mdash; Directory installation

I want to play with excel sheet in PHP. So i found out PHPExcel provides that option. But i am having a problem in setting up of the PHPExcel in my directory. It says: Extract and copy Classes to your includes/libraries directory. On your script, the

PHPExcel save the file to a folder or open Excel

I am using PHPExcel to export data from my PHP page to Excel. I am using Excel5. I want the excel file to be be saved a particular folder that is specified in the code OR better still, I want Excel to open with the data written in it so that user can

php_zip does not exist in php 5.3.5

I'm in the process of using PHPExcel. One of the requirements is that I need to enable php_zip. (...) if you need PHPExcel to handle .xlsx or .ods files you will need the zip extension... I'm using PHP v5.3.5. and in my php.ini file, I have the follo

PHPExcel integration into Zend Framework

how can I integrate the PHPExcel into my Zend app. My actual folder structure is the following: /application controllers views etc... /library My Zend PHPExcel /public index.php I already include 'My' libs by using (in index.php): require_once 'Zend/