".htmlspecialchars($text)."\n"; $h=fopen("$fn",'r'); $xls_name=xInitTemplate(getenv('DOCUMENT_ROOT').'/tx2xl/templ/total.xlsx', $dateo); $ix=1; while($s=fgets($h)) { //$s=str_replace(" ", " ", $s); $s=preg_replace('/\s+/', ' ', $s); $s=str_replace(" ", "|", $s); $a=explode('|',$s); if(count($a)>0) { foreach($a as $k=>$v) { //echo "$k=$v;
\n"; $v=str_replace(",", ".", $v); $v=trimz($v); if(!is_date($v)) { @$z[$k]+=$v; } #echo "$k=".xCol($k)."
\n"; xData(xCol($k),$ix, $v); } $ix++; } } fclose($h); if(count($z)>0) foreach($z as $k=>$v) { echo Commas($v)." | "; xData(xCol($k),$ix, $v); } echo "
"; xSave("/tx2xl/$dirplace/$xls_name"); echo "Получить Excel"; echo "
"; } ?>