TransWar File Browser

Path: C:\

<?php
$dia=date('Ymd');
$fptemp = fopen('relatorio_temp.csv', 'w+');
fwrite($fptemp,'Coleta,NF,Fornecedor,Pedido,Destinatário,Chave NFe,1ª Liberação'.PHP_EOL);
$lin=1;
for ($d=0; $d<$n; $d++) 
	{
    if($grava[$d]=='1')
      {
        $query = sqlsrv_query($conn,"INSERT   INTO [dbo].[tbdRigesa] ([nr_NotaFiscal],[dt_Liberar],[ds_ChaveNFe]) 
          VALUES ( '".$nrNFX[$d]."','".$dia."','".$chaveX[$d]. "')" );$grava[$d]=='0';
      }
	  $lin++;$linha=$coletaX[$d].",".$nrNFX[$d].",".$fornecedorX[$d].",".$pedidoX[$d].",".$destinatarioX[$d].",".$chaveX[$d].",".$liberarX[$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($hoje);
$spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(15);
$styleArray = [
    'borders' => [
        'allBorders' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => '000000'],
        ],
    ],
];
$format2 = '###';
$spreadsheet->getActiveSheet()->getStyle('A1:G'.$lin)->applyFromArray($styleArray);
$spreadsheet->getActiveSheet()->getStyle('A1:G1')->getAlignment()->setWrapText(true);
$spreadsheet->getActiveSheet()->getStyle('A1:G1')->getFont()->setName('Arial');
$spreadsheet->getActiveSheet()->getStyle('A1:F1')->getFont()->setBold(true);
$spreadsheet->getActiveSheet()->getStyle('D2:F'.$lin)->getNumberFormat()->setFormatCode($format2);
$spreadsheet->getActiveSheet()->getStyle('B2:B'.$lin)->getNumberFormat()->setFormatCode($format2);
$spreadsheet->getActiveSheet()->getStyle('A1:G1')
    ->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A1:G'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A1:G1')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('5882FA');

$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(50);
$spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(30);
$spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(50);
$spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(15);

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