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

Brent,
Have a look at http://www.freevbcode.com/Source/006/vb%20Excel.zip
It give a lot of info on writing the BIFF8 format for an Excel file.
It looks like the ID values for the classes in Excel8Records is what you're
after.

NickHK

"Brent" wrote in message
...
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

Thanks Nick, will have a look.