dongliang1654 2014-03-20 13:02
浏览 20

Symfony2:导出csv错误

I am doing data exporting by CSV format.

Problem : When data contains white space then it jumps column in csv file

enter image description here

In Image check at customer_id = 8

in address1 correct value is "starline appartment" But "starline" stay in address1 and "appartment" goes in address2.

This is controller code

$em = $this->getDoctrine()->getManager('db1');
        $connection = $em->getConnection();

        $query = "SELECT * 
                  FROM customers
                  ORDER BY customer_id ASC
                  LIMIT 10";
        $statement = $connection->prepare($query);
        $statement->execute();
        $rows = $statement->fetchAll();
        $columns = $em->getClassMetadata('AdminSporteventsBundle:Customers')->getFieldNames();
        foreach ($columns as $value) {
            $finalcolumns[] = strtolower(preg_replace('/\B([A-Z])/', '_$1', $value));
        }        
        //echo "<pre>";print_r($rows);echo "</pre>";die;
        $response = $this->render('AdminSporteventsBundle:Export:export.csv.twig', array('data' => $rows));
        $filename = "export_".date("Y_m_d_His").".csv";
        $response->headers->set('Content-Type', 'text/csv');
        $response->headers->set('Content-Disposition', 'attachment; filename='.$filename);
        return $response;

And this is my view file code

cusromer_id, email_id, facebook_id, password, forname, surname, house_no, address1, address2, town, country, postcode, mobile, telepnone, created_date, updated_date
{% for customer in data %}
{{ customer.customer_id }}, {{ customer.email_id }}, {{ customer.facebook_id }}, {{ customer.password }}, {{ customer.forname }}, {{ customer.surname }}, {{ customer.house_no }}, {{ customer.address1 }}, {{ customer.address2 }}, {{ customer.town }}, {{ customer.country }}, {{ customer.postcode }}, {{ customer.mobile }}, {{ customer.telepnone }}, {{ customer.created_date }}, {{ customer.updated_date }}
{% endfor %}

So what can I do to solved this ?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行