function _load(TikiSheet &$sheet)
{
$document = new Spreadsheet_Excel_Reader();
if (!$document->read($this->file)) {
return false;
}
$data = $document->sheets[0];
if (is_array($data['cells'])) {
foreach ($data['cells'] as $row => $cols) {
if (is_array($cols)) {
foreach ($cols as $col => $value) {
$sheet->initCell($row, $col);
$info = $data['cellsInfo'][$row][$col];
if (!isset($info['rowspan'])) {
$height = 1;
} else {
$height = $info['rowspan'];
}
if (!isset($info['colspan'])) {
$width = 1;
} else {
$width = $info['colspan'];
}
$cellValue = $this->encoding->convert_encoding($value);
$sheet->setValue($cellValue);
if (isset($cellValue)) {
if (strlen($cellValue)) {
if ($cellValue[0] == '=') {
$sheet->setCalculation(substr($cellValue, 1));
} else {
$sheet->setCalculation($cellValue);
}
}
}
$sheet->setSize($width, $height);
}
}
}
}
return true;
}
function _load(TikiSheet &$sheet)
{
$d = $this->data;
$rows = (int) $d->metadata->rows;
$cols = (int) $d->metadata->columns;
for ($r = 0; $r < $rows; $r++) {
for ($c = 0; $c < $cols; $c++) {
$ri = 'r' . $r;
$ci = 'c' . $c;
if (isset($d->data->{$ri}->{$ci}->value)) {
$val = $d->data->{$ri}->{$ci}->value;
} else {
$val = '';
}
$sheet->initCell($r, $c);
if (isset($d->data->{$ri}->{$ci}->width) || isset($d->data->{$ri}->{$ci}->height)) {
$sheet->setSize(isset($d->data->{$ri}->{$ci}->width) ? $d->data->{$ri}->{$ci}->width : 1, isset($d->data->{$ri}->{$ci}->height) ? $d->data->{$ri}->{$ci}->height : 1);
} else {
$sheet->setSize(1, 1);
}
$sheet->setValue($val);
if (isset($d->data->{$ri}->{$ci}->formula)) {
$formula = substr($d->data->{$ri}->{$ci}->formula, 1, strlen($d->data->{$ri}->{$ci}->formula) - 1);
if (!empty($formula)) {
$sheet->setCalculation($formula);
}
}
if (isset($d->data->{$ri}->{$ci}->stl)) {
$style = $d->data->{$ri}->{$ci}->stl;
if (!empty($style)) {
$sheet->setStyle($style);
}
}
if (isset($d->data->{$ri}->{$ci}->cl)) {
$class = $d->data->{$ri}->{$ci}->cl;
if (!empty($class)) {
$sheet->setClass($class);
}
}
}
}
return true;
}
