1.原始效果
2.修改后效果
3.修改php代码部分
4.修改代码如下标红
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;"> '.$val['order_sn'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['client_name'].' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['delivery_phone'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['consignee'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['delivery_phone'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['delivery_province'].'#'.$val['delivery_city'].'#'.$val['delivery_area'].'#'.$val['delivery_address'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;vnd.ms-excel.numberformat:@">'.$v['goods_keynum'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$v['goods_name'].' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$v['goods_num'].' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$v['goods_price'].' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$val['goods_total'].'</td>';
$strTable .= '<td style="text-align:left;font-size:12px;">'.$orderType.'</td>';
$strTable .= '</tr>';