LiveAmp 8 / 16 / 32
Overview
Compact wireless EEG amplifier especially designed for mobile EEG applications
The LiveAmp is a wearable, 24-bit amplifier - available with 8, 16, 32 and also with 64 channels. As it is wireless and allows you to store your recorded data internally (i.e. on an exchangeable memory card), there are no mobility limitations. The LiveAmp is easy and intuitive to use and its technical specifications leave nothing to be desired ...
LiveAmp 8 / 16 / 32 at a glance
- Outstanding signal quality
- Ultra lightweight and compact
- Flexible and expandable
- Integrated accelerometer
- Electrode options: passive - active - active dry - solid gel
- Official market release of LiveAmp 32 - Brain Products’ solution for superior quality mobile wireless EEG ... [more details]
- Introducing LiveAmp 8 and LiveAmp 16: our wireless mobile amplifier in low-channel versions ... [more details]
- LiveAmp 64 – High density wireless EEG amplifier ... [more details]
Interested in more?
- See the LiveAmp in practice: MoBI experiment video
- Request more information or a quote:
Click here
- Contact your local distributor:
Click here
Our products are scientific equipment for INVESTIGATIONAL USE ONLY! Medical use e.g. for diagnosis, treatment of disease or other such purposes is strictly forbidden.
Technical Specifications
_init();
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _init() {
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
// user func : $file - path to xls file to read
function read_file($file) {
$this->_data = new xls_container($file,true);
return $this->_read_xls();
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
// user func : $strin - xls file stream
function read_string($string) {
$this->_data = new xls_container($string);
return $this->_read_xls();
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
// main reading function
function _read_xls() {
if ($this->_data->get_data_size() <= EXCEL_BLOCK_SIZE) {
trigger_error("File or stream is corrupted [size too small]", E_USER_ERROR);
}
$this->_blocks_count = $this->_data->get_blocks_number();
$file_header = $this->_data->_fgets(0,EXCEL_BLOCK_SIZE);
$header_etalon = pack("H*", "D0CF11E0A1B11AE1"); // MAGIC
if ($header_etalon != substr($file_header,0,8)) { // checking file header
trigger_error("Invalid file header", E_USER_ERROR);
}
$this->_header = new xls_container($file_header);
$this->_data->_s_offset = EXCEL_BLOCK_SIZE;
$res = $this->_read_workbook();
$this->workbook->_check_palette();
return $res;
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _read_workbook() {
$root_node = $this->_header->get_long(0x30);
$fat_blocks_count = $this->_header->get_long(0x2c);
$this->fat = array();
for($i=0;$i<$fat_blocks_count;$i++) {
$fat_block = $this->_header->get_long(0x4c + 4 * $i);
$fatbuf = $this->_data->_fgets($fat_block * EXCEL_BLOCK_SIZE, EXCEL_BLOCK_SIZE);
$fat = new xls_container($fatbuf);
if($fat->get_data_size() < EXCEL_BLOCK_SIZE){
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
for($c=0;$cfat[] = $fat->get_long($c * 4);
$fat->_kill();
unset($fat_block,$fatbuf,$fat);
}
if(count($this->fat) < $fat_blocks_count) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$blocks_chain = $this->get_blocks_chain($root_node);
$dir = new xls_container($this->_data->read_blocks_chain($blocks_chain));
unset($blocks_chain);
$this->sfat = array();
$small_block = $this->_header->get_long(0x3c);
if ($small_block != 0xfeffffff) {
$root_node_index = $this->_get_stream_index($dir, "Root Entry");
$sdc_start_block = $dir->get_long($root_node_index * THIS_BLOCK_SIZE + 0x74);
$small_blocks_chain = $this->get_blocks_chain($sdc_start_block);
$this->_sblocks_count = count($small_blocks_chain) * 8;
$schain = $this->get_blocks_chain($small_block);
for ($i=0;$i_data->_fgets($schain[$i] * EXCEL_BLOCK_SIZE, EXCEL_BLOCK_SIZE);
$sfat = new xls_container($sfatbuf);
if ($sfat->get_data_size() < EXCEL_BLOCK_SIZE) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
for ($c=0;$csfat[] = $sfat->get_long($c * 4);
$sfat->_kill();
unset($sfatbuf,$sfat);
}
unset($schain);
$sfcbuf = $this->_data->read_blocks_chain($small_blocks_chain);
$sdp = new xls_container($sfcbuf); // small data
unset($sfcbuf,$small_blocks_chain);
}
$workbook_index = $this->_get_stream_index($dir,"Workbook");
if ($workbook_index < 0) {
$workbook_index = $this->_get_stream_index($dir,"Book");
if ($workbook_index < 0) {
trigger_error("Stream 'WorkBook' was not found", E_USER_ERROR);
}
}
$workbook_start_block = $dir->get_long($workbook_index * THIS_BLOCK_SIZE + 0x74);
$workbook_length = $dir->get_long($workbook_index * THIS_BLOCK_SIZE + 0x78);
$wbk = "";
if ($workbook_length > 0) {
if ($workbook_length >= 0x1000) {
$chain = $this->get_blocks_chain($workbook_start_block);
$wbk = $this->_data->read_blocks_chain($chain);
}
else {
$chain = $this->get_blocks_chain($workbook_start_block,true);
$wbk = $sdp->read_blocks_chain($chain, 0x40);
unset($sdp);
}
$wbk = substr($wbk,0,$workbook_length);
if(strlen($wbk) != $workbook_length) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
unset( $chain );
}
unset($this->fat,$this->sfat);
if (strlen($wbk) <= 0) {
trigger_error("Stream 'WorkBook' was not found", E_USER_ERROR);
}
if ( strlen($wbk) < 4 ||
strlen($wbk) < $this->_get_val($wbk,0,2) ||
ord($wbk[0]) != 0x09
) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$cur_ver = ord($wbk[1]); // BIFF Version number PRE
if (($cur_ver!=0) && ($cur_ver!=2) && ($cur_ver!=4) && ($cur_ver!=8)){
trigger_error("Invalid file format version", E_USER_ERROR);
}
if ($cur_ver != 8) {$biff_ver = ($ver+4)/2;}
else {
if (strlen($wbk) < 12) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
switch ($this->_get_val($wbk,0,4)) {
case 0x0500:
if ($this->_get_val($wbk,0,10) < 1994) {$biff_ver = 5;}
else {
switch ($this->_get_val($wbk,0,8)) {
case 2412:
case 3218:
case 3321:
$biff_ver = 5;
break;
default:
$biff_ver = 7;
break;
}
}
break;
case 0x0600:
$biff_ver = 8;
break;
default:
trigger_error("Unsupported file format version", E_USER_ERROR);
}
}
if ($biff_ver < 5) {
trigger_error("Unsupported file format version [$biff_ver]", E_USER_ERROR);
}
$this->workbook = new struct_book;
$xf_count=0;
$pointer = 0;
$opcode = 0;
$cont_def = false;
$wbklen = strlen($wbk);
while ((ord($wbk[$pointer])!=0x0a) && ($pointer < $wbklen)) { // main rotation
$oc = $this->_get_val($wbk,$pointer,0);
if ($oc != 0x3c) {$opcode = $oc;}
switch ($opcode) {
case RCRD_BOUNDSHEET:
$ofs = get_long_from_string(substr($wbk,$pointer+4,4));
$this->workbook->add_sheet();
$this->workbook->_cur_sheet->options = $this->_get_val($wbk,$pointer,8);
if ($biff_ver==8) {
$len = ord($wbk[$pointer+10]);
if ((ord($wbk[$pointer+11]) & 1) > 0) {
$this->workbook->_cur_sheet->unicode = true;
$len = $len*2;
}
else {
$this->workbook->_cur_sheet->unicode = false;
}
$this->workbook->_cur_sheet->name = substr($wbk,$pointer+12,$len);
}
else {
$this->workbook->_cur_sheet->unicode = false;
$len = ord($wbk[$pointer+10]);
$this->workbook->_cur_sheet->name = substr($wbk,$pointer+11,$len);
}
$pws = $this->_read_worksheet(substr($wbk,$ofs));
$this->workbook->_cur_sheet->table = $pws;
break;
// end of RCRD_BOUNDSHEET:
case RCRD_FORMAT:
$fidx = $this->_get_val($wbk,$pointer,4);
$length = ord($wbk[$pointer+5]);
$this->workbook->_num_formats[$fidx] = getUnicodeString($wbk,$pointer+6,-1);
break;
// end of RCRD_FORMAT
case RCRD_DATEMODE:
$dateidx = $this->_get_val($wbk,$pointer,4);
$this->workbook->date_mode = $dateidx;
break;
// end of RCRD_DATEMODE
case RCRD_FONT:
$cur_font = array("size" => 0,
"script" => XF_SCRIPT_NONE,
"underline" => XF_UL_NONE,
"italic" => false,
"strikeout"=> false,
"bold" => false,
"boldness" => XF_WGHT_REGULAR,
"color" => 0,
"name" => "");
$cur_font["size"] = $this->_get_val($wbk,$pointer+4,0) / 20;
$style = ord($wbk[$pointer+4+2]);
if (($style & XF_STYLE_ITALIC) != 0) {
$cur_font["italic"] = true;
}
if (($style & XF_STYLE_STRIKEOUT) != 0) {
$cur_font["strikeout"] = true;
}
$cur_font["color"] = $this->_get_val($wbk,$pointer+4,4) - 8;
$cur_font["boldness"] = $this->_get_val($wbk,$pointer+4,6);
$cur_font["bold"] = $cur_font["boldness"] == XF_WGHT_REGULAR ? false : true;
$cur_font["script"] = $this->_get_val($wbk,$pointer+4,8);
$cur_font["underline"] = ord($wbk[$pointer+4+10]);
if (ord($wbk[$pointer+4+17]) != 0) {
$length = ord($wbk[$pointer+4+14]);
$cur_font["name"] = substr($wbk,$pointer+4+15,$length);
}
else {
$length = ord($wbk[$pointer+4+14]);
if ($length >0) {
if (ord($wbk[$pointer+4+15]) == 0) {
$cur_font["name"] = substr($wbk,$pointer+4+16,$length);
}
else {
$cur_font["name"] = getUnicodeString($wbk,$pointer+4+15,$length);
}
}
}
$this->workbook->_fonts[] = $cur_font;
break;
// end of RCRD_FONT
case RCRD_XF:
$this->workbook->_xf['font'][$xf_count] = $this->_get_val($wbk,$pointer,4);
$this->workbook->_xf['format'][$xf_count] = $this->_get_val($wbk,$pointer,6);
$this->workbook->_xf['type'][$xf_count] = "1";
$this->workbook->_xf['bitmask'][$xf_count] = "1";
$align = $this->_get_val($wbk,$pointer,10);
$this->workbook->_xf['h_align'][$xf_count] = bindec(substr(decbin($align),-2));
$v_al = bindec(substr(decbin($align),-6,2));
$v_al8 = bindec(substr(decbin($align),-5,2)); // for biff8
if ($biff_ver >= 8) {
switch ($v_al8) {
case 1: $this->workbook->_xf['v_align'][$xf_count] = 2; break;
case 2: $this->workbook->_xf['v_align'][$xf_count] = 0; break;
case 3: $this->workbook->_xf['v_align'][$xf_count] = 1; break;
}
}
else {$this->workbook->_xf['v_align'][$xf_count] = $v_al;}
if ($biff_ver >= 8) {
$bg_fg = $this->_get_val($wbk,$pointer,22);
$bg = bindec(substr(decbin($bg_fg),0,7));
$fg = bindec(substr(decbin($bg_fg),-7));
}
else {
$bg_fg = $this->_get_val($wbk,$pointer,12);
$bg = bindec(substr(decbin($bg_fg),0,7));
$fg = bindec(substr(decbin($bg_fg),-7));
}
$this->workbook->_xf['fg_color'][$xf_count] = $fg-8;
$this->workbook->_xf['bg_color'][$xf_count] = $bg-8;
$xf_count++;
break;
// end of RCRD_XF
case RCRD_SST: // Shared String Table - BIFF 8 only!
if ($biff_ver < 8) {break;}
$sb_len = $this->_get_val($wbk,$pointer,2);
if ($oc != RCRD_CONTINUE) { // to check
if($cont_def) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$snum = get_long_from_string(substr($wbk,$pointer+8,4));
$s_pointer = $pointer + 12;
$cont_def = true;
}
else {
if ($rslen > $s_len) {
$s_pointer = $pointer+4;
$rslen -= $s_len;
$s_len = $rslen;
if ((ord($wbk[$s_pointer]) & 1) > 0) {
if ($char_bytes == 1) {
$sstr = "";
for ($i=0;$i $pointer+4+$sb_len) {
$s_len = ($pointer+$sb_len-$s_pointer+3)/$schar_bytes;
}
$sstr = substr($wbk,$s_pointer+1,$s_len*$schar_bytes);
if (($char_bytes == 2) && ($schar_bytes == 1)) {
$sstr2 = "";
for ($i=0; $i= strlen($wbk)) || ($s_pointer < $pointer+4+$sb_len) || (ord($wbk[$s_pointer]) != RCRD_CONTINUE)) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
break;
}
else {
if ($char_bytes == 2) {
$this->workbook->_cell_data['unicode'][] = true;
}
else {
$this->workbook->_cell_data['unicode'][] = false;
}
$this->workbook->_cell_data['data'][] = $str;
$snum--;
}
}
else {
$s_pointer = $pointer+4;
if ($s_pointer > $pointer) {$s_pointer += 4*$rt+$fesz;}
}
}
while (($s_pointer < $pointer+4+$sb_len) && ($s_pointer < strlen($wbk)) && ($snum > 0)) {
$rslen = $this->_get_val($wbk,$s_pointer,0);
$s_len = $rslen;
if( (ord($wbk[$s_pointer+2]) & 1) > 0 ) {$char_bytes = 2;}
else {$char_bytes = 1;}
$rt = 0;
$fesz = 0;
switch (ord($wbk[$s_pointer+2]) & 0x0c) {
case 0x0c:
$rt = $this->_get_val($wbk,$s_pointer,3);
$fesz = get_long_from_string(substr($wbk,$s_pointer+5,4));
if ($s_pointer+9+$s_len*$char_bytes > $pointer+4+$sb_len) {
$s_len = ($pointer+$sb_len-$s_pointer-5)/$char_bytes;
}
$str = substr($wbk,$s_pointer+9,$s_len*$char_bytes);
$s_pointer += $s_len*$char_bytes+9;
break;
case 8:
$rt = $this->_get_val($wbk,$s_pointer,3);
if ($s_pointer+5+$s_len*$char_bytes > $pointer+4+$sb_len) {
$s_len = ($pointer+$sb_len-$s_pointer-1)/$char_bytes;
}
$str = substr($wbk,$s_pointer+5,$s_len*$char_bytes);
$s_pointer += $s_len*$char_bytes+5;
break;
case 4:
$fesz = get_long_from_string(substr($wbk,$s_pointer+3,4));
if ($s_pointer+7+$s_len*$char_bytes > $pointer+4+$sb_len) {
$s_len = ($pointer+$sb_len-$s_pointer-3)/$char_bytes;
}
$str = substr($wbk,$s_pointer+7,$s_len*$char_bytes);
$s_pointer += $s_len*$char_bytes+7;
break;
case 0:
if ($s_pointer+3+$s_len*$char_bytes > $pointer+4+$sb_len) {
$s_len = ($pointer+$sb_len-$s_pointer+1)/$char_bytes;
}
$str = substr($wbk,$s_pointer+3,$s_len*$char_bytes);
$s_pointer += $s_len*$char_bytes+3;
break;
} // end of switch
if ($s_len < $rslen) {
if (($s_pointer >= strlen($wbk)) || ($s_pointer < $pointer+4+$sb_len) || (ord($wbk[$s_pointer]) != 0x3c)) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
}
else {
if ($char_bytes == 2) {
$this->workbook->_cell_data['unicode'][] = true;
}
else {
$this->workbook->_cell_data['unicode'][] = false;
}
$s_pointer += 4 * $rt + $fesz;
$this->workbook->_cell_data['data'][] = $str;
$snum--;
}
} // end of while
break;
// end of RCRD_SST
case RCRD_PALETTE:
$pal_ln = $this->_get_val($wbk,$pointer,0);
//list($null,$rcrd_len,$colors_count) = unpack("v2", substr($wbk,$pointer+2,4));
@list($null,$rcrd_len,$colors_count) = @unpack("V2", @substr(@$wbk,@$pointer+2,4));
for ($cl=0;$cl<$colors_count;$cl++) {
list($null,$r,$g,$b,$tmp) = unpack("C4", substr($wbk,$pointer+6+($cl*4),4));
$r_h = (strlen(dechex($r)) < 2) ? "0".dechex($r) : dechex($r);
$g_h = (strlen(dechex($g)) < 2) ? "0".dechex($g) : dechex($g);
$b_h = (strlen(dechex($b)) < 2) ? "0".dechex($b) : dechex($b);
$col_HEX = $r_h.$g_h.$b_h;
$this->workbook->_palette[] = strtoupper($col_HEX);
}
break;
// end of RCRD_PALETTE
default: // 2DO - other records
break;
} // end of switch ($opcode)
$pointer += 4 + $this->_get_val($wbk,$pointer,2);
} // main rotation
$this->biff_version = $biff_ver;
return 0;
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _read_worksheet($wst) {
if (strlen($wst) <= 0) {
trigger_error("WorkSheet was not found", E_USER_ERROR);
}
if (strlen($wst) < 4){
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
if ( strlen($wst) < 4 ||
strlen($wst) < $this->_get_val($wst,0,2) ||
ord($wst[0]) != 0x09
) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$cur_ver = ord($wst[1]);
if (($cur_ver!=0) && ($cur_ver!=2) && ($cur_ver!=4) && ($cur_ver!=8)){
trigger_error("Invalid file format version", E_USER_ERROR);
}
if ($cur_ver != 8) {$biff_ver = ($ver+4)/2;}
else {
if (strlen($wst) < 12) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
switch ($this->_get_val($wst,0,4)) {
case 0x0500:
if ($this->_get_val($wst,0,10) < 1994) {$biff_ver = 5;}
else {
switch ($this->_get_val($wst,0,8)) {
case 2412:
case 3218:
case 3321:
$biff_ver = 5;
break;
default:
$biff_ver = 7;
break;
}
}
break;
case 0x0600:
$biff_ver = 8;
break;
default:
trigger_error("Unsupported file format version", E_USER_ERROR);
}
}
if ($biff_ver < 5) {
trigger_error("Unsupported file format version [$biff_ver]", E_USER_ERROR);
}
$this->workbook->_cur_sheet->biff_ver = $biff_ver;
$pointer = 0;
$data = array();
while ((ord($wst[$pointer])!=0x0a) && ($pointer_get_val($wst,$pointer,0)) {
// MERGE CELLS
case 0x00E5:
//echo "merge found
"; $number_of_merges = $this->_get_val($wst,$pointer+2,2); //echo " number_of_merges = ".$number_of_merges."
"; $cntr = 0; $mrg = array(); for ($mr=0;$mr<$number_of_merges;$mr++) { $firstrow = $this->_get_val($wst,$pointer+4+$cntr,2); $lastrow = $this->_get_val($wst,$pointer+6+$cntr,2); $firstcol = $this->_get_val($wst,$pointer+8+$cntr,2); $lastcol = $this->_get_val($wst,$pointer+10+$cntr,2); //$mrg[$firstrow][$firstcol]['last_row'] = $lastrow; //$mrg[$firstrow][$firstcol]['last_col'] = $lastcol; $this->workbook->_cur_sheet->_cells_merge_info[$firstrow][$firstcol]['last_row'] = $lastrow; $this->workbook->_cur_sheet->_cells_merge_info[$firstrow][$firstcol]['last_col'] = $lastcol; $cntr+=8; } //$this->workbook->_cur_sheet->_cells_merge_info = $mrg; unset($mrg); //echo "------------
"; break; // ------------- case RCRD_NUMBER: case RCRD_FORMULA: if (($this->_get_val($wst,$pointer,2)) < 14) { trigger_error("File or stream is corrupted", E_USER_ERROR); } $row = $this->_get_val($wst,$pointer,4); $col = $this->_get_val($wst,$pointer,6); $num_lo = get_long_from_string(substr($wst,$pointer+10,4)); $num_hi = get_long_from_string(substr($wst,$pointer+14,4)); $xf_idx = $this->_get_val($wst,$pointer,8); $data[$row][$col]['type'] = 2; $fonti = $this->workbook->_xf['font'][$xf_idx]; $data[$row][$col]['xf'] = $xf_idx; $data[$row][$col]['font'] = $fonti; if ($num_hi==0 && $num_lo==0) { $data[$row][$col]['data'] = 0; } else { $fexp = (($num_hi & 0x7ff00000) >> 20) - 1023; $val = 1+(($num_hi & 0x000fffff)+$num_lo/4294967296)/1048576; if ($fexp > 0) { for ($i=0;$i<$fexp;$i++) {$val *= 2;} } else { for ($i=0;$iworkbook->_cur_sheet->num_rows) || ($this->workbook->_cur_sheet->num_rows < $row)) {
$this->workbook->_cur_sheet->num_rows = $row;
}
if (!isset($this->workbook->_cur_sheet->num_cols) || ($this->workbook->_cur_sheet->num_cols < $col)){
$this->workbook->_cur_sheet->num_cols = $col;
}
break;
// end of NUMBERS
case RCRD_RK:
if (($this->_get_val($wst,$pointer,2)) < 0x0a) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$row = $this->_get_val($wst,$pointer,4);
$col = $this->_get_val($wst,$pointer,6);
$xf_idx = $this->_get_val($wst,$pointer,8);
$val = $this->_decode_rk(get_long_from_string(substr($wst,$pointer+10,4)));
$data[$row][$col]['type'] = $val['type'];
$fonti = $this->workbook->_xf['font'][$xf_idx];
$data[$row][$col]['xf'] = $xf_idx;
$data[$row][$col]['font'] = $fonti;
$data[$row][$col]['data'] = $val['val'];
if (!isset($this->workbook->_cur_sheet->num_rows) || ($this->workbook->_cur_sheet->num_rows < $row)) {
$this->workbook->_cur_sheet->num_rows = $row;
}
if (!isset($this->workbook->_cur_sheet->num_cols) || ($this->workbook->_cur_sheet->num_cols < $col)){
$this->workbook->_cur_sheet->num_cols = $col;
}
break;
// end of RCRD_RK
case RCRD_MULRK: // Multiple RK
$sz = $this->_get_val($wst,$pointer,2);
if ($sz < 6) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$row = $this->_get_val($wst,$pointer,4);
$fc = $this->_get_val($wst,$pointer,6);
$lc = $this->_get_val($wst,$pointer,$sz+2);
$tmp_maxcol = 0;
for( $i=0; $i<=$lc-$fc; $i++) {
$val = $this->_decode_rk(get_long_from_string(substr($wst,$pointer+10+$i*6,4)));
$xf_idx = $this->_get_val($wst,$pointer,$i*6+8);
$data[$row][$fc+$i]['type'] = $val['type'];
$fonti = $this->workbook->_xf['font'][$xf_idx];
//$data[$row][$col]['xf'] = $xf_u;
$data[$row][$fc+$i]['xf'] = $xf_idx;
$data[$row][$fc+$i]['font'] = $fonti;
$data[$row][$fc+$i]['data'] = $val['val'];
$tmp_maxcol = $fc+$i;
}
if (!isset($this->workbook->_cur_sheet->num_rows) || ($this->workbook->_cur_sheet->num_rows < $row)) {
$this->workbook->_cur_sheet->num_rows = $row;
}
if (!isset($this->workbook->_cur_sheet->num_cols) || ($this->workbook->_cur_sheet->num_cols < $tmp_maxcol)){
$this->workbook->_cur_sheet->num_cols = $tmp_maxcol;
}
break;
// end of RCRD_RK
case RCRD_LABEL:
if (($this->_get_val($wst,$pointer,2)) < 8){
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$row = $this->_get_val($wst,$pointer,4);
$col = $this->_get_val($wst,$pointer,6);
$xf = $this->_get_val($wst,$pointer,8);
$fonti = $this->workbook->_xf['font'][$xf];
$font = $this->fonts[$fonti];
$str_len = $this->_get_val($wst,$pointer,10);
if ($pointer+12+$str_len > strlen($wst)) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$this->workbook->_cell_data['unicode'][] = false;
$this->workbook->_cell_data['data'][] = substr($wst,$pointer+12,$str_len);
$data[$row][$col]['xf'] = $xf;
$data[$row][$col]['type'] = 0;
$sst_ind = count($this->workbook->_cell_data['data'])-1;
$data[$row][$col]['data'] = $sst_ind;
$data[$row][$col]['font'] = $fonti;
if (!isset($this->workbook->_cur_sheet->num_rows) || ($this->workbook->_cur_sheet->num_rows < $row)) {
$this->workbook->_cur_sheet->num_rows = $row;
}
if (!isset($this->workbook->_cur_sheet->num_cols) || ($this->workbook->_cur_sheet->num_cols < $col)){
$this->workbook->_cur_sheet->num_cols = $col;
}
break;
// end of RCRD_LABEL
case RCRD_LABELSST: // replacement of LABEL Record - BIFF 8 only!
if ($biff_ver < 8) {break;}
if (($this->_get_val($wst,$pointer,2)) < 0x0a) {
trigger_error("File or stream is corrupted", E_USER_ERROR);
}
$row = $this->_get_val($wst,$pointer,4);
$col = $this->_get_val($wst,$pointer,6);
$xf = $this->_get_val($wst,$pointer,8);
$fonti = $this->workbook->_xf['font'][$xf];
$data[$row][$col]['xf'] = $xf;
$font = &$this->workbook->_fonts[$fonti];
$data[$row][$col]['type'] = 0;
$sst_ind = get_long_from_string(substr($wst,$pointer+10,4));
$data[$row][$col]['data'] = $sst_ind;
$data[$row][$col]['font'] = $fonti;
if (!isset($this->workbook->_cur_sheet->num_rows) || ($this->workbook->_cur_sheet->num_rows < $row)) {
$this->workbook->_cur_sheet->num_rows = $row;
}
if (!isset($this->workbook->_cur_sheet->num_cols) || ($this->workbook->_cur_sheet->num_cols < $col)){
$this->workbook->_cur_sheet->num_cols = $col;
}
break;
// end of RCRD_LABELSST
case RCRD_BLANK:
$row = $this->_get_val($wst,$pointer,4);
$col = $this->_get_val($wst,$pointer,6);
$xf = $this->_get_val($wst,$pointer,8);
$fonti = $this->workbook->_xf['font'][$xf];
$data[$row][$col]['xf'] = $xf;
$font = &$this->workbook->_fonts[$fonti];
$data[$row][$col]['type'] = -1;
$data[$row][$col]['font'] = $fonti;
break;
// end of RCRD_BLANK
case RCRD_COLINFO:
$start_col = $this->_get_val($wst,$pointer,4);
$end_col = $this->_get_val($wst,$pointer,6);
$col_width = round($this->_get_val($wst,$pointer,8) / 256 - 0.72);
for ($i=$start_col;$i<=$end_col;$i++) {
$this->workbook->_cur_sheet->_col_width[$i] = $col_width;
}
break;
// end of RCRD_COLINFO
default: // 2DO - other records
break;
}
$pointer += 4 + $this->_get_val($wst,$pointer,2);
} // end of main rotation
return $data;
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _get_val(&$cont,$idx,$offset) {
return ord($cont[$idx+$offset])+256*ord($cont[$idx+$offset+1]);
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function get_blocks_chain($offset,$small=false) {
$chain = array();
$next_block = $offset;
if ($small === false) {
while (($next_block!=0xfffffffe) &&
($next_block <= $this->_blocks_count) &&
($next_block < count($this->fat))) {
$chain[] = $next_block;
$next_block = $this->fat[$next_block];
}
}
else {
while (($next_block!=0xfffffffe) &&
($next_block <= $this->_sblocks_count) &&
($next_block < count($this->sfat))) {
$chain[] = $next_block;
$next_block = $this->sfat[$next_block];
}
}
if ($next_block != 0xfffffffe) {return false;}
return $chain;
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _get_stream_index($dir,$stream_name,$stream_num=0) {
$dt = $dir->get_ord($stream_num * THIS_BLOCK_SIZE + 0x42);
$prev = $dir->get_long($stream_num * THIS_BLOCK_SIZE + 0x44);
$next = $dir->get_long($stream_num * THIS_BLOCK_SIZE + 0x48);
$dir_ = $dir->get_long($stream_num * THIS_BLOCK_SIZE + 0x4c);
$curr_name = "";
$s_area = ($dir->get_ord($stream_num * THIS_BLOCK_SIZE + 0x40) + 256 * $dir->get_ord($stream_num * THIS_BLOCK_SIZE + 0x41)) / 2 - 1;
if (($dt==2) || ($dt==5)) {
for ($i=0;$i<$s_area;$i++) {
$curr_name .= $dir->get_byte($stream_num * THIS_BLOCK_SIZE + $i * 2);
}
}
if ((($dt==2) || ($dt==5)) && (strcmp($curr_name,$stream_name)==0)){
return $stream_num;
}
if ($prev != 0xffffffff && $prev != 2704) {
$i = $this->_get_stream_index($dir,$stream_name,$prev);
if ($i >= 0) { return $i; }
}
if ($next != 0xffffffff && $next != 2704) {
$i = $this->_get_stream_index($dir,$stream_name,$next);
if ($i >= 0){ return $i; }
}
if ($dir_ != 0xffffffff && $dir_ != 2704) {
$i = $this->_get_stream_index($dir,$stream_name,$dir_);
if ($i >= 0) { return $i; }
}
return -2;
} // end of function
// ------------------------------------------------------------------------------------------------
// ------------------------------------------------------------------------------------------------
function _decode_rk($rk) {
$res = array();
if ($rk & 2) { // integer
$val = ($rk & 0xfffffffc) >> 2;
if ($rk & 1) {$val = $val / 100;}
if (((float)$val) == floor((float)$val)){
$res['val'] = (int)$val;
$res['type'] = 1;
}
else {
$res['val'] = (float)$val;
$res['type'] = 2;
}
}
else { // float
$res['type'] = 2;
$frk = $rk;
$fexp = (($frk & 0x7ff00000) >> 20) - 1023;
$val = 1+(($frk & 0x000fffff) >> 2)/262144;
if ($fexp > 0) {
for( $i=0; $i<$fexp; $i++ )
$val *= 2;
}
else {
if ($fexp == -1023) {$val=0;}
else {
for ($i=0;$i
"; $number_of_merges = $this->_get_val($wst,$pointer+2,2); //echo " number_of_merges = ".$number_of_merges."
"; $cntr = 0; $mrg = array(); for ($mr=0;$mr<$number_of_merges;$mr++) { $firstrow = $this->_get_val($wst,$pointer+4+$cntr,2); $lastrow = $this->_get_val($wst,$pointer+6+$cntr,2); $firstcol = $this->_get_val($wst,$pointer+8+$cntr,2); $lastcol = $this->_get_val($wst,$pointer+10+$cntr,2); //$mrg[$firstrow][$firstcol]['last_row'] = $lastrow; //$mrg[$firstrow][$firstcol]['last_col'] = $lastcol; $this->workbook->_cur_sheet->_cells_merge_info[$firstrow][$firstcol]['last_row'] = $lastrow; $this->workbook->_cur_sheet->_cells_merge_info[$firstrow][$firstcol]['last_col'] = $lastcol; $cntr+=8; } //$this->workbook->_cur_sheet->_cells_merge_info = $mrg; unset($mrg); //echo "------------
"; break; // ------------- case RCRD_NUMBER: case RCRD_FORMULA: if (($this->_get_val($wst,$pointer,2)) < 14) { trigger_error("File or stream is corrupted", E_USER_ERROR); } $row = $this->_get_val($wst,$pointer,4); $col = $this->_get_val($wst,$pointer,6); $num_lo = get_long_from_string(substr($wst,$pointer+10,4)); $num_hi = get_long_from_string(substr($wst,$pointer+14,4)); $xf_idx = $this->_get_val($wst,$pointer,8); $data[$row][$col]['type'] = 2; $fonti = $this->workbook->_xf['font'][$xf_idx]; $data[$row][$col]['xf'] = $xf_idx; $data[$row][$col]['font'] = $fonti; if ($num_hi==0 && $num_lo==0) { $data[$row][$col]['data'] = 0; } else { $fexp = (($num_hi & 0x7ff00000) >> 20) - 1023; $val = 1+(($num_hi & 0x000fffff)+$num_lo/4294967296)/1048576; if ($fexp > 0) { for ($i=0;$i<$fexp;$i++) {$val *= 2;} } else { for ($i=0;$i