require_once(VENDOR_PATH .'PHPExcel/PHPExcel.php');//引入PHP EXCEL类
require_once(VENDOR_PATH .'PHPExcel/PHPExcel/IOFactory.php');//引入PHP EXCEL类
$objPHPExcel = new \PHPExcel();
$col = array( 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',
'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB',
'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO',
'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ' );
$colEcs = array('部门','项目','实例ID','实例名称','私有IP','NatIP','EIP',
'eip带宽','公网IP','网络需求','安全组名称','操作系统','CPU','内存','数据盘','端口',
'备案号','备案网址','备注');
$listEcs = array('workUnit','projectName','objectId','serverName','privateId',
'NatIP','EIP','netNum','extranetIp','netType','vpnsafeName','systemNumber',
'cpu','ram','storageNum','port','recordNum','recordWebsite','ecsAbout'); $colRds = array('部门','项目','实例ID','实例名称','实例类型','数据库类型','网络类型','IOPS',
'最大使用空间(GB)','最大使用内存(MB)','最大连接数','内网连接地址','内网IP地址','端口号','备注');
$listRds = array('workUnit','projectName','objectId','serverName','objectType','dbVer','network',
'IOPS','dbStorage','dbCpu','dbMaxnum','inAddress','inIP','port','rdsAbout');
$objPHPExcel->getActiveSheet(0)->setTitle('ECS');
$objPHPExcel->setActiveSheetIndex(0);
foreach($colEcs as $key=>$v){
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($col[$key].'1',$v);
}
foreach($list['ecs'] as $key => $value){
$key+=2;
foreach ($listEcs as $listK => $listV) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($col[$listK].$key,$value[$listV]);
}
}
for($i=0;$i<count($list['ecs']);$i++){
$objPHPExcel->getActiveSheet(0)->getColumnDimension($col[$i])->setAutoSize(true);
}
$msgWorkSheet = new \PHPExcel_Worksheet($objPHPExcel, 'RDS'); //创建一个工作表
$objPHPExcel->addSheet($msgWorkSheet); //插入工作表
$objPHPExcel->setActiveSheetIndex(1);
foreach($colRds as $key=>$v){
$objPHPExcel->setActiveSheetIndex(1)->setCellValue($col[$key].'1',$v);
}
foreach($list['rds'] as $key => $value){
$key+=2;
foreach ($listRds as $listK => $listV) {
$objPHPExcel->setActiveSheetIndex(1)->setCellValue($col[$listK].$key,$value[$listV]);
}
}
for($i=0;$i<count($list['rds']);$i++){
$objPHPExcel->getActiveSheet(1)->getColumnDimension($col[$i])->setAutoSize(true);
}
ob_end_clean();
$filename = date('YmdHis',time())."项目信息";
header ( 'Content-Type: application/vnd.ms-excel;charset=utf-8' );
header('Content-Disposition: attachment;filename='.$filename.'.xlsx');
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
require_once(VENDOR_PATH .'PHPExcel/PHPExcel/IOFactory.php');//引入PHP EXCEL类
$objPHPExcel = new \PHPExcel();
$col = array( 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M',
'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB',
'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO',
'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ' );
$colEcs = array('部门','项目','实例ID','实例名称','私有IP','NatIP','EIP',
'eip带宽','公网IP','网络需求','安全组名称','操作系统','CPU','内存','数据盘','端口',
'备案号','备案网址','备注');
$listEcs = array('workUnit','projectName','objectId','serverName','privateId',
'NatIP','EIP','netNum','extranetIp','netType','vpnsafeName','systemNumber',
'cpu','ram','storageNum','port','recordNum','recordWebsite','ecsAbout'); $colRds = array('部门','项目','实例ID','实例名称','实例类型','数据库类型','网络类型','IOPS',
'最大使用空间(GB)','最大使用内存(MB)','最大连接数','内网连接地址','内网IP地址','端口号','备注');
$listRds = array('workUnit','projectName','objectId','serverName','objectType','dbVer','network',
'IOPS','dbStorage','dbCpu','dbMaxnum','inAddress','inIP','port','rdsAbout');
$objPHPExcel->getActiveSheet(0)->setTitle('ECS');
$objPHPExcel->setActiveSheetIndex(0);
foreach($colEcs as $key=>$v){
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($col[$key].'1',$v);
}
foreach($list['ecs'] as $key => $value){
$key+=2;
foreach ($listEcs as $listK => $listV) {
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($col[$listK].$key,$value[$listV]);
}
}
for($i=0;$i<count($list['ecs']);$i++){
$objPHPExcel->getActiveSheet(0)->getColumnDimension($col[$i])->setAutoSize(true);
}
$msgWorkSheet = new \PHPExcel_Worksheet($objPHPExcel, 'RDS'); //创建一个工作表
$objPHPExcel->addSheet($msgWorkSheet); //插入工作表
$objPHPExcel->setActiveSheetIndex(1);
foreach($colRds as $key=>$v){
$objPHPExcel->setActiveSheetIndex(1)->setCellValue($col[$key].'1',$v);
}
foreach($list['rds'] as $key => $value){
$key+=2;
foreach ($listRds as $listK => $listV) {
$objPHPExcel->setActiveSheetIndex(1)->setCellValue($col[$listK].$key,$value[$listV]);
}
}
for($i=0;$i<count($list['rds']);$i++){
$objPHPExcel->getActiveSheet(1)->getColumnDimension($col[$i])->setAutoSize(true);
}
ob_end_clean();
$filename = date('YmdHis',time())."项目信息";
header ( 'Content-Type: application/vnd.ms-excel;charset=utf-8' );
header('Content-Disposition: attachment;filename='.$filename.'.xlsx');
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;