Source for file example.php
Documentation is available at example.php
require_once 'Excel/reader.php';
// ExcelFile($filename, $encoding);
//$data->setOutputEncoding('CP1251');
* 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('testfile.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']
for ($i =
1; $i <=
$data->sheets[0]['numRows']; $i++
) {
for ($j =
1; $j <=
$data->sheets[0]['numCols']; $j++
) {
echo
"\"".
$data->sheets[0]['cells'][$i][$j].
"\",";
//print_r($data->formatRecords);
Documentation generated on Thu, 08 Jan 2009 17:44:06 +0100 by phpDocumentor 1.4.0a2