I used PhpExcel to write a Excel2007 file.
In cell F9, I used partial Vlookup and get value in column F (CalculatedValue), current sheet is 'draft', when I open Excel file, everything is ok.
Id #21474 | Release:
| Updated: Tue at 10:05 AM by duc152 | Created: Tue at 10:02 AM by duc152
When I use the Excel read 2007 and read in a file with a freeze pain in it, the output seems to move the pain.
$objPHPExcel = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $o...
Id #21471 | Release:
| Updated: Tue at 12:24 AM by menger | Created: Tue at 12:24 AM by menger
If i echo the variable consisting of the gethighestrow(), will it echo the last row no. given in the first column of the excel sheet when it is opened... Im asking this because in my case, the num...
Id #21469 | Release:
| Updated: Mon at 9:47 AM by akshebs | Created: Mon at 9:47 AM by akshebs
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: Oct 18 at 8:42 AM by akshebs | Created: Oct 17 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: Oct 15 at 4:34 PM by wiseloren | Created: Oct 15 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