Menu

#2 Excel file is unreadable

open
nobody
None
5
2001-09-25
2001-09-25
Anonymous
No

Using enclosed example file test.phtml, created a new
excel file. File is created and downloads correctly.
When I open it in Excel 2001, it complains that the file
format is unrecognized, then tries to open it anyway.
The data is jumbled around, and not in the order you
might expect. There are also some garbage characters in
the data.

Discussion

  • Nobody/Anonymous

    Logged In: NO

    sorry, forgot to add my email: waltd@wdstudio.com

     
  • Thomas Schmidt

    Thomas Schmidt - 2001-11-11

    Logged In: YES
    user_id=167832

    In my case Excel (XP) does not even open the file - but it
    makes three tries to read it (what is going on my mind as
    it pops up three error messages *g*). Anyway, good work
    and hope this will continue.

     
  • Chris

    Chris - 2001-11-22

    Logged In: YES
    user_id=383074

    I had this problems too. I tried this php-scripts on unix-
    and nt-servers. most of them created a readable xls-file
    without problems (PHP Version 4.0.4pl1 and PHP Version
    4.0.1pl2 used) but the one with php-version 4.0.6 created
    not an readable and correct xls-file for excel 2000. shown
    only with garbage characters. could this be the problem?

     
  • Nobody/Anonymous

    Logged In: NO

    I too have an unreadable file.

    I am using the psxlsgen-0.3b.tgz file on a Red Hat 6.1 system with php 4.06. It created the file from a psql database into /tmp/test3.xls. I down loaded the file onto my WinME system and tried to open it with Excel 97 SR-1. Excel claimed the file was unreadable.

    What versions of excel and on what operating systems does this work with?

    hkatz93@yahoo.com

     
  • Nobody/Anonymous

    Logged In: NO

    I had this problem too but I resolved it.
    In fact the way computer codes the integer depends on the machine.
    To avoid this replace all the "sssss" in the pack functions by "vvvvv".

     
  • Nobody/Anonymous

    Logged In: NO

    Seems this project is dead for some time. Saved XLS files
    are unreadable for everyone I guess.

     
  • Nobody/Anonymous

    Logged In: NO

    This is a piece of shit!
    I just wasted time!!!

     
  • Nobody/Anonymous

    Logged In: NO

    duplicate functions sendfile() and savefile() i've fixed
    this but the file is not readeble , i've get 3 pop-up
    messages that the file could not be readed
    amihai[aat]tol[doot]ro

     

Log in to post a comment.