TransWar File Browser

Path: C:\

<?php
$fptemp = fopen('relatorio_temp.csv', 'w+');
fwrite($fptemp,'Controle Diário de Entregas Provider'.PHP_EOL);
fwrite($fptemp,'Coleta,Hora,Chave NFe,NF,Fornecedor,Valor,Volume,Pedido,Origem,Destino,Embalagem'.PHP_EOL);
$lin=2;
for ($d=0; $d<$n; $d++) 
	{
	  $lin++;$linha=$coletaX[$d].",".$horaX[$d].",".$chaveX[$d].",".$nrNFX[$d].",".$fornecedorX[$d].",".$valorX[$d].",".$volumeX[$d].",".$pedidoX[$d].",".$origemX[$d].",".$destinoX[$d].",".$embalagemX[$d].PHP_EOL;
	  fwrite($fptemp, $linha);
	}
fclose($fptemp); 
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
$spreadsheet = new Spreadsheet();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
/* Set CSV parsing options */
$reader->setDelimiter(',');
$reader->setEnclosure('"');
$reader->setSheetIndex(0);
/* Load a CSV file and save as a XLS */
$spreadsheet = $reader->load("relatorio_temp.csv");
$writer = new Xlsx($spreadsheet);
$spreadsheet->getActiveSheet()->setTitle($dateadded);
$spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(30);
$spreadsheet->getActiveSheet()->mergeCells('A1:K1');
$styleArray = [
    'borders' => [
        'allBorders' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => '000000'],
        ],
    ],
];
$format = '#,##0.00';
$format2 = '###';
$spreadsheet->getActiveSheet()->getStyle('A1:K'.$lin)->applyFromArray($styleArray);
$spreadsheet->getActiveSheet()->getStyle('A1:K2')->getAlignment()->setWrapText(true);
$spreadsheet->getActiveSheet()->getStyle('A1:K2')->getFont()->setName('Arial');
$spreadsheet->getActiveSheet()->getStyle('A1:K2')->getFont()->setBold(true);
$spreadsheet->getActiveSheet()->getStyle('A1:K1')->getFont()->setSize(20);;
$spreadsheet->getActiveSheet()->getStyle('F2:F'.$lin)->getNumberFormat()->setFormatCode($format);
$spreadsheet->getActiveSheet()->getStyle('C2:D'.$lin)->getNumberFormat()->setFormatCode($format2);
$spreadsheet->getActiveSheet()->getStyle('G2:H'.$lin)->getNumberFormat()->setFormatCode($format2);
$spreadsheet->getActiveSheet()->getStyle('A1:K2')
    ->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A1:K2')
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A1:K'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('F3:F'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT);
$spreadsheet->getActiveSheet()->getStyle('A2:K2')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('5882FA');
$spreadsheet->getActiveSheet()->getStyle('A2:K2')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE);
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(50);
$spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(50);
$spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('I')->setWidth(30);
$spreadsheet->getActiveSheet()->getColumnDimension('J')->setWidth(40);
$spreadsheet->getActiveSheet()->getColumnDimension('K')->setWidth(20);

$writer->save('NotasPDF/'.$arqxlsx);
$spreadsheet->disconnectWorksheets();
unset($spreadsheet);
unlink('relatorio_temp.csv');
?>