case '家庭成员': $contact1_re = 8; break; case '朋友': $contact1_re = 6; break; case '商业伙伴': $contact1_re = 5; break; default: $contact1_re = 8; break; } $contact1_tel = $v['contact1_tel'] ? substr($v['contact1_tel'], 0, 7) . 'XXXX' : '暂缺'; /* @func 设置列 */ $obpe->getactivesheet()->setcellvalue('A' . $k, $p2p); $obpe->getactivesheet()->setcellvalue('B' . $k, $v["real_name"]); $obpe->getactivesheet()->setcellvalue('C' . $k, '0'); $obpe->getActiveSheet()->setCellValueExplicit('D' . $k, $v["idcard"], PHPExcel_Cell_DataType::TYPE_STRING); $obpe->getactivesheet()->setcellvalue('E' . $k, $sex); $obpe->getactivesheet()->setcellvalue('F' . $k, $both); $obpe->getactivesheet()->setcellvalue('G' . $k, $marry); $obpe->getactivesheet()->setcellvalue('H' . $k, $education); $obpe->getactivesheet()->setcellvalue('I' . $k, '9'); $obpe->getactivesheet()->setcellvalue('J' . $k, ' '); $obpe->getactivesheet()->setcellvalue('K' . $k, ' '); $obpe->getactivesheet()->setcellvalue('L' . $k, ' '); $obpe->getactivesheet()->setcellvalue('M' . $k, ' '); $obpe->getactivesheet()->setcellvalue('N' . $k, $address); $obpe->getactivesheet()->setcellvalue('O' . $k, '999999'); $obpe->getactivesheet()->setcellvalue('P' . $k, ' ');