404

D7net
:/ var / www / html / speed /
Filename : criar.php
back
<?php

require_once "vendor/autoload.php";

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$sheet->setCellValue('A1', 'SERVIMED');
  
$nome = 'SERVIMED';
$styles = [
    'font' => [
        'bold' => true,
        'color' => [
            'rgb' => 'F00F00'
        ],
        'size' => 14,
        'name' => 'Arial'
    ]
    ];
    $sheet->getStyle('A1')->applyFromArray($styles); 
    $styles = [
        'font' => [
            'bold' => true,
            'name' => 'Arial'
        ]
        ];
    

    $sheet->getStyle('A3:E3')->applyFromArray($styles); 

$cells = [
    ['PROD COD', 'NOME DO PRODUTO', 'QTDE',$nome],
    [ 395427, 'ACTIVE C [10] TUBO 30ML *',4, 12.57],
    [ 502937, 'COND.DOVE NUT.SOL.HIDRA LISO 200ML',2, 7.28],
    [ 502939, 'ALCOOL GEL REXONA 100G*', 3,4.78],
    [ null, null, 'TOTAL', '=SUMPRODUCT(C4:C6,D4:D6)']
];

$sheet->fromArray($cells, null, 'A3');


$writer = new Xlsx($spreadsheet);
$writer->save('negociacao.xlsx');