I've used this PHPExcel class for .xls files prior to this with success, but this time I've been running into issues. Now, I'm trying to load and read a .xlsx file and can't even get past the load(...
Id #21249 | Release:
| Updated: Today at 5:04 PM by MarkBaker | Created: Thu at 3:33 PM by mathiscab
When reading an EXCEL fiel and getting a cell value, with getValue(), or getFormattedValue()
If a cell has a value like
01908E1 the value i get is 19080
but this works 01919E
The excel file is fo...
Id #21248 | Release:
| Updated: Thu at 3:58 PM by knoseworthy | Created: Thu at 3:17 PM by knoseworthy
Was incorrect -- Mac Office 2008 does NOT allow for addition of color to tabs. It also does not recognize tab colors.
Id #21232 | Release:
| Updated: Sun at 7:06 AM by parkerhm | Created: Aug 15 at 9:26 PM by parkerhm
Bug was described here: https://phpexcel.codeplex.com/discussions/429322
Solved by editing file "phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel2007\Worksheet.php" (lines 1001:1004):
Id #21229 | Release:
| Updated: Aug 14 at 6:31 AM by jkonefal | Created: Aug 13 at 5:08 PM by jkonefal
I have a spreadsheet, created through PHPExcel using the .xls format.
When I load and save this spreadsheet as .xlsx, it duplicates the data in the shipping and billing address columns like so:
Id #21223 | Release:
| Updated: Aug 12 at 7:37 PM by glassdimly | Created: Aug 12 at 7:37 PM by glassdimly
I have Excel spreadsheet with column which cells have embed URL address. When I load this spreadsheet and display that address in browser I can see some strange characters on the end of URL. For ex...
Id #21221 | Release:
| Updated: Aug 13 at 8:27 AM by MarkBaker | Created: Aug 12 at 3:45 PM by ManOfHonor
According to Excel specifications, any cell marked as a subtotal should not be taken into account when performing an aggregation calculation over it. I have found that the latest version of PHPExce...
Id #21216 | Release:
| Updated: Aug 11 at 8:08 AM by boendagger | Created: Aug 11 at 8:08 AM by boendagger
So I have this template which has images. I use PHP copy to copy that template and use it as a new workbook. When I check the file, the images are still there. However, when I read the worksheet...
Id #21213 | Release:
| Updated: Aug 8 at 3:27 AM by phponrails | Created: Aug 8 at 3:27 AM by phponrails
I'm using PHPExcel to create some some charts, but the axis labels are always too big.
Is there a way to change the font size or other styling parameters for these labels?
This is the code t...
Id #21209 | Release:
| Updated: Aug 6 at 1:50 PM by Sami123 | Created: Aug 6 at 1:50 PM by Sami123
phpexcel returns 'Invalid cell coordinate PP' when load and save same excel file
same issue was found on 1.7.8 & 1.8.0
seems some issue with some parser
only happened on one excel file
Id #21192 | Release:
| Updated: Jul 31 at 12:47 PM by chenlebob | Created: Jul 31 at 12:47 PM by chenlebob