#10 ParseXL version 1.10

open
nobody
None
5
2014-03-10
2006-04-08
canyoncasa
No

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).

Discussion

  • canyoncasa
    canyoncasa
    2006-04-08

     
    Attachments
  • 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') {