PHP，Excel导出换行

﹏ヽ暗。殇╰゛Y 2021-11-09 02:06 388阅读 0赞

![422101-20190709115912784-1239224222.png][]

// 有id，才算真的有发票数据
    if ($v['b_invoice_id']) {
        $v['b_invoice_info'] = json_decode($v['b_invoice_json'],true);
        $v['b_invoice_str'] .= '类型:';
        if ((int)$v['b_invoice_purchase'] === 1) { $v['b_invoice_str'] .='(收购)'; }
        if ((int)$v['b_invoice_info']['type'] === 1) { $v['b_invoice_str'] .='普通发票'; } else { $v['b_invoice_str'] .= '专用发票'; }
        $v['b_invoice_str'] .= "\r\n公司名称/姓名:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_name'];
        $v['b_invoice_str'] .= "\r\n识别号/身份证:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_tax'];
        $v['b_invoice_str'] .= "\r\n电话:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_telephone']?:'无';
        $v['b_invoice_str'] .= "\r\n地址:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_address']?:'无';
        $v['b_invoice_str'] .= "\r\n开户行:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_bank']?:'无';
        $v['b_invoice_str'] .= "\r\n开户账号:";
        $v['b_invoice_str'] .= $v['b_invoice_info']['company_account']?:'无';
    } else {
        $v['b_invoice_info'] = [];
    }
    if ($v['c_invoice_id']) {
        $v['c_invoice_info'] = json_decode($v['c_invoice_json'],true);
        $v['c_invoice_str'] .= '类型:';
        if ((int)$v['c_invoice_info']['type'] === 1) { $v['c_invoice_str'] .='普通发票'; } else { $v['c_invoice_str'] .= '专用发票'; }
        $v['c_invoice_str'] .= "\r\n公司名称:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_name'];
        $v['c_invoice_str'] .= "\r\n识别号:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_tax'];
        $v['c_invoice_str'] .= "\r\n电话:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_telephone']?:'无';
        $v['c_invoice_str'] .= "\r\n地址:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_address']?:'无';
        $v['c_invoice_str'] .= "\r\n开户行:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_bank']?:'无';
        $v['c_invoice_str'] .= "\r\n开户账号:";
        $v['c_invoice_str'] .= $v['c_invoice_info']['company_account']?:'无';
    }

`\r\n`  
必须是双引号。

转载于:https://www.cnblogs.com/jiqing9006/p/11156448.html

[422101-20190709115912784-1239224222.png]: /images/20211109/261b99d54b4845d798e62f2e987cb286.png