导入excel数据到数据库问题求解

浏览:747 发布日期:2015/09/07 分类:求助交流
Array
(
    [1] => Array
        (
            [A] => id
            [B] => uid
            [C] => map_x
            [D] => map_y
            [E] => radius
            [F] => createtime
            [G] => checkpoint
        )

    [2] => Array
        (
            [A] => 221
            [B] => 35
            [C] => 24.930138
            [D] => 102.872324
            [E] => 2
            [F] => 1439874030
            [G] => PHPExcel_RichText Object
                (
                    [_richTextElements:PHPExcel_RichText:private] => Array
                        (
                            [0] => PHPExcel_RichText_TextElement Object
                                (
                                    [_text:PHPExcel_RichText_TextElement:private] => 19
                                )

                            [1] => PHPExcel_RichText_Run Object
                                (
                                    [_font:PHPExcel_RichText_Run:private] => PHPExcel_Style_Font Object
                                        (
                                            [_name:protected] => 宋体
                                            [_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] => 8
                                        )

                                    [_text:PHPExcel_RichText_TextElement:private] => 段
                                )

                            [2] => 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] => 8
                                        )

                                    [_text:PHPExcel_RichText_TextElement:private] => 1
                                )

                            [3] => PHPExcel_RichText_Run Object
                                (
                                    [_font:PHPExcel_RichText_Run:private] => PHPExcel_Style_Font Object
                                        (
                                            [_name:protected] => 宋体
                                            [_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] => 8
                                        )

                                    [_text:PHPExcel_RichText_TextElement:private] => 号桩
                                )

                        )

                )

        )

    
    

)
A~G 是Excel的列(id,uid,map_x,map_y,radius,createtime,checkpoint)
看第二个G,本来是checkpoint的值,但是在这里却变成了一个那样的对象数组,其实G的值是 19段1号桩,在后面对象数组里不知道怎么把它拆成那样子了,求这个对象要怎么破?
最佳答案
评论( 相关
后面还有条评论,点击查看>>