PHPExcel_Settings::setCacheStorageMethod($cacheMethod);
$objPHPExcel = new PHPExcel();
$width = 0;
$height = 0;
$header = array();
$footer = array();
$type = "Excel";
$file_extension = ".xls";
$objPHPExcel->setActiveSheetIndex(0);
$styleArray = array('fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'FFFFFF')), 'borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('rgb' => '000000'))), 'wrap' => true, 'indent' => 5);
$boldFont = array('font' => array('name' => 'Arial Cyr', 'size' => '10', 'bold' => true, 'color' => array('rgb' => 'FFFFFF')), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => '000000')));
$center = array('alignment' => array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER, 'vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER));
$notBoldFont = array('font' => array('name' => 'Arial Cyr', 'size' => '10', 'bold' => false));
$center_vertical = array('alignment' => array('vertical' => PHPExcel_Style_Alignment::VERTICAL_CENTER));
$letter_num = count($sheetData['cols']);
$letter = XlsExUtils::getLetter($letter_num);
//Adding Columns Names
$columnLetter = 'A';
foreach ($sheetData['cols'] as $colIndex => $colDef) {
$cl = $columnLetter++;
$objPHPExcel->getActiveSheet()->getColumnDimension($cl)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getCell($cl . '1')->setValue($colDef);
$objPHPExcel->getActiveSheet()->getStyle('A1:' . $letter . '1')->applyFromArray($styleArray);
$objPHPExcel->getActiveSheet()->getStyle('A1:' . $letter . '1')->applyFromArray($boldFont);
$objPHPExcel->getActiveSheet()->getStyle('A1:' . $letter . '1')->applyFromArray($center);
}
$currentRow = 2;
//Adding data rows
foreach ($sheetData['data'] as $rowIndex => $row) {
$columnLetter = 'A';
foreach ($row as $colIndex => $colValue_data) {
