TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time',1200); 
date_default_timezone_set('America/Sao_Paulo');
ini_set ( 'memory_limit' , '-1' ) ;
$arqcsv="Veiculos.csv";
$arqxlsx="Veiculos.xlsx";
function LoadData($file)
{
	$lines = file($file);
	$data = array();
	foreach($lines as $line)
	    $data[] = explode(';',trim($line));
	return $data;
}
$linha=LoadData($arqcsv);
$l=count($linha);
require '../vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
\PhpOffice\PhpSpreadsheet\Cell\Cell::setValueBinder( new \PhpOffice\PhpSpreadsheet\Cell\AdvancedValueBinder() );
$spreadsheet = new Spreadsheet();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
/* Set CSV parsing options */
$reader->setDelimiter(';');
$reader->setEnclosure('"');
$locale = 'pt_br';
$validLocale = \PhpOffice\PhpSpreadsheet\Settings::setLocale($locale);
if (!$validLocale) {
		echo 'Unable to set locale to ' . $locale . " - reverting to en_us" . PHP_EOL;
}
$reader->setSheetIndex(0);
/* Load a CSV file and save as a XLS */
$spreadsheet = $reader->load($arqcsv);
$writer = new Xlsx($spreadsheet);
$spreadsheet->getActiveSheet()->setTitle('Veículos');
$spreadsheet->getActiveSheet()->getRowDimension('2')->setRowHeight(25);
$spreadsheet->getActiveSheet()->getRowDimension('3')->setRowHeight(40);
$styleArray0 = [
		'borders' => [
				'allBorders' => [
						'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
						'color' => ['argb' => 'ffffff'],
				],
		],
];
$styleArray = [
		'borders' => [
				'allBorders' => [
						'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
						'color' => ['argb' => '000000'],
				],
		],
];
$spreadsheet->getActiveSheet()->getStyle('A1:Z1000')->applyFromArray($styleArray0);
$spreadsheet->getActiveSheet()->getStyle('B2:H'.$l)->applyFromArray($styleArray);
$spreadsheet->getActiveSheet()->getStyle('B2:H2')->getFont()->setSize(20);
$spreadsheet->getActiveSheet()->getStyle('B3:H3')->getFont()->setSize(12);
$spreadsheet->getActiveSheet()->getStyle('B4:H'.$l)->getFont()->setSize(11);
$spreadsheet->getActiveSheet()->getStyle('B2:H3')->getFont()->setBold(true);
$spreadsheet->getActiveSheet()->getStyle('B3:H3')->getAlignment()->setWrapText(true);
$spreadsheet->getActiveSheet()->getStyle('B3:H3')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE);
$spreadsheet->getActiveSheet()->getStyle('B3:H3')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('5882FA');
$spreadsheet->getActiveSheet()->getStyle('B2:H'.$l)
		->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('B2:H3')
		->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('B4:B'.$l)
		->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('E4:E'.$l)
		->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('F4:F'.$l)
		->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);

$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(5);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(25);
$spreadsheet->getActiveSheet()->mergeCells('B2:H2');

$writer->save($arqxlsx);
$spreadsheet->disconnectWorksheets();
unset($spreadsheet);
echo "<script language='JavaScript'>location.href='sel_01.php?arquivo=".$arqxlsx."';</script>";
?>