<?php
	set_time_limit(0);
	ini_set('memory_limit', '-1');
	date_default_timezone_set("Europe/Moscow");
	require_once 'php/Classes/PHPExcel.php';
	require_once 'php/Classes/PHPExcel/IOFactory.php';

	
	
	$objPHPExcel = PHPExcel_IOFactory::load("./excel/templates/Шаблон1.xlsx");
	$objPHPExcel->setActiveSheetIndex(0);
	
	$style = array('borders' => array(
			'bottom'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'right'		=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'top'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'left'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN)
		)
	);
	$style_double = array('borders' => array(
			'bottom'	=> array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),
			'right'		=> array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),
			'top'	=> array('style' => PHPExcel_Style_Border::BORDER_DOUBLE),
			'left'	=> array('style' => PHPExcel_Style_Border::BORDER_DOUBLE)
		)
	);
	$style_bottomless = array('borders' => array(
			'right'		=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'top'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'left'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN)
		)
	);
	$style_topless = array('borders' => array(
			'bottom'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'right'		=> array('style' => PHPExcel_Style_Border::BORDER_THIN),
			'left'	=> array('style' => PHPExcel_Style_Border::BORDER_THIN)
		)
	);
	
	$objPHPExcel->getDefaultStyle()->getFont()->setName('Times New Roman');
	$objPHPExcel->getDefaultStyle()->getFont()->setSize(10.5);
	
	
	
	if(isset($_POST['upload'])){
		$whitelist = array(".csv");         
		$data = array();
		$error = true;
		foreach  ($whitelist as  $item) {
			if(preg_match("/$item\$/i",$_FILES['userfile']['name'])) $error = false;
		}
		if(!$error){
			$uploadedFile =  "csv/".$_FILES['userfile']['name'];	
			if(is_uploaded_file($_FILES['userfile']['tmp_name'])){
			
				if(move_uploaded_file($_FILES['userfile']['tmp_name'],$uploadedFile)){
			
					$data = $_FILES['userfile'];
					$flag = 1;
				}
			}
		}
	}
	
	$f = fopen("csv/".$csvname, "r");
	$csv = fgetcsv($f, 1000, ';');
	$i = 0;
	//10*$i + 1
	while($csv){
		//1 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 1)->setRowHeight(40);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 1).':DD'.(10*$i + 1));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1).':DD'.(10*$i + 1))->applyFromArray($style_double);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 1), iconv("Windows-1251", "UTF-8", "Характеристики помещений в многоквартирном доме"));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1))->getFont()->setSize(13);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//2 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 2)->setRowHeight(60);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 2).':G'.(10*$i + 2));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 2).':BA'.(10*$i + 2));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 2).':DD'.(10*$i + 2));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2).':G'.(10*$i + 2))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2).':BA'.(10*$i + 2))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2).':DD'.(10*$i + 2))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 2), iconv("Windows-1251", "UTF-8", "№\nп/п"));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 2), iconv("Windows-1251", "UTF-8", "Наименование\nхарактеристики"));
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 2), iconv("Windows-1251", "UTF-8", "Значение характеристики"));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 2))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 2))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 2))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//3 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 3)->setRowHeight(20);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 3).':G'.(10*$i + 3));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 3).':BA'.(10*$i + 3));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 3).':DD'.(10*$i + 3));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3).':G'.(10*$i + 3))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3).':BA'.(10*$i + 3))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3).':DD'.(10*$i + 3))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 3), iconv("Windows-1251", "UTF-8", "1"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 3), iconv("Windows-1251", "UTF-8", "2"));
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 3), iconv("Windows-1251", "UTF-8", "3"));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//4 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 4)->setRowHeight(60);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 4).':G'.(10*$i + 4));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 4).':BA'.(10*$i + 4));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 4).':DD'.(10*$i + 4));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4).':G'.(10*$i + 4))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4).':BA'.(10*$i + 4))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4).':DD'.(10*$i + 4))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 4), iconv("Windows-1251", "UTF-8", "1"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 4), iconv("Windows-1251", "UTF-8", "Кадастровый номер либо ранее присвоенный государственный учетный номер помещения (кадастрвоый, инвентарный или условный номер)"));
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 4), iconv("Windows-1251", "UTF-8", "—"));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 4))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 4))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 4))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//5 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 5)->setRowHeight(43.5);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 5).':G'.(10*$i + 5));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 5).':BA'.(10*$i + 5));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 5).':DD'.(10*$i + 5));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5).':G'.(10*$i + 5))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5).':BA'.(10*$i + 5))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5).':DD'.(10*$i + 5))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 5), iconv("Windows-1251", "UTF-8", "2"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 5), iconv("Windows-1251", "UTF-8", "Номер, обозначенние этажа (этажей), на котором (которых) расположено помещение"));
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getAlignment()->setWrapText(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 5), iconv("Windows-1251", "UTF-8", $csv[2]));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 5))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 5))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 5))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//6 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 6)->setRowHeight(30);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 6).':G'.(10*$i + 6));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 6).':BA'.(10*$i + 6));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 6).':DD'.(10*$i + 6));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6).':G'.(10*$i + 6))->applyFromArray($style_bottomless);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6).':BA'.(10*$i + 6))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6).':DD'.(10*$i + 6))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 6), iconv("Windows-1251", "UTF-8", "3"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 6), iconv("Windows-1251", "UTF-8", "Адрес (описание местоположения)"));
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getAlignment()->setWrapText(true);
		$address = $_POST['address'];
		if($csv[3] == "1"){
			$address .= " , кв. ".$csv[0];
		}
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 6), iconv("Windows-1251", "UTF-8", $address));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 6))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 6))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 6))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//7 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 7)->setRowHeight(30);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 7).':G'.(10*$i + 7));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 7).':BA'.(10*$i + 7));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 7).':DD'.(10*$i + 7));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7).':G'.(10*$i + 7))->applyFromArray($style_topless);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7).':BA'.(10*$i + 7))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7).':DD'.(10*$i + 7))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 7), iconv("Windows-1251", "UTF-8", ""));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "Иное описание местоположения"));
		if($csv[3] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "—"));
		}
		if($csv[3] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "нежилое помещение ".$csv[0]));
		}
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 7))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 7))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 7))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//8 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 8)->setRowHeight(30);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 8).':G'.(10*$i + 8));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 8).':BA'.(10*$i + 8));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 8).':DD'.(10*$i + 8));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8).':G'.(10*$i + 8))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8).':BA'.(10*$i + 8))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8).':DD'.(10*$i + 8))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "4"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Назначение помещения"));
		if($csv[3] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Жилое"));
		}
		if($csv[3] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Нежилое"));
		}
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 8))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 8))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 8))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//9 строка------------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 9)->setRowHeight(30);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 9).':G'.(10*$i + 9));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 9).':BA'.(10*$i + 9));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 9).':DD'.(10*$i + 9));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9).':G'.(10*$i + 9))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9).':BA'.(10*$i + 9))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9).':DD'.(10*$i + 9))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "5"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "Вид жилого помещения"));
		if($csv[3] == "1"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "Квартира"));
		}
		if($csv[3] == "2"){
			$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "—"));
		}
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 9))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 9))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 9))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		//10 строка-----------------------------------------------------------------------------------------------------------------------------------------------
		$objPHPExcel->getActiveSheet()->getRowDimension(10*$i + 10)->setRowHeight(30);
		$objPHPExcel->getActiveSheet()->mergeCells('A'.(10*$i + 10).':G'.(10*$i + 10));
		$objPHPExcel->getActiveSheet()->mergeCells('H'.(10*$i + 10).':BA'.(10*$i + 10));
		$objPHPExcel->getActiveSheet()->mergeCells('BB'.(10*$i + 10).':DD'.(10*$i + 10));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10).':G'.(10*$i + 10))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10).':BA'.(10*$i + 10))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10).':DD'.(10*$i + 10))->applyFromArray($style);
		$objPHPExcel->getActiveSheet()->setCellValue('A'.(10*$i + 10), iconv("Windows-1251", "UTF-8", "6"));
		$objPHPExcel->getActiveSheet()->setCellValue('H'.(10*$i + 10), iconv("Windows-1251", "UTF-8", 'Площадь помещения (P), кв. м'));
		//$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
		$objPHPExcel->getActiveSheet()->setCellValue('BB'.(10*$i + 10), iconv("Windows-1251", "UTF-8", number_format($csv[1], 1, '.', '')));
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getFont()->setName('Times New Roman');
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getFont()->setSize(10.5);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getFont()->setBold(true);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 10))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
		$objPHPExcel->getActiveSheet()->getStyle('H'.(10*$i + 10))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		$objPHPExcel->getActiveSheet()->getStyle('BB'.(10*$i + 10))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
		
		$objPHPExcel->getActiveSheet()->getStyle('A'.(10*$i + 1).':DD'.(10*$i + 10))->applyFromArray($style_double);
		
		//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 4), iconv("Windows-1251", "UTF-8", "—"));
		//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 5), iconv("Windows-1251", "UTF-8", $csv[2]));
		/*$address = $_POST['address'];
		if($csv[3] == "1"){
			$address .= " , кв. ".$csv[0];
		}
		$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 6), iconv("Windows-1251", "UTF-8", $address));*/
		if($csv[3] == "1"){
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "—"));
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Жилое"));
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "Квартира"));
		}
		if($csv[3] == "2"){
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 7), iconv("Windows-1251", "UTF-8", "нежилое помещение ".$csv[0]));
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 8), iconv("Windows-1251", "UTF-8", "Нежилое"));
			//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 9), iconv("Windows-1251", "UTF-8", "—"));
		}
		//$objPHPExcel->getActiveSheet()->setCellValue('BC'.(10*$i + 10), iconv("Windows-1251", "UTF-8", $csv[1]));
		$csv = fgetcsv($f, 1000, ';');
		$i++;
	}
	fclose($f);
	
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
	$objWriter->save("csv/".$csvname.".xlsx");
	
	
	$filename = "Результат.xlsx";
	$file="csv/".$csvname.".xlsx";
	$size = filesize($file);
	header("Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
	header("Content-Length: ".$size);
	header("Content-Disposition: attachment; filename=".$filename."");
	readfile($file);
?>