PHP - Error al correr sistema

 
Vista:
sin imagen de perfil

Error al correr sistema

Publicado por Manuel (1 intervención) el 29/07/2021 17:40:52
Me puede decir si el codigo esta bien al momento de correr me salta un error



<?php
require_once ("excel/PHPExcel-1.8/Classes/PHPExcel.php");

$objPHPExcel = new PHPExcel();
//***************************
//***************************
//***************************
$tmpName = $_FILES['file']['tmp_name'];
$csvAsArray = array_map('str_getcsv', file($tmpName));
$i = 0;
$countSheet = 0;
foreach($csvAsArray as $key => $linea){
if($i > 0){
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex($countSheet);
$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);
//Informacion separada de las filas
$dataFila = explode(';',$linea[0]);
//vamos a recorrer la data para posicionar en las celdas correspondientes


$objPHPExcel->getActiveSheet()->setCellValue('A3', 'COMUNA: ');
$objPHPExcel->getActiveSheet()->setCellValue('B3', $dataFila[0]);

$objPHPExcel->getActiveSheet()->setCellValue('A4', 'LOCALIZACION: ');
$objPHPExcel->getActiveSheet()->setCellValue('B4', $dataFila[7]);

$objPHPExcel->getActiveSheet()->setCellValue('E3', 'FOLIO: ');
$objPHPExcel->getActiveSheet()->setCellValue('F3', $dataFila[1]);

$objPHPExcel->getActiveSheet()->setCellValue('A5', 'REGION: ');
$objPHPExcel->getActiveSheet()->setCellValue('B5', $dataFila[2]);

$objPHPExcel->getActiveSheet()->setCellValue('A6', 'PROVINCIA: ');
$objPHPExcel->getActiveSheet()->setCellValue('B6', $dataFila[3]);

$objPHPExcel->getActiveSheet()->setCellValue('A7', 'COMUNA: ');
$objPHPExcel->getActiveSheet()->setCellValue('B7', $dataFila[4]);

$objPHPExcel->getActiveSheet()->setCellValue('A8', 'DISTRITO: ');
$objPHPExcel->getActiveSheet()->setCellValue('B8', $dataFila[5]);

$objPHPExcel->getActiveSheet()->setCellValue('A9', 'ORTOFOTO: ');
$objPHPExcel->getActiveSheet()->setCellValue('B9', $dataFila[6]);

$objPHPExcel->getActiveSheet()->setCellValue('A10', 'NOMBRE PROPIETARIO: ');
$objPHPExcel->getActiveSheet()->setCellValue('B10', $dataFila[8]);

$objPHPExcel->getActiveSheet()->setCellValue('A11', 'NOMBRE PRODUCTOR: ');
$objPHPExcel->getActiveSheet()->setCellValue('B11', $dataFila[9]);

$objPHPExcel->getActiveSheet()->setCellValue('A12', 'FONO PRODUCTOR: ');
$objPHPExcel->getActiveSheet()->setCellValue('B12', $dataFila[10]);

$objPHPExcel->getActiveSheet()->setCellValue('A13', 'LOCALIZACION FONO: ');
$objPHPExcel->getActiveSheet()->setCellValue('B13', $dataFila[11]);

$objPHPExcel->getActiveSheet()->setCellValue('A14', 'EMPRESA: ');
$objPHPExcel->getActiveSheet()->setCellValue('B14', $dataFila[12]);

$objPHPExcel->getActiveSheet()->setCellValue('A15', 'ROL: ');
$objPHPExcel->getActiveSheet()->setCellValue('B15', $dataFila[13]);

$countSheet += 1;
$objPHPExcel->getActiveSheet()->setTitle('Folio '.$countSheet);
}
$i++;
}
//***************************
//***************************
//***************************
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="ingresos_palomino.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
ob_end_clean();
$objWriter->save('php://output');

Sin-titulo
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder