I was trying to use getHighestRow() to get the last row of my excel sheet but it appears to pick up some row slightly above it. Is there a limit to the no. of rows this command can browse....
Id #21462 | Release:
| Updated: Sat at 8:42 AM by akshebs | Created: Fri at 5:12 PM by akshebs
At the very least for number format, but I think for a number of the other formats. The no impact formatting is not working properly.
(See https://phpexcel.codeplex.com/discussions/261155 for not...
Id #21454 | Release:
| Updated: Wed at 4:34 PM by wiseloren | Created: Wed at 4:28 PM by wiseloren
I am using php-excel library for multipurpose use .
I am reading xls file using below code
$objPHPExcel = new PHPExcel();
$objReader = PHPExcel_IOFactory::createReader('Excel5');
Id #21450 | Release:
| Updated: Oct 14 at 9:29 AM by alpeshkasodariya | Created: Oct 14 at 5:04 AM by alpeshkasodariya
i am trying to get the last row that contains data in an excel workbook the problem is in some sheets i get the correct data but in other sheets i don't , i tried to change my code by using getHigh...
Id #21415 | Release:
| Updated: Oct 6 at 8:11 AM by amashety | Created: Oct 6 at 8:11 AM by amashety
I've found an error evaluating a formula: VLOOKUP($E$4;$korslistor.$B$36:$P$54;H9;0)
I'm referencing a range in the sheet 'korslistor' as $korslistor.$B$36:$P$54, so in Calculation.php line 3327
Id #21409 | Release:
| Updated: Oct 3 at 7:24 AM by MarkBaker | Created: Oct 2 at 1:28 PM by Angelon
I calculate the sum for a column, all okay, except the sum always equals 0. When I select the "Enable Editing" button the accurate value is displayed.
Id #21388 | Release:
| Updated: Sep 26 at 5:21 PM by tewhite0723 | Created: Sep 26 at 5:21 PM by tewhite0723
When I try to run the example：Examples/07reader.php, it always gets this error.
The special thing of myself is that my test site is not using default port 80, but use 8010.
Id #21363 | Release:
| Updated: Sep 22 at 1:29 PM by ch_feng | Created: Sep 22 at 1:29 PM by ch_feng
I have the following code:
$output = $objOutputExcel->getActiveSheet();
$template = $objTemplateExcel->getActiveSheet();
Id #21346 | Release:
| Updated: Sep 19 at 6:29 PM by Fluffydough | Created: Sep 19 at 6:22 PM by Fluffydough
I compared PHPExcel's CHIDIST output with that of other online applications and PHP code:
Id #21291 | Release:
| Updated: Sep 10 at 10:11 AM by MarkBaker | Created: Sep 10 at 9:28 AM by oferu
So I have a table with the following format:
A "row" of data is merged three rows in A, B and D while C is divided into three rows (A is name, B is ID, C is the three components, D is the date).
Id #21281 | Release:
| Updated: Sep 9 at 2:14 AM by phponrails | Created: Sep 9 at 2:14 AM by phponrails