Thread: Excel Constants
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent[_8_] Brent[_8_] is offline
external usenet poster
 
Posts: 2
Default Excel Constants

Hi,

I'm using php to read an excel file. For the most part it works, only
problem is with vlookup. The cell reads an empty string so I need to *fix*
the php excel reader class. Below are some of the constants that have been
defined:

define('Spreadsheet_Excel_Reader_Type_BOF', 0x809);
define('Spreadsheet_Excel_Reader_Type_EOF', 0x0a);
define('Spreadsheet_Excel_Reader_Type_BOUNDSHEET', 0x85);
define('Spreadsheet_Excel_Reader_Type_DIMENSION', 0x200);
define('Spreadsheet_Excel_Reader_Type_ROW', 0x208);
define('Spreadsheet_Excel_Reader_Type_DBCELL', 0xd7);
define('Spreadsheet_Excel_Reader_Type_FILEPASS', 0x2f);

Does anyone recognize or can provide a link that lists the hexidecimal
constants (and their meaning) used by Excel. The php library doesn't have
access to any com objects or other header files, thus the reason for using
the hex values. I'd be happy with a header file or something similar where
I could glean the relevant information from.

thanks,

Brent