Example #1
0
     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, ' ');