setOutputEncoding('CP1251'); if($_GET["file"] == "alphabetical"){ $data->read('staff_alphabetical.xls'); } else { $data->read('staff_department.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'] */ ?> sheets[0]['numRows']; $i++) { echo ""; for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { if($j == "1"){ echo ""; } else { echo ""; } } echo ""; } echo "

Name	Department	Phone
".$data->sheets[0]['cells'][$i][$j]."	".$data->sheets[0]['cells'][$i][$j]."

" //print_r($data); //print_r($data->formatRecords); ?>