TransWar File Browser

Path: C:\

<?php
date_default_timezone_set('America/Sao_Paulo');
$DT=date('d-m-Y_G\hi\m');
$ds_grupo=$_POST['dsgrupo'];$lin=$_POST['lin'];
$arqxlsx="Excel/FUP_".$DT.".xlsx";
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('"');
$logo1="images/".$ds_grupo."1.png";
$logo2="images/".$ds_grupo."2.png";
$logo3="images/".$ds_grupo."3.png";
$reader->setSheetIndex(0);
/* Load a CSV file and save as a XLS */
$spreadsheet = $reader->load("fup_temp.csv");
$writer = new Xlsx($spreadsheet);
$spreadsheet->getActiveSheet()->setTitle('FUP');
$drawing1 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing1->setPath($logo3);
$drawing1->setHeight(70);
$drawing1->setWorksheet($spreadsheet->getActiveSheet());
$drawing1->setCoordinates('A1');
$drawing2 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing2->setPath($logo2);
$drawing2->setHeight(70);
$drawing2->setWorksheet($spreadsheet->getActiveSheet());
$drawing2->setCoordinates('E1');
$drawing3 = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing3->setPath($logo1);
$drawing3->setHeight(70);
$drawing3->setWorksheet($spreadsheet->getActiveSheet());
$drawing3->setCoordinates('I1');
$spreadsheet->getActiveSheet()->getRowDimension('1')->setRowHeight(80);
$spreadsheet->getActiveSheet()->mergeCells('A1:L1');
$styleArray = [
    'borders' => [
        'outline' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => '000000'],
        ],
    ],
];
$styleArray2 = [
    'borders' => [
        'vertical' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => 'a4a4a4'],
        ],
    ],
];
$format = '* #,###';
$format1= '* #,##0.00';
$spreadsheet->getActiveSheet()->getStyle('A2:L'.$lin)->applyFromArray($styleArray);
$spreadsheet->getActiveSheet()->getStyle('A2:L'.$lin)->applyFromArray($styleArray2);
$spreadsheet->getActiveSheet()->getStyle('A1:L1')->getFont()->setSize(20);
$spreadsheet->getActiveSheet()->getStyle('A2:L2')->getFont()->setSize(11);
$spreadsheet->getActiveSheet()->getStyle('A1:L2')->getFont()->setBold(true);
$spreadsheet->getActiveSheet()->getStyle('A2:L2')
    ->getAlignment()->setVertical(\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A1:L2')
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A3:C'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('G3:J'.$lin)
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$spreadsheet->getActiveSheet()->getStyle('A2:L2')
    ->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_WHITE);
$spreadsheet->getActiveSheet()->getStyle('D3:E'.$lin)->getNumberFormat()->setFormatCode($format);
$spreadsheet->getActiveSheet()->getStyle('J3:J'.$lin)->getNumberFormat()->setFormatCode($format);
$spreadsheet->getActiveSheet()->getStyle('K3:K'.$lin)->getNumberFormat()->setFormatCode($format1);
for ($c=3; $c <= $lin; $c++) 
  { if ($c % 2 == 0) { $bg="d8d8d8";} else {$bg="ffffff";}
    $range='A'.$c.':L'.$c;
    $spreadsheet->getActiveSheet()->getStyle($range)->getFill()
        ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
        ->getStartColor()->setARGB($bg);
  }
$spreadsheet->getActiveSheet()->getStyle('A2:L2')->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()->setARGB('5882FA');
$spreadsheet->getActiveSheet()->getColumnDimension('A')->setWidth(46);
$spreadsheet->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$spreadsheet->getActiveSheet()->getColumnDimension('C')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('D')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('E')->setWidth(10);
$spreadsheet->getActiveSheet()->getColumnDimension('F')->setWidth(55);
$spreadsheet->getActiveSheet()->getColumnDimension('G')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('H')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('I')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('J')->setWidth(13);
$spreadsheet->getActiveSheet()->getColumnDimension('K')->setWidth(12);
$spreadsheet->getActiveSheet()->getColumnDimension('L')->setWidth(18);
$spreadsheet->getActiveSheet()->getStyle('A2:L2')->getAlignment()->setWrapText(true);

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