PHP,Excel导出换行

// 有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
必须是双引号。

posted @ 2019-07-09 12:00  TBHacker  阅读(1455)  评论(0编辑  收藏  举报