Based on my previous "code overhall" this code patch
implements limited support for user-defined named
cells, created in Excel using Insert|Name|Define.
It allso decodes formulas and provides results and
formula tokens array. (Excel uses RPN tokens to store
formulas, which will take a lot of code to decode the
actual formula - left to the end user if desired).
Logged In: NO
i keep getting the following error when i run the demo php file...
ParseXL Version: ParseXL:1.10 [PHP 5.x]
Notice: Uninitialized string offset: -512 in /Library/WebServer/Documents/parsexl/Excel/oleread.inc on line 27
The examples work well - thank you so much!! This is the only excel reader that actually works!! But I did have trouble with my own spreadsheets and I found a solution:
line 203 of oleread.php
change
if ($name == "Root Entry") {
to
if ($name == "Root Entry" || $name == 'R') {