[phpexcel] Forum Topics

Hello, Recently I am using phpexcel and afer many tries I wasn't able to find out how to make a document with a image in its header. Here is a simplified code that I am using. Can someone helps me with this issue?! <?php require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); …

I cannot find anything in phpExcel documentation. What I would like is to end up with an associative array with keys from the first row in the excel worksheet. It's something that can be done of course, but is there a native method?

Hi Everyone! Can anybody point me to the right direction or check what am i doing wrong. Im trying to export data from php to excel using phpexcel( which is working fine if im am only getting 1 specific record). but when i tried adding a loop to create a …

Hello, I am working on PHPExcel But in there calculation 0.625 we want to coming by dynamical from database. bellow brief description. They all used to be 62.5% of the delivery fees as seen below: `setCellValue('G'.($start_row+2), (($total_delivery/11)*10)*0.625);` all the drivers can have different percentages assigned to them and we need …

I'm not sure I undestand the second dimension of the three dimensional array that I created in `$rowData`. `test.xlsx` contains 3 row and 2 columns of string values. Also `count($rowData)` returns 12, not 6. <?php // Include PHPExcel_IOFactory include '../PHPExcel/Classes/PHPExcel/IOFactory.php'; $inputFileName = 'c:\DOCS\test.xlsx'; // Read your Excel workbook try { …

Been trying to loop through worksheets in an excel document. And remove "," in columns. Then save result in same excel document. <?php include'../Classes/PHPExcel.php'; include'../Classes/PHPExcel/IOFactory.php'; $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objReader->setReadDataOnly(false); //$xlsxfiles=$_SESSION['file']; //echo $xlsxfiles; $objPHPExcel = $objReader->load('../upload/Test_0.xlsx'); $num=$objPHPExcel->getSheetCount() ; $sheetnames=$objPHPExcel->getSheetNames() ; $objWorksheet = $objPHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); $sheetnum=$num-1; for($sl=0;$sl<$sheetnum;$sl++) { for($cl=0;$cl<$highestRow;$cl++){ $clean= …

Hi, I need to get a cell values and to print that cell values in another cell using PHPExcel? For Ex: A12:5 . I need this same value "5" to be printed in the cell B12. thanks for your help.