function readxls($ifile, $name = 0, $onelist = false, $onlynew = false, $showlists = false, $list = false, $descr = false, $id = false, $nokey = false, $param = false, $obj = 0, $reverse = 0, $isname = 0)
{
$file = infra_theme($ifile, 'f');
if (!$file) {
return array();
}
$list = infra_toutf($list);
$id = infra_toutf($id);
$name = $name;
$obj = (int) $obj;
$data = pages_cache(array($file), 'readxlsmain', array($file));
/*foreach($data['boundsheets'] as &$sheet){
$sheet['name']=trim($sheet['name']);
}
foreach($data['sheets'] as &$sheet){
$sheet['name']=trim($sheet['name']);
foreach($sheet['cells'] as &$row){
foreach($row as $k=>$cell){
$row[$k]=trim($cell);
}
}
}*/
if ($showlists) {
$r = array();
for ($i = 0, $l = sizeof($data['boundsheets']); $i < $l; ++$i) {
if ($data['boundsheets'][$i]['name'][0] == '.') {
continue;
}
if (!$name) {
array_push($r, $data['boundsheets'][$i]['name']);
} else {
$r[$data['boundsheets'][$i]['name']] = 1;
}
}
$result = $r;
} else {
$r = array();
for ($i = 0, $l = sizeof($data['boundsheets']); $i < $l; ++$i) {
if (!$data['sheets'][$i]['cells']) {
continue;
}
$listname = trim($data['boundsheets'][$i]['name']);
if (!$param && $name) {
if ($name == 'auto') {
$test = $data['sheets'][$i]['cells'];
$temp = 0;
$find = false;
foreach ($test as $v) {
++$temp;
if (sizeof($v) > 2) {
$find = true;
break;
}
}
if (!$find) {
if ($isname) {
$find = true;
++$temp;
} else {
$temp = 1;
}
}
} else {
$temp = $name;
}
$descrdata = array();
while ($temp > 1) {
$descrd = array_shift($data['sheets'][$i]['cells']);
$descrdata[] = $descrd;
--$temp;
}
$names = array_shift($data['sheets'][$i]['cells']);
//$data['sheets'][$i]['cells']=array_values($data['sheets'][$i]['cells']);
if ($descr) {
if ($descr == 1) {
$descrd = array();
foreach ($descrdata as $v) {
$ii = 0;
foreach ($v as $jj) {
if (!$ii) {
$ii = $jj;
} else {
$descrd[$ii] = $jj;
break;
}
}
}
} else {
$descrd = $descrdata;
}
} else {
$result = $r;
}
$r[$listname] = array();
for ($j = 0, $k = sizeof($data['sheets'][$i]['cells']); $j < $k; ++$j) {
$r[$listname][$j] = array();
foreach ($names as $num => $value) {
@($r[$listname][$j][$value] = $data['sheets'][$i]['cells'][$j][$num]);
}
}
if ($descr) {
$d = $r[$listname];
unset($r[$listname]);
$r[$listname]['data'] = $d;
$r[$listname]['descr'] = $descrd;
}
} else {
$r[$data['boundsheets'][$i]['name']] = array_values($data['sheets'][$i]['cells']);
foreach ($r[$data['boundsheets'][$i]['name']] as $k => $v) {
$r[$data['boundsheets'][$i]['name']][$k] = array_values($r[$data['boundsheets'][$i]['name']][$k]);
}
//$r[$data['boundsheets'][$i]['name']]
}
}
if ($reverse) {
foreach ($r as $l => $d) {
if ($descr) {
$r[$l]['data'] = array_reverse($r[$l]['data'], true);
} else {
$r[$l] = array_reverse($r[$l], true);
}
}
}
if ($onelist || $list) {
if ($list) {
$r = $r[$list];
} else {
foreach ($r as $l) {
$r = $l;
break;
}
}
}
$result = $r;
if ($param) {
if ($onelist) {
$newres = array();
for ($i = (int) $name, $l = sizeof($result); $i < $l; ++$i) {
$newres[$result[$i][0]] = $result[$i][1];
}
$result = $newres;
} else {
foreach ($result as $k => $list) {
$newres = array();
for ($i = (int) $name, $l = sizeof($list); $i < $l; ++$i) {
$newres[$list[$i][0]] = $list[$i][1];
}
$result[$k] = $newres;
}
}
} else {
if ($id && $name) {
if ($descr) {
$res = $result['data'];
} else {
$res = $result;
}
$newres = array();
for ($i = 0, $l = sizeof($res); $i < $l; ++$i) {
$newres[$res[$i][$id]] = $res[$i];
//unset($newres[$res[$i][$id]][$id]);
}
if ($descr) {
$result['data'] = $newres;
} else {
$result = $newres;
}
}
if ($nokey) {
foreach ($result as $k => &$v) {
$result[$k] = array_values($result[$k]);
}
}
}
}
return $result;
}
<?php
/*
Copyright 2008 ITLife, Ltd. Togliatti, Samara Oblast, Russian Federation. http://itlife-studio.ru
*ready for include
*using modified
History
13.05.2010 modified
*/
require_once __DIR__ . '/../../pages/xls/excel_parser/oleread.php';
require_once __DIR__ . '/../../pages/xls/excel_parser/reader.php';
require_once __DIR__ . '/../../pages/xls/xlstojs.inc.php';
require_once __DIR__ . '/../../infra/infra.php';
if (!isset($_GET['src'])) {
?>
Парсер Excel
<?php
} else {
$src = infra_theme($_GET['src']);
$data = pages_cache(array($src), 'readxls', array($src, $_GET['name'], $_GET['onelist'], $_GET['onlynew'], $_GET['showlists'], $_GET['list'], $_GET['descr'], $_GET['id'], $_GET['nokey'], $_GET['param'], $_GET['obj'], $_GET['reverse'], $_GET['isname']), (bool) $_GET['reparse']);
/*echo '<pre>';
print_r(infra_tophp($data123));
exit;*/
return infra_echo($data);
}
