ess public
*/
var $sheets = array();
/**
* The data returned by OLE
*
* @var string
* @access public
*/
var $data;
/**
* OLE object for reading the file
*
* @var OLE object
* @access private
*/
var ole;
/**
* Default encoding
*
* @var string
* @access private
*/
var defaultEncoding;
/**
* Default number format
*
* @var integer
* @access private
*/
var defaultFormat = SPREADSHEET_EXCEL_READER_DEF_NUM_FORMAT;
/**
* todo
* List of formats to use for each column
*
* @var array
* @access private
*/
var columnsFormat = array();
/**
* todo
*
* @var integer
* @access private
*/
var rowoffset = 1;
/**
* todo
*
* @var integer
* @access private
*/
var coloffset = 1;
/**
* List of default date formats used by Excel
*
* @var array
* @access public
*/
var $dateFormats = array (
0xe => "d/m/Y",
0xf => "d-M-Y",
0x10 => "d-M",
0x11 => "M-Y",
0x12 => "h:i a",
0x13 => "h:i:s a",
0x14 => "H:i",
0x15 => "H:i:s",
0x16 => "d/m/Y H:i",
0x2d => "i:s",
0x2e => "H:i:s",
0x2f => "i:s.S");
/**
* Default number formats used by Excel
*
* @var array
* @access public
*/
var $numberFormats = array(
0x1 => "%1.0f", // "0"
0x2 => "%1.2f", // "0.00",
0x3 => "%1.0f", //"#,##0",
0x4 => "%1.2f", //"#,##0.00",
0x5 => "%1.0f", /*"$#,##0;($#,##0)",*/
0x6 => ''$%1.0f'', /*"$#,##0;($#,##0)",*/
0x7 => ''$%1.2f'', //"$#,##0.00;($#,##0.00)",
0x8 => ''$%1.2f'', //"$#,##0.00;($#,##0.00)",
0x9 => ''%1.0f%%'', // "0%"
0xa => ''%1.2f%%'', // "0.00%"
0xb => ''%1.2f'', // 0.00E00",
0x25 => ''%1.0f'', // "#,##0;(#,##0)",
0x26 => ''%1.0f'', //"#,##0;(#,##0)",
0x27 => ''%1.2f'', //"#,##0.00;(#,##0.00)",
0x28 => ''%1.2f'', //"#,##0.00;(#,##0.00)",
0x29 => ''%1.0f'', //"#,##0;(#,##0)",
0x2a => ''$%1.0f'', //"$#,##0;($#,##0)",
0x2b => ''%1.2f'', //"#,##0.00;(#,##0.00)",
0x2c => ''$%1.2f'', //"$#,##0.00;($#,##0.00)",
0x30 => ''%1.0f''); //"##0.0E0";
// }}}
// {{{ Spreadsheet_Excel_Reader()
/**
* Constructor
*
* Some basic initialisation
*/
function __construct()
{
$this->_ole =& new OLERead();
$this->setUTFEncoder(''iconv'');
}
// }}}
// {{{ setOutputEncoding()
/**
* Set the encoding method
*
* @param string Encoding to use
* @access public
*/
function setOutputEncoding($encoding)
{
$this->_defaultEncoding = $encoding;
}
// }}}
// {{{ setUTFEncoder()
/**
* $encoder = ''iconv'' or ''mb''
* set iconv if you would like use ''iconv'' for encode UTF-16LE to your encoding
* set mb if you would like use ''mb_convert_encoding'' for encode UTF-16LE to your encoding
*
* @access public
* @param string Encoding type to use. Either ''iconv'' or ''mb''
*/
function setUTFEncoder($encoder = ''iconv'')
{
$this->_encoderFunction = '''';
if ($encoder == ''iconv'') {
$this->_encoderFunction = function_exists(''iconv'') ? ''iconv'' : '''';
} elseif ($encoder == ''mb'') {
$this->_encoderFunction = function_exists(''mb_convert_encoding'') ?
''mb_convert_encoding'' :
'''';
}
}
// }}}
// {{{ setRowColOffset(