去PHPExcel官网下载相应的版本，放到thinkphp3.2版本下的ThinkPHP/Library/Vendor/PHPExcel文件夹下
导出表格:
//多个单元格（已测试）
public function modeler(){ Vendor('PHPExcel.PHPExcel');
//浏览器输出excel
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="dzg_card_info.xlsx"');
header('Cache-Control: max-age=0'); $objPHPExcel = new \PHPExcel();
$objPHPExcel->setActiveSheetIndex(0); //设置第一个工作表为活动工作表
$objPHPExcel->getActiveSheet()->setTitle('card_info'); //设置工作表名称
//为单元格赋值
//方法①:直接设置单元格的值
/* $objPHPExcel->getActiveSheet()->setCellValue('A1', 'PHPExcel');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 12345.6789);
$objPHPExcel->getActiveSheet()->setCellValue('A3', TRUE); */ //方法②:二维数组
$arrHeader = array(['id', '名字', '技能', '创建时间']);
$arrAllCardInfo = array(['id', '名字', '技能', '创建时间']); //二维数组
$arrExcelInfo = array_merge($arrHeader, $arrAllCardInfo);
//$arrExcelInfo = eval('return ' . iconv('gbk', 'utf-8', var_export($arrExcelInfo, true)) . ';'); //将数组转换成utf-8
$objPHPExcel->getActiveSheet()->fromArray(
$arrExcelInfo, // 赋值的数组
NULL, // 忽略的值,不会在excel中显示
'A1' // 赋值的起始位置
); //创建第二个工作表
$msgWorkSheet = new \PHPExcel_Worksheet($objPHPExcel, 'card_message'); //创建一个工作表
$objPHPExcel->addSheet($msgWorkSheet); //插入工作表
$objPHPExcel->setActiveSheetIndex(1); //切换到新创建的工作表
$arrHeader = array(['id', 'uid', '描述']);
$arrBody = array(['id', 'uid', '描述']);
$arrExcelInfo = array_merge($arrHeader, $arrBody);
//$arrExcelInfo = eval('return ' . iconv('gbk', 'utf-8', var_export($arrExcelInfo, true)) . ';'); //将数组转换成utf-8
$objPHPExcel->getActiveSheet()->fromArray(
$arrExcelInfo, // 赋值的数组
NULL, // 忽略的值,不会在excel中显示
'A1' // 赋值的起始位置
); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel2007");
$objWriter->save('php://output'); $objPHPExcel->disconnectWorksheets();
unset($objPHPExcel); } //多个sheet（ 已测试）
public function moresheet(){
Vendor('PHPExcel.PHPExcel'); //模拟数据
$mulit_arr = array(
array('标题1', '标题2', '标题3'),
array('a', 'b', 'c'),
array('d', 'e', 'f')
);
/* @实例化 */
$obpe = new \PHPExcel(); /* @func 设置文档基本属性 */
$obpe_pro = $obpe->getProperties();
$obpe_pro->setCreator('midoks')//设置创建者
->setLastModifiedBy('2013/2/16 15:00')//设置时间
->setTitle('data')//设置标题
->setSubject('beizhu')//设置备注
->setDescription('miaoshu')//设置描述
->setKeywords('keyword')//设置关键字 | 标记
->setCategory('catagory');//设置类别 /* 设置宽度 */
//$obpe->getActiveSheet()->getColumnDimension()->setAutoSize(true);
//$obpe->getActiveSheet()->getColumnDimension('B')->setWidth(10); //设置当前sheet索引,用于后续的内容操作
//一般用在对个Sheet的时候才需要显示调用
//缺省情况下,PHPExcel会自动创建第一个SHEET被设置SheetIndex=0
//设置SHEET
$obpe->setactivesheetindex(0);
//写入多行数据
foreach($mulit_arr as $k=>$v){
$k = $k+1;
/* @func 设置列 */
$obpe->getactivesheet()->setcellvalue('A'.$k, $v[0]);
$obpe->getactivesheet()->setcellvalue('B'.$k, $v[1]);
$obpe->getactivesheet()->setcellvalue('C'.$k, $v[2]);
} //创建一个新的工作空间(sheet)
$obpe->createSheet();
$obpe->setactivesheetindex(1);
//写入多行数据
foreach($mulit_arr as $k=>$v){
$k = $k+1;
/* @func 设置列 */
$obpe->getactivesheet()->setcellvalue('A'.$k, $v[0]);
$obpe->getactivesheet()->setcellvalue('B'.$k, $v[1]);
$obpe->getactivesheet()->setcellvalue('C'.$k, $v[2]);
} $filename = iconv('utf-8',"gb2312",$filename);//转换名称编码，防止乱码
header ( 'Content-Type: application/vnd.ms-excel;charset=utf-8' );
header ( 'Content-Disposition: attachment;filename="' . $filename . '.xls"' ); //”‘.$filename.’.xls”
header ( 'Cache-Control: max-age=0');
//写入类容
$obwrite = \PHPExcel_IOFactory::createWriter($obpe, 'Excel5'); //保存文件
$obwrite->save ('php://output');
exit;
}
新建实例（已测试能导出导入）
<?php namespace Common\Model;
use Think\Model; /**
* PHPexecl
*/
class PhpexeclModel { public $letter = array(
0=>'A',
1=>'B' ,
2=>'C' ,
3=>'D' ,
4=>'E' ,
5=>'F' ,
6=>'G' ,
7=>'H' ,
8=>'I' ,
9=>'J' ,
10=>'K' ,
11=>'L' ,
12=>'M' ,
13=>'N' ,
14=>'O' ,
15=>'P' ,
16=>'Q' ,
17=>'R' ,
18=>'S' ,
19=>'T' ,
20=>'U' ,
21=>'V' ,
22=>'W' ,
23=>'X' ,
24=>'Y' ,
25=>'Z'
); //创建execl
/** 数据格式一定要这样
*$dx_array = array(
array('省市','目前成本','供应商最低报价'),
array('#f7941d-全国','0','9.5', array(
array('#00a650-海德','9','一手'),
array('#fff100-尚通爱讯','9.5','二手'),
array('#00a650-云联','9.3','三手'),
))
);
*/
function create_execl($filename,$yd_data = array(),$lt_data = array(),$dx_data = array())
{ //导出
Vendor('PHPExcel.PHPExcel');
$filename = iconv('utf-8',"gb2312",$filename);//转换名称编码，防止乱码
header ( 'Content-Type: application/vnd.ms-excel;charset=utf-8' );
header ( 'Content-Disposition: attachment;filename="' . $filename . '.xls"' );
header ( 'Cache-Control: max-age=0'); //创建一个移动表
$objPHPExcel = new \PHPExcel();
$objPHPExcel->setActiveSheetIndex(0); //设置第一个工作表为活动工作表
$objPHPExcel->getActiveSheet()->setTitle('移动'); //设置工作表名称
//设置自动化尺寸
for( $i=0;$i<count($this->letter);$i++){
$objPHPExcel->getActiveSheet()->getColumnDimension($this->letter[$i])->setWidth(30);
} $ydnum = count($yd_data);
$num = 0;
for($i =0;$i < $ydnum;$i++){
$name = "";
if($i == 0){//第一行
foreach($yd_data[$i] as $key=>$value){
$name = $this->letter[$key].'1';
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFont()->setSize(20);
}
}
else{//其他行 $num = ( $i * 3 ) + 2 ;
if(is_array($yd_data[$i])){
foreach($yd_data[$i] as $key=>$value){ if( is_array($value) ){ //供应商信息
//dump($value);echo '<hr />'; foreach($value as $k=>$val){
//echo $k.'--'. print_r($val,true);
//echo '<br>'; //每个公司数据
if( is_array($val) ){ $zimu = $key+$k;
$one = $num - 3;
$two = $num - 2;
$three = $num - 1;
$onename = $this->letter[$zimu].$one;
$twoname = $this->letter[$zimu].$two;
$threename = $this->letter[$zimu].$three; //echo $onename.$twoname.$threename.'<br />';
//echo $val[0].'---'.$val[1].'---'.$val[2].'<br />'; if( empty($val) ){ //供应商
$objPHPExcel->getActiveSheet()->setCellValue($onename, "");
//价格
$objPHPExcel->getActiveSheet()->setCellValue($twoname, "");
//几手资源
$objPHPExcel->getActiveSheet()->setCellValue($threename, ""); }
else{
$arr = explode('-',$val[0]);
//供应商
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->getStartColor()->setRGB( substr( $arr[0] , 1) );
$objPHPExcel->getActiveSheet()->setCellValue($onename, $arr[1]);
//价格
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($twoname, $val[1]);
//几手资源
$objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($threename, $val[2]); } } }
//die;
}
else{ //合并三个单元格
$one = $num - 3;
$two = $num - 2;
$three = $num - 1; $onename = $this->letter[$key].$one.":".$this->letter[$key].$two;
$twoname = $this->letter[$key].$two.":".$this->letter[$key].$three; //合并3个单元格
$objPHPExcel->getActiveSheet()->mergeCells($onename);
$objPHPExcel->getActiveSheet()->mergeCells($twoname); //echo $this->letter[$key].$one.'--<br />';
$name = $this->letter[$key].$one;
//省市
if($key == 0){
$arr = explode('-',$value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->getStartColor()->setRGB( substr( $arr[0] , 1) );
$objPHPExcel->getActiveSheet()->setCellValue($name, $arr[1]); }
else{
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
} } }
} } }
//die; //创建一个联通表
$ltSheet = new \PHPExcel_Worksheet($objPHPExcel, '联通');
$objPHPExcel->addSheet($ltSheet); //插入工作表
$objPHPExcel->setActiveSheetIndex(1); //切换到新创建的工作表 //设置自动化尺寸
for( $i=0;$i<count($this->letter);$i++){
$objPHPExcel->getActiveSheet()->getColumnDimension($this->letter[$i])->setWidth(30);
}
$ydnum = count($lt_data);
$num = 0;
for($i =0;$i < $ydnum;$i++){
$name = "";
if($i == 0){//第一行
foreach($lt_data[$i] as $key=>$value){
$name = $this->letter[$key].'1';
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFont()->setSize(20);
}
}
else{//其他行 $num = ( $i * 3 ) + 2 ;
if(is_array($lt_data[$i])){
foreach($lt_data[$i] as $key=>$value){ if( is_array($value) ){ //供应商信息
//dump($value);echo '<hr />'; foreach($value as $k=>$val){
//echo $k.'--'. print_r($val,true);
//echo '<br>'; //每个公司数据
if( is_array($val) ){ $zimu = $key+$k;
$one = $num - 3;
$two = $num - 2;
$three = $num - 1;
$onename = $this->letter[$zimu].$one;
$twoname = $this->letter[$zimu].$two;
$threename = $this->letter[$zimu].$three; //echo $onename.$twoname.$threename.'<br />';
//echo $val[0].'---'.$val[1].'---'.$val[2].'<br />';
if( empty($val) ){ //供应商
$objPHPExcel->getActiveSheet()->setCellValue($onename, "");
//价格
$objPHPExcel->getActiveSheet()->setCellValue($twoname, "");
//几手资源
$objPHPExcel->getActiveSheet()->setCellValue($threename, ""); }
else{
$arr = explode('-',$val[0]);
//供应商
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($onename, $arr[1]);
//价格
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($twoname, $val[1]);
//几手资源
$objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($threename, $val[2]); } } }
//die;
}
else{ //合并三个单元格
$one = $num - 3;
$two = $num - 2;
$three = $num - 1; $onename = $this->letter[$key].$one.":".$this->letter[$key].$two;
$twoname = $this->letter[$key].$two.":".$this->letter[$key].$three; //合并3个单元格
$objPHPExcel->getActiveSheet()->mergeCells($onename);
$objPHPExcel->getActiveSheet()->mergeCells($twoname); //echo $this->letter[$key].$one.'--<br />';
$name = $this->letter[$key].$one;
//省市
if($key == 0){
$arr = explode('-',$value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->getStartColor()->setRGB( substr( $arr[0] , 1) );
$objPHPExcel->getActiveSheet()->setCellValue($name, $arr[1]); }
else{
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
} } }
} }
} //创建电信工作表
$dxSheet = new \PHPExcel_Worksheet($objPHPExcel, '电信');
$objPHPExcel->addSheet($dxSheet); //插入工作表
$objPHPExcel->setActiveSheetIndex(2); //切换到新创建的工作表 //设置自动化尺寸
for( $i=0;$i<count($this->letter);$i++){
$objPHPExcel->getActiveSheet()->getColumnDimension($this->letter[$i])->setWidth(30);
} $ydnum = count($dx_data);
$num = 0;
for($i =0;$i < $ydnum;$i++){
$name = "";
if($i == 0){//第一行
foreach($dx_data[$i] as $key=>$value){
$name = $this->letter[$key].'1';
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFont()->setSize(20);
}
}
else{//其他行 $num = ( $i * 3 ) + 2 ;
if(is_array($dx_data[$i])){
foreach($dx_data[$i] as $key=>$value){ if( is_array($value) ){ //供应商信息
//dump($value);echo '<hr />'; foreach($value as $k=>$val){
//echo $k.'--'. print_r($val,true);
//echo '<br>'; //每个公司数据
if( is_array($val) ){ $zimu = $key+$k;
$one = $num - 3;
$two = $num - 2;
$three = $num - 1;
$onename = $this->letter[$zimu].$one;
$twoname = $this->letter[$zimu].$two;
$threename = $this->letter[$zimu].$three; //echo $onename.$twoname.$threename.'<br />';
//echo $val[0].'---'.$val[1].'---'.$val[2].'<br />';
if( empty($val) ){ //供应商
$objPHPExcel->getActiveSheet()->setCellValue($onename, "");
//价格
$objPHPExcel->getActiveSheet()->setCellValue($twoname, "");
//几手资源
$objPHPExcel->getActiveSheet()->setCellValue($threename, ""); }
else{
$arr = explode('-',$val[0]); //供应商
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($onename)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($onename, $arr[1]);
//价格
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($twoname)->getFill()->getStartColor()->setRGB(substr($arr[0], 1));
$objPHPExcel->getActiveSheet()->setCellValue($twoname, $val[1]);
//几手资源 $objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($threename)->getFill()->getStartColor()->setRGB(substr($arr[0], 1)); $objPHPExcel->getActiveSheet()->setCellValue($threename, $val[2]); }
} }
//die;
}
else{ //合并三个单元格
$one = $num - 3;
$two = $num - 2;
$three = $num - 1; $onename = $this->letter[$key].$one.":".$this->letter[$key].$two;
$twoname = $this->letter[$key].$two.":".$this->letter[$key].$three; //合并3个单元格
$objPHPExcel->getActiveSheet()->mergeCells($onename);
$objPHPExcel->getActiveSheet()->mergeCells($twoname); //echo $this->letter[$key].$one.'--<br />';
$name = $this->letter[$key].$one;
//省市
if($key == 0){
$arr = explode('-',$value);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle($name)->getFill()->getStartColor()->setRGB( substr( $arr[0] , 1) );
$objPHPExcel->getActiveSheet()->setCellValue($name, $arr[1]); }
else{
$objPHPExcel->getActiveSheet()->setCellValue($name, $value);
} } }
} }
} $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel5");
$objWriter->save('php://output'); $objPHPExcel->disconnectWorksheets();
unset($objPHPExcel);
} //导入数据
public function import_execl( $filename, $oid ){
Vendor('PHPExcel.PHPExcel');
$file_types = explode ( ".", $filename );
$file_type = $file_types [count ( $file_types ) - 1]; if($file_type=="xlsx"){
$PHPExcel = \PHPExcel_IOFactory::createReader('Excel2007');
}else{
$PHPExcel = \PHPExcel_IOFactory::createReader('Excel5');
}
$PHPExcel = $PHPExcel->load($filename); //移动数据
/*
$yd_sheet = $PHPExcel->getSheet(0);
$yd_highestRow = $yd_sheet->getHighestRow(); $company_list = array();
$company_name = $company_price = $company_resources =null;
$province = $province_price = '';
for($i=2;$i<$yd_highestRow;$i++){ //3列为一组
$remainder = $i % 3;
if( $remainder == 2){ //公司名称
$province = $yd_sheet->getCell("A".$i)->getValue();//省市
$province_price = $yd_sheet->getCell("B".$i)->getValue();//省市成本 $company_list[$province]['province'] = $province;
$company_list[$province]['province_price'] = $province_price; for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$company_name = $yd_sheet->getCell($zimu)->getValue(); if( isset($company_name) ){
$company_list[$province]['company_name'][] = $company_name;
} }
}elseif( $remainder == 0){ //价钱
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$company_price = $yd_sheet->getCell($zimu)->getValue(); if( isset($company_price) ){
$company_list[$province]['company_price'][] = $company_price;
} }
}elseif( $remainder == 1){ //几手资源
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$company_resources = $yd_sheet->getCell($zimu)->getValue(); if( isset($company_resources) ){
$company_list[$province]['company_resources'][] = $company_resources;
} } } }
*/ //移动数据
$yd_sheet = $PHPExcel->getSheet(0);
$yd_highestRow = $yd_sheet->getHighestRow(); $yd_company_list = array();
$yd_company_name = $yd_company_price = $yd_company_resources =null;
$yd_province = $yd_province_price = '';
for($i=2;$i<$yd_highestRow;$i++){ //3列为一组
$remainder = $i % 3;
if( $remainder == 2){ //公司名称
$yd_province = $yd_sheet->getCell("A".$i)->getValue();//省市
$yd_province_price = $yd_sheet->getCell("B".$i)->getValue();//省市成本 $yd_company_list[$yd_province]['province'] = $yd_province;
$yd_company_list[$yd_province]['province_price'] = $yd_province_price; for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$yd_company_name = $yd_sheet->getCell($zimu)->getValue(); if( isset($yd_company_name) ){
$yd_company_list[$yd_province]['company_name'][] = $yd_company_name;
} }
}elseif( $remainder == 0){ //价钱
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$yd_company_price = $yd_sheet->getCell($zimu)->getValue(); if( isset($yd_company_price) ){
$yd_company_list[$yd_province]['company_price'][] = $yd_company_price;
} }
}elseif( $remainder == 1){ //几手资源
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$yd_company_resources = $yd_sheet->getCell($zimu)->getValue(); if( isset($yd_company_resources) ){
$yd_company_list[$yd_province]['company_resources'][] = $yd_company_resources;
} } } } //联通数据
/*
$lt_sheet = $PHPExcel->getSheet(1);
$lt_highestRow = $lt_sheet->getHighestRow(); $lt_company_list = array();
$lt_company_name = $lt_company_price = $lt_company_resources =null;
$lt_province = $lt_province_price = '';
for($i=2;$i<$lt_highestRow;$i++){ //3列为一组
$remainder = $i % 3;
if( $remainder == 2){ //公司名称
$lt_province = $lt_sheet->getCell("A".$i)->getValue();//省市
$lt_province_price = $lt_sheet->getCell("B".$i)->getValue();//省市成本 $lt_company_list[$lt_province]['province'] = $lt_province;
$lt_company_list[$lt_province]['province_price'] = $lt_province_price; for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$lt_company_name = $lt_sheet->getCell($zimu)->getValue(); if( isset($lt_company_name) ){
$lt_company_list[$lt_province]['company_name'][] = $lt_company_name;
} }
}elseif( $remainder == 0){ //价钱
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$lt_company_price = $lt_sheet->getCell($zimu)->getValue(); if( isset($lt_company_price) ){
$lt_company_list[$lt_province]['company_price'][] = $lt_company_price;
} }
}elseif( $remainder == 1){ //几手资源
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$lt_company_resources = $lt_sheet->getCell($zimu)->getValue(); if( isset($lt_company_resources) ){
$lt_company_list[$lt_province]['company_resources'][] = $lt_company_resources;
} } } }
*/ //电信数据
/*
$dx_sheet = $PHPExcel->getSheet(2);
$dx_highestRow = $dx_sheet->getHighestRow(); $dx_company_list = array();
$dx_company_name = $dx_company_price = $dx_company_resources =null;
$dx_province = $dx_province_price = '';
for($i=2;$i<$dx_highestRow;$i++){ //3列为一组
$remainder = $i % 3;
if( $remainder == 2){ //公司名称
$dx_province = $dx_sheet->getCell("A".$i)->getValue();//省市
$dx_province_price = $dx_sheet->getCell("B".$i)->getValue();//省市成本 $dx_company_list[$dx_province]['province'] = $dx_province;
$dx_company_list[$dx_province]['province_price'] = $dx_province_price; for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$dx_company_name = $dx_sheet->getCell($zimu)->getValue(); if( isset($dx_company_name) ){
$dx_company_list[$dx_province]['company_name'][] = $dx_company_name;
} }
}elseif( $remainder == 0){ //价钱
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$dx_company_price = $dx_sheet->getCell($zimu)->getValue(); if( isset($dx_company_price) ){
$dx_company_list[$dx_province]['company_price'][] = $dx_company_price;
} }
}elseif( $remainder == 1){ //几手资源
for($j=3;$j<26;$j++){
$zimu = $this->letter[$j].$i;
$dx_company_resources = $dx_sheet->getCell($zimu)->getValue(); if( isset($dx_company_resources) ){
$dx_company_list[$dx_province]['company_resources'][] = $dx_company_resources;
} } } }
*/ dump($yd_company_list); //获取到移动相应的数据 $company_list
//dump($company_list);
//dump($lt_company_list); } }