<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php


require_once 'Excel/reader.php';


// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();


// Set output Encoding.
//$data->setOutputEncoding('CP1251');
//$data->setOutputEncoding('CP936');
$data->setOutputEncoding('UTF-8');
/***
* if you want you can change 'iconv' to mb_convert_encoding:
* $data->setUTFEncoder('mb');
*
**/

/***
* By default rows & cols indeces start with 1
* For change initial index use:
* $data->setRowColOffset(0);
*
**/



/***
*  Some function for formatting output.
* $data->setDefaultFormat('%.2f');
* setDefaultFormat - set format for columns with unknown formatting
*
* $data->setColumnFormat(4, '%.3f');
* setColumnFormat - set format for column (apply only to number fields)
*
**/

$data->read('case.xls');

/*


 $data->sheets[0]['numRows'] - count rows
 $data->sheets[0]['numCols'] - count columns
 $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column

 $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell
    
    $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"
        if 'type' == "unknown" - use 'raw' value, because  cell contain value with format '0.00';
    $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format 
    $data->sheets[0]['cellsInfo'][$i][$j]['colspan'] 
    $data->sheets[0]['cellsInfo'][$i][$j]['rowspan'] 
*/

error_reporting(E_ALL ^ E_NOTICE);

//$rs = $data -> getExcelResult();
//print_r($rs);
echo "<table border=1>";
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
	echo "<tr>";
	for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
		$item=$data->sheets[0]['cells'][$i][$j];
		//if(empty($item)){$item=$data->sheets[0]['cells'][$i-1][$j];}
		$item=getitem($data->sheets[0]['cells'],$i,$j);
		$realdata[$i-1][$j-1]=$item;
		echo "<td> "."&nbsp;".$item."</td>";
	}
	echo "</tr>";

}
echo "</table>";

for($i=0;$i<count($realdata);$i++){
	$weburl=$realdata[$i][0];
	$sql="select *";
}





function getitem($arr,$k,$h){
	if($k==1){
		return $arr[$k][$h];
	}
	if(empty($arr[$k][$h])){
		return getitem($arr,$k-1,$h);
	}else{
		return $arr[$k][$h];
	}
}
//print_r($data);
//print_r($data->formatRecords);
?>
