Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Boa tarde pessoal, estou iniciando no PHP (na programação de modo geral na pratica e fora da teoria da faculdade) e tenho que aprimorar um sistema já existente feito por outra pessoa, na qual ele coleta as informações e gera um relatório em Excel. Agora tenho que fazer com que ele além de gerar o Excel, também pegue parte desse relatório, criando uma versão resumida que será colocada no corpo de um e-mail que será disparado por ele junto do arquivo Excel anexado.
Porém estou tentando encontrar uma forma, que após ele gerar o relatório (código abaixo) ele vá para outra página e continue a rotina, o sistema apenas gera o relatório e o navegador baixa o arquivo, parando por aí.
<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');
if (PHP_SAPI == 'cli')
die('This example should only be run from a Web Browser');
/** Include PHPExcel */
require_once '../Classes/PHPExcel.php';
require_once 'sqlexpo.php';
$connection = pg_connect("host=localhost port=5432 dbname=base user=usuario password=senha")
or die ("Nao consegui conectar ao PostGres --> " . pg_last_error($conn));
$qu = pg_query($connection, $sql);
$arr = pg_fetch_array($qu, NULL, PGSQL_ASSOC);
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$cordaborda = array(
'borders' => array(
'outline' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,
'color' => array('argb' => 'ffffffff'),
),
),
);
//linha da cor das responsabilidades
$objPHPExcel->getActiveSheet()->getStyle('A4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('I4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('I4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->getStartColor()->setARGB('FF0000A0');$objPHPExcel->getActiveSheet()->mergeCells('A1:AA3');
$objPHPExcel->getActiveSheet()->mergeCells('B4:H4');
$objPHPExcel->getActiveSheet()->mergeCells('J4:X4');
$objPHPExcel->getActiveSheet()->mergeCells('Y4:Z4');$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A4', 'FRONTEIRA');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B4', 'EXPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I4', 'TRANSPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J4', 'Empresa');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Y4', 'TRANSPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('AA4', 'STATUS');$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'FOLLOWUP');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(28);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('A1:AA1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA1')->getFill()->getStartColor()->setARGB('FF0000A0');$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('I4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('AA4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('B5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('C5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('D5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('E5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('F5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('G5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('H5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('I5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('J5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('K5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('L5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('M5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('N5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('O5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('P5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Q5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('R5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('S5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('T5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('U5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('V5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('W5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('X5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Y5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Z5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('AA5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Y4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFill()->getStartColor()->setARGB('FF0000A0');$objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('B5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('C5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('D5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('E5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('G5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('H5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('I5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('J5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('K5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('L5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('M5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('N5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('O5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('P5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Q5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('R5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('S5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('T5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('U5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('V5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('W5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('X5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Y5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Z5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('AA5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A5:P5')->applyFromArray($cordaborda);$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('P')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Q')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('R')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('S')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('T')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('U')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('V')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('W')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('X')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Y')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Z')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('AA')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE); ->setCellValue('AA5', 'Status');
$row = 0; // postgresql precisa de um contador de linha, outros dbs talvez n?o precisem
$li = 6;
//linhas dos dados
while ($data = @pg_fetch_object($qu, $row)) {
if(isset($data->ingressorecinto)){$data_recinto = $data->ingressorecinto;}
else{$data_recinto = $data->ingressorecintof;}
if (isset($data->data_re1)) {$datare = $data->data_re1;}
else{$datare = $data->data_re2;}
if(isset($data->ingressorecinto)){$ingressorecinto = $data->ingressorecinto;}
else{$ingressorecinto = $data->ingressorecintof;}
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A'.$li, $data->localdesembaraco)
->setCellValue('B'.$li, $data->referencia)
->setCellValue('C'.$li, $data->cliente)
->setCellValue('D'.$li, $data->refcliente)
->setCellValue('E'.$li, $data->cnpj)
->setCellValue('F'.$li, $data->re)
->setCellValue('G'.$li, $datare)
->setCellValue('H'.$li, $data->processo)
->setCellValue('I'.$li, $data->crt)
->setCellValue('J'.$li, $data->dde)
->setCellValue('K'.$li, $data->datadde)
->setCellValue('L'.$li, $data->chegadaemfronteira)
->setCellValue('M'.$li, $data->recepdocs)
->setCellValue('N'.$li, $data->tempo1)
->setCellValue('O'.$li, $data->ingressoaut)
->setCellValue('P'.$li, $ingressorecinto)
->setCellValue('Q'.$li, $data->tempooking)
->setCellValue('R'.$li, $data->apresentacaorf)
->setCellValue('S'.$li, $data->canal)
->setCellValue('T'.$li, $data->observacaogeral)
->setCellValue('U'.$li, $data->envio_docs_originais)
->setCellValue('V'.$li, $data->liberacaorf)
->setCellValue('W'.$li, $data->tempoliberacao)
->setCellValue('X'.$li, $data->averbacao)
->setCellValue('Y'.$li, $data->seguiuviagem)
->setCellValue('Z'.$li, $data->cruze)
->setCellValue('AA'.$li, trim($data->obsfollow));
if (($row % 2) == 0) {
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->getStartColor()->setARGB('E6E6E6FF');
}
else{
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->getStartColor()->setARGB('FFFFFFFF');
}
$teste = $li++;
$row++;
}
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Follow Rodoviário de Exportação');
//
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->mergeCells('A'.$li. ':AA'.$li);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFont()->setSize(8);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$li, '* Informações Extraídas do sistema. Follow up desenvolvido internamente pela TI.');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Set password for readonly activesheet
$objPHPExcel->getSecurity()->setLockWindows(true);
$objPHPExcel->getSecurity()->setLockStructure(true);
$objPHPExcel->getSecurity()->setWorkbookPassword("senha da planilha");$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
$objPHPExcel->getActiveSheet()->getProtection()->setPassword("senha da planilha");
// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="FollowRodoviarioExpo.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
?>Carregando comentários...