<?php
session_start(); 
$ruta = '../../';
require_once("../clases/covensol_fop_c_formulacion.php");
$objfop=new covensol_fop_c_formulacion($propiedades);
//$objscc->cargar_seguridad("SCC","covensol_scc_d_movimiento.php");
/* PHPExcel */
require_once ($ruta.'shared/PHPExcel/Classes/PHPExcel.php');


// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set properties
$objPHPExcel->getProperties()->setCreator("COVENSOL")
							 ->setLastModifiedBy("COVENSOL")
							 ->setTitle("Office 2007 XLSX Test Document")
							 ->setSubject("Office 2007 XLSX Test Document")
							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
							 ->setKeywords("office 2007 openxml php")
							 ->setCategory("Test result file");

/*
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D2', 'world!');

// Miscellaneous glyphs, UTF-8
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A4', 'Miscellaneous glyphs')
            ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
*/
// Rename sheet
/*
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(8); 
$objPHPExcel->getActiveSheet()->getCell('A1')->setValueExplicit('25', PHPExcel_Cell_DataType::TYPE_NUMERIC);
$objPHPExcel->getActiveSheet()->getCellByColumnAndRow(1, 8)->getValue();
$objPHPExcel->getActiveSheet()->getStyle('A1')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getRowDimension('10')->setRowHeight(100);
$objPHPExcel->getActiveSheet()->insertNewRowBefore(7, 2);
$objPHPExcel->getActiveSheet()->getCell('B8')->getValue();
*/

/*
$objPHPExcel->getActiveSheet()->setTitle('RESUMEN DE PARTIDAS');
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, '100');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, '200');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, '300');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, '400');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, '500');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, '600');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, '700');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, '800');
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THICK);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('B2')->getFill()->getStartColor()->setARGB('FFFF0000');
*/
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B2', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D2', 'world!');

// Miscellaneous glyphs, UTF-8
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A4', 'Miscellaneous glyphs')
            ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');

// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 8, '100');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, 8, '200');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, 8, '300');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(4, 8, '400');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(5, 8, '500');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(6, 8, '600');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(7, 8, '700');
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(8, 8, '800');

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);


// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="01simple.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;