actiCAP slim / actiCAP snap
Overview
actiCAP slim and actiCAP snap The next generation active electrode* system
The actiCAP is the go-to solution for reliable and flexible high-quality EEG recordings. We kept on improving the design of our active electrodes* and here present the latest version: actiCAP slim and actiCAP snap.
actiCAP active electrode features at a glance:
- Higher impedance recordings Active circuits for impedance conversion are integrated directly in the actiCAP slim electrodes. Impedance conversion already at the electrode level makes it possible to achieve outstanding signal quality even with higher impedances compared to conventional passive electrodes. Hence the preparation time per electrode is reduced tremendously.
- Wide hardware compatibility connect actiCAP to any Brain Products amplifier and nearly all existing competitor research EEG amplifier systems.
- Per-electrode LED impedance feedback* Multi-color LEDs in the electrodes indicate the impedance ranges. This makes electrode preparation very convenient and fast, since the feedback is given directly at the electrode level without the need to look at a computer screen (e.g. 64ch in approx. 10 minutes).
- Easy electrode replacement actiCAP electrodes are very sturdy; however, in the event that an actiCAP electrode fails, flawless replacement of single electrodes is possible.
- Smaller Our engineers managed to fit all the features of the original actiCAP electrode in a new form factor that is three times thinner. The actiCAP slim is a fully active EEG electrode with impedance conversion circuitry and multi-color LED impedance feedback scaled down by a factor of three.
- Lightweight actiCAP slim is also lighter. The low center of gravity together with the lower weight reduces motion artefacts in EEG data. This makes it an ideal companion for MoBI (mobile brain/body imaging) research. The lower weight per electrode makes a high-density cap significantly lighter and hence more comfortable to wear.
- More robust The new design of the electrode comes with flat pellets that are covered by the electrode housing from the sides. This protects the pellet from accidental damages.
- Easier preparation Preparation of the actiCAP was always quick and easy. The larger opening in the actiCAP slim makes the electrode preparation even easier. It now allows the usage of paste for long-term recordings like in sleep research!
- The lower profile of the actiCAP slim makes it ideal for TMS applications. This allows positioning of the stimulator coil very closely to the head, resulting in minimal loss of TMS pulse power. Combining actiCAP slim with our high sampling rate actiCHamp amplifier, will give you the benefit of ultra-short artifacts. For a more in-depth look at this application field, please click here.
- Easy-to-use holder that further enhances usability and gives you the flexibility to mix and match actiCAP slim electrodes with caps sizes and cap electrode arrangements.
- Allows inserting and removing actiCAP slim electrodes with just a snap and a minimum amount of force. Still provides firm hold, also in mobile environments.
- Different holder colors speed up the setup and prevent electrode placement errors.
- Gives the flexibility of using a single electrode bundle with different cap sizes or combining multiple bundles for one high-density electrode arrangement.
- actiCAP slim: actiCAP slim electrode cap with embedded active electrodes
- actiCAP snap: actiCAP snap electrode cap with slide-in electrode holders, plus actiCAP slim electrode set
Single actiCAP slim active signal electrodes:
actiCAP slim electrodes are also available as single electrodes for applications, where a sensor has to be placed outside of the cap and scalp area, e.g. for EOG or EMG signal registration. They can be fixed quickly and easily with a washer and with or without a holder between the housing and the skin.
Available cable lengths:
- normal cable length: 0,65 m
- long cable length: 1,5 m
Interested in more?
- Learn more about actiCAP slim and snap: Click here
- 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