$cfg['formats'] = isset($cfg['formats']) ? $cfg['formats'] : array();
foreach($cfg['formats'] as $f=>$fcfg) {
+
$formats[$f] = & $workbook->addFormat();
- foreach($fcfg as $k=>$v) {
+ foreach((array)$fcfg as $k=>$v) {
$formats[$f]->{'set' . $k}($v);
}
// copy the config and alias so that book can be written to..
$this->worksheet_cfg[$cfg['workbook']] = &$cfg;
- $this->formats = $formats;
+
+ //$this->formats = (array)$formats;
+
+ if (isset($cfg['formats']) && empty($formats)) {
+
+ foreach($cfg['formats'] as $f=>$fcfg) {
+
+ $formats[$f] = & $workbook->addFormat();
+ foreach((array)$fcfg as $k=>$v) {
+ $formats[$f]->{'set' . $k}($v);
+ }
+
+ }
+
+ $this->formats = $formats;
+ }
+
+
+
//var_dump($cfg['workbook']);
$worksheet = $workbook->addWorksheet($cfg['workbook']);
$hasRender = false;
+ if (empty($data)) {
+ return;
+ }
+
foreach($data as $r=>$clo) {
$hasRenderRow = $this->addLine($cfg['workbook'], $clo);
{
$cfg = $this->worksheet_cfg[$worksheet_name];
$start_row = $this->start_row;
- $formats = $this->formats;
+ $formats = (array)$this->formats;
$worksheet = $this->worksheet;
$hasRender = false;
$v = @iconv('UTF-8', 'UTF-8//IGNORE', $v);
- $dataFormat = empty($col_cfg['dataFormat']) ? '' $col_cfg['dataFormat']:
+ $dataFormat = empty($col_cfg['dataFormat']) ? '' : $col_cfg['dataFormat'];
+ ;
+
+
$format = isset($col_cfg['format']) && isset($formats[$col_cfg['format']] ) ? $formats[$col_cfg['format']] : false;
// print_R(array($start_row+$r, $c, $v, $format));exit;
// handle 0 prefixes..