$v = @iconv('UTF-8', 'UTF-8//IGNORE', $v);
$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;
if ( (is_numeric($v) && strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.')
||
$dataFormat == 'string' ) {
- if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
- $validator = $this->workbook->addValidator();
-// $validator->setList("a b c");
- $validator->_fixedList = 1;
- $validator->_type = 3;
- $validator->_incell=true;
- $validator->setFormula1('INDEX(B9:B10)');
-
-// $validator->setList('Q2:Q10');
-
- $this->worksheet->setValidation(2,1,2,1,$validator);
- $this->worksheet->_storeDataValidity();
- $this->start_row++;
-
- return $hasRender;
- }
-
$worksheet->writeString($start_row+$r, $c, $v, $format);
-
} else {
$worksheet->write($start_row+$r, $c, $v, $format);