Thread: XLS

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 1999
    Location
    Ramos Mejia, Buenos Aires, Argentina
    Posts
    20
    Rep Power
    0
    Does anyone know if there is a function to create simple XLS files from php3?

    Thanks in advance!
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    61
    http://www.php.net/manual/ref.com.php

    This is really more of a question about invoking Microsoft COM objects, and it only works using PHP on a Windows server, so to actually create the XLS file, you should go to msdn.microsoft.com for more info.

    However, a simple way around this is just to use PHP to create a small text file of comma separated values (CSV), and save it with the extension .csv, which means when double-clicked on a system with Excel installed, it will open as a single Excel worksheet.

    phpMyAdmin does this when it dumps a MySQL table ( http://www.phpwizard.net ).

Similar Threads

  1. browser compatibility with xls
    By dmanzoni in forum XML Programming
    Replies: 3
    Last Post: September 30th, 2003, 10:16 AM
  2. column autofit in xls using ASP contenttype
    By gita in forum ASP Programming
    Replies: 0
    Last Post: September 26th, 2003, 08:11 AM
  3. converting xls to xml---slow process...
    By cjsutton881 in forum XML Programming
    Replies: 6
    Last Post: August 29th, 2003, 08:06 AM
  4. netscape & xls & namespaces
    By lola891 in forum XML Programming
    Replies: 2
    Last Post: February 13th, 2003, 11:18 PM
  5. reading content of excel (xls) file with php
    By busi in forum PHP Development
    Replies: 2
    Last Post: August 28th, 2002, 10:14 AM

IMN logo majestic logo threadwatch logo seochat tools logo