0
estou tentanto gerar um arquivo excel do meu relatório. com a classe PHPExcel eu conseguir salvar o arquivo numa pasta do sistema. Quando o usuário coloca para abrir ou salvar o arquivo, ele fica todo criptografado.
alguem sabe o que pode ser isso.
//new PHPExcel object
$objPHPExcel = new PHPExcel();
//define propriedades do arquivo
$objPHPExcel->getActiveSheet()->setTitle("Relatorio");
//Create a first sheet, representing sales data
$objPHPExcel->setActiveSheetIndex(0);
//titulo do relatorio
$objPHPExcel->getActiveSheet()->setCellValue('B1',utf8_encode('RELACÃO DE CONTRATO(S) GERAL(IS) DE EMPRESA'));
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
/** PHPExcel_IOFactory */
require_once '../Biblioteca/PHPEXCEL/Classes/PHPExcel/IOFactory.php';
$data_atual = date("YmdHis");
//salva o arquivo para excel
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', $data_atual.'.xls', __FILE__));
$filename = "relatorio_contratos_geral_empresa_print_excel".$data_atual.".xls";
header('Pragma: public');
header('Expires: 0');
header('Content-Description: File Transfer');
header("Content-type: application/x-msexcel; charset=utf-8");
header("Content-Disposition: attachment;filename=$filename ");
header('Content-Transfer-Encoding: binary');
header('Cache-Control: public, post-check=0, pre-check=0');
readfile($filename);
