SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: PHP Excel Read

  1. #1
    SitePoint Addict fesh's Avatar
    Join Date
    Jan 2005
    Location
    Jackson, New Jersey
    Posts
    218
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    PHP Excel Read

    I'm trying to read an Excel file through PHP. I can read data out, get each spreadsheet in a workbook, and other stuff. However, I have ZERO clue how to retrieve the background color of a cell.

    I've looked into everything that could be possible using the Microsoft Excel 97-2007 Binary File Format Specification (http://download.microsoft.com/downlo...cification.pdf).

    My brain is melting.
    And I don't mean that figuratively.
    Fesh
    imagine what it's going to be like

  2. #2
    SitePoint Evangelist
    Join Date
    Jun 2006
    Location
    Wigan, Lancashire. UK
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by fesh View Post
    I'm trying to read an Excel file through PHP. I can read data out, get each spreadsheet in a workbook, and other stuff. However, I have ZERO clue how to retrieve the background color of a cell.
    Are you using a library to read Excel, or have you written your own code?

    The PHPExcel library is very capable of reading all information about a cell format, including background colour.
    ---
    Development Projects:
    PHPExcel
    PHPPowerPoint


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
  •