WIKI de apuntes de Billy Rondón

Esta página es de solo lectura. Puedes ver la fuente pero no puedes cambiarla. Pregunta a tu administrador si crees que esto es incorrecto.
====== PHP EXCEL =====

<code php>

  require_once 'PHPExcel-1.8/Classes/PHPExcel.php';

  //Identifica el tipo de excel.
  $input_file_type = PHPExcel_IOFactory::identify( $fileName );
  
  $excelReader = PHPExcel_IOFactory::createReaderForFile( $fileName );
  $excelObj = $excelReader->load( $fileName );

  $rpta['libros'] = implode($excelObj->getSheetNames(),'|') ;
  $rpta['libroactivo'] = $excelObj->getSheetNames()[ $excelObj->getActiveSheetIndex() ];
  
  
  
</code>

<code php>
 function exportExcel($expTitle, $expCellName, $expTableData)
 {
     $xlsTitle = iconv('utf-8', 'gb2312', $expTitle);
     //文件名称
     $fileName = $_SESSION['account'] . date('_YmdHis');
     //or $xlsTitle 文件名称可根据自己情况设定
     $cellNum = count($expCellName);
     $dataNum = count($expTableData);
     vendor("PHPExcel.PHPExcel");
     $objPHPExcel = new \PHPExcel();
     $cellName = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ');
     $objPHPExcel->getActiveSheet(0)->mergeCells('A1:' . $cellName[$cellNum - 1] . '1');
     //合并单元格
     for ($i = 0; $i < $cellNum; $i++) {
         $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i] . '2', $expCellName[$i][1]);
     }
     for ($i = 0; $i < $dataNum; $i++) {
         for ($j = 0; $j < $cellNum; $j++) {
             $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j] . ($i + 3), $expTableData[$i][$expCellName[$j][0]]);
         }
     }
     header('pragma:public');
     header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $xlsTitle . '.xls"');
     header("Content-Disposition:attachment;filename={$fileName}.xls");
     //attachment新窗口打印inline本窗口打印
     $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
     //$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
     $objWriter->save('php://output');
     exit;
 }

</code>
[[https://hotexamples.com/examples/-/PHPExcel/getActiveSheet/php-phpexcel-getactivesheet-method-examples.html]]

buscar reemplazar ese array con letras...
===== Pasar mensajes php =====

[[https://stackoverflow.com/questions/13109522/this-session-set-flashdata-and-then-this-session-flashdata-doesnt-wor]]
<code php>
// Set flash data 
$this->session->set_flashdata('message_name', 'This is my message');
// After that you need to used redirect function instead of load view such as 
redirect("admin/signup");

// Get Flash data on view 
$this->session->flashdata('message_name');
</code>

Ejemplo excel:
<code php>
equire_once '../libs/PHPExcel-1.8/Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();

// Agregar Informacion
$objPHPExcel->setActiveSheetIndex(0)
	->setCellValue('A1', 'Valor 1')
	->setCellValue('B1', 'Valor 2')
	->setCellValue('C1', 'Total')
	->setCellValue('A2', '10')
	->setCellValue('C2', '=sum(A2:B2)');
	
// Renombrar Hoja
$objPHPExcel->getActiveSheet()->setTitle('Tecnologia Simple');

$objPHPExcel->setActiveSheetIndex(0);

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="pruebaReal.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');

die();

$store="get_detalle_orden_embarque '".$tipo."','".$oe."'";	
</code>
[[http://comunidad.fware.pro/dev/php/como-crear-verdaderos-archivos-de-excel-usando-phpexcel/]]