(
[shop_id] => 3
[name] => 博世有骨雨刮
[sg_id] => 23
[money] => 45
[brand] =>
[spec] =>
[unit] =>
[desc] => PHPExcel_RichText Object
(
[richTextElements:PHPExcel_RichText:private] => Array
(
[0] => PHPExcel_RichText_TextElement Object
(
[text:PHPExcel_RichText_TextElement:private] => Y
)
[1] => PHPExcel_RichText_Run Object
(
[font:PHPExcel_RichText_Run:private] => PHPExcel_Style_Font Object
(
[name:protected] => Calibri
[size:protected] => 11
[bold:protected] =>
[italic:protected] =>
[superScript:protected] =>
[subScript:protected] =>
[underline:protected] => none
[strikethrough:protected] =>
[color:protected] => PHPExcel_Style_Color Object
(
[argb:protected] => FF000000
[parentPropertyName:protected] =>
[isSupervisor:protected] =>
[parent:protected] =>
)
[isSupervisor:protected] =>
[parent:protected] =>
[colorIndex] => 32767
)
[text:PHPExcel_RichText_TextElement:private] => G
)
)
)
[type] => 1
[stock] => 0
[cost] => 23
[sales_bl] => 0.1
[build_bl] => 0.1
[maintain_time] => 0
[safety_stock] => 0
[state] => 1
[create_id] => 3
[create_time] => 1515045837
[shop_id] => 3
[name] => 博世有骨雨刮
[sg_id] => 23
[money] => 45
[brand] =>
[spec] =>
[unit] =>
[desc] => PHPExcel_RichText Object
(
[richTextElements:PHPExcel_RichText:private] => Array
(
[0] => PHPExcel_RichText_TextElement Object
(
[text:PHPExcel_RichText_TextElement:private] => Y
)
[1] => PHPExcel_RichText_Run Object
(
[font:PHPExcel_RichText_Run:private] => PHPExcel_Style_Font Object
(
[name:protected] => Calibri
[size:protected] => 11
[bold:protected] =>
[italic:protected] =>
[superScript:protected] =>
[subScript:protected] =>
[underline:protected] => none
[strikethrough:protected] =>
[color:protected] => PHPExcel_Style_Color Object
(
[argb:protected] => FF000000
[parentPropertyName:protected] =>
[isSupervisor:protected] =>
[parent:protected] =>
)
[isSupervisor:protected] =>
[parent:protected] =>
[colorIndex] => 32767
)
[text:PHPExcel_RichText_TextElement:private] => G
)
)
)
[type] => 1
[stock] => 0
[cost] => 23
[sales_bl] => 0.1
[build_bl] => 0.1
[maintain_time] => 0
[safety_stock] => 0
[state] => 1
[create_id] => 3
[create_time] => 1515045837
)
特殊符号引起的错误
$data[$i-1]['money'] = $objPHPExcel->getActiveSheet()->getCell('C'.$i)->getValue();//售价 $data[$i-1]['brand'] = $objPHPExcel->getActiveSheet()->getCell('D'.$i)->getValue();//品牌 $data[$i-1]['spec'] = $objPHPExcel->getActiveSheet()->getCell('E'.$i)->getValue();//规格 $data[$i-1]['unit'] = $objPHPExcel->getActiveSheet()->getCell('F'.$i)->getValue();//单位 $data[$i-1]['desc'] = (string)$objPHPExcel->getActiveSheet()->getCell('G'.$i)->getValue();//描述用 (string) 进行强制转换