
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');

<?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');

Valora esta pregunta


0