Beispiel #1
0
 function _load(TikiSheet &$sheet)
 {
     $d = $this->data;
     foreach ($d->metadata->widths as $c => $width) {
     }
     foreach ($d->rows as $r => $row) {
         foreach ($row->columns as $c => $column) {
             $sheet->initCell($r, $c);
             //if cell has formula, use it, otherwise, use value, if value if blank, use ''
             if (!empty($column->formula)) {
                 $sheet->setCalculation($column->formula);
             } else {
                 $sheet->setValue(isset($column->value) ? $column->value : '');
             }
             //Make cell able to span multi columns and rows
             $rowSpan = 1;
             $colSpan = 1;
             if (isset($column->rowspan)) {
                 $rowSpan = $column->rowspan;
             }
             if (isset($column->colspan)) {
                 $colSpan = $column->colspan;
             }
             $sheet->setRowSpan($rowSpan);
             $sheet->setColSpan($colSpan);
             $sheet->setDeadCells();
             //setup cell css style
             if (!empty($column->style)) {
                 $sheet->setStyle($column->style);
             }
             //setup cell html class
             if (isset($column->class)) {
                 $sheet->setClass($column->class);
             }
         }
     }
     return true;
 }
Beispiel #2
0
 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;
 }