SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Guru
    Join Date
    Nov 2004
    Location
    England
    Posts
    698
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    The Best Excel Output Library?

    The question is, which is it?

    I'm basically building an improved reporting tool in to a web-database that I maintain, and currently we can view on screen in a table or a graph, or we can output CSV, but that baffles some people who have to use it (don't ask!) so I'd like to just give them an Excel file (.XLS, not .XLSX) that they can open straight in to Excel and it look as it should.

    So, I begin my research to see what Excel libraries are available for PHP and come across a few, but I cannot see any reviews for any. So, I'm interested in opinions from anyone who uses one (or more). I only need to be able to put in some simple formatting, like font sizes, font/cell colours and positions of the data (A1, D5 etc).

    Tips?

  2. #2
    Twitter: @AnthonySterling silver trophy AnthonySterling's Avatar
    Join Date
    Apr 2008
    Location
    North-East, UK.
    Posts
    6,111
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    PHPExcel gets a thumbs-up from me, it's actively developed still too, which is a huge bonus IMO.
    @AnthonySterling: I'm a PHP developer, a consultant for oopnorth.com and the organiser of @phpne, a PHP User Group covering the North-East of England.

  3. #3
    SitePoint Guru
    Join Date
    Nov 2004
    Location
    England
    Posts
    698
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Yeah, that was the only one that was really grabbing me TBH. I haven't looked in to it fully, though I noticed the headline on the page was "Create Excel2007 documents in PHP". I should look further in to it I guess

  4. #4
    SitePoint Evangelist
    Join Date
    Jun 2006
    Location
    Wigan, Lancashire. UK
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Antnee View Post
    Yeah, that was the only one that was really grabbing me TBH. I haven't looked in to it fully, though I noticed the headline on the page was "Create Excel2007 documents in PHP". I should look further in to it I guess
    PHPExcel currently has writers for Excel 97/2003 BIFF8 (xls) and Excel 2007 (xlsx), as well as CSV, HTML and PDF.
    ---
    Development Projects:
    PHPExcel
    PHPPowerPoint

  5. #5
    SitePoint Guru
    Join Date
    Nov 2004
    Location
    England
    Posts
    698
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    That sounds great, I will definitely have to take a look. Is there licensing information on the site somewhere?

  6. #6
    SitePoint Evangelist
    Join Date
    Jun 2006
    Location
    Wigan, Lancashire. UK
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Antnee View Post
    Is there licensing information on the site somewhere?
    LGPL 2.1
    ---
    Development Projects:
    PHPExcel
    PHPPowerPoint

  7. #7
    SitePoint Guru
    Join Date
    Nov 2004
    Location
    England
    Posts
    698
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Brilliant, thanks. Don't know how I missed that!


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •