404

D7net
:/ var / www / html / speed / vendor /
Filename : teste.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');
  

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

    $sheet->getStyle('A3:E3')->applyFromArray($styles); 
/*
// cabeçalho da planilha
$sheet->setCellValue('A3', 'ID');
$sheet->setCellValue('B3', 'NOME');
$sheet->setCellValue('C3', 'VALOR');
// valores da planilha
$sheet->setCellValue('A4', 1);
$sheet->setCellValue('B4', 'Monitor LG');
$sheet->setCellValue('C4', 600.00);
$sheet->setCellValue('A5', 2);
$sheet->setCellValue('B5', 'Mouse Microsoft');
$sheet->setCellValue('C5', 15.47);
*/
//$sheet->setCellValue('A3', 'ID');
//$sheet->setCellValue('B3', 'NOME');
//$sheet->setCellValue('C3', 'VALOR');
/*$cells = [
    ['PROD COD', 'NOME DO PRODUTO', 'QTDE','PREÇO COTADO','Total'],
    [ 395427, 'ACTIVE C [10] TUBO 30ML *',4, 12.57, '=C4*D4'],
    [ 502937, 'COND.DOVE NUT.SOL.HIDRA LISO 200ML',2, 7.28,'=C5*D5'],
    [ 502939, 'ALCOOL GEL REXONA 100G*', 3,4.78,'=C6*D6'],
    [ null, null, null, 'TOTAL', '=SUM(E4:E6)']
];
*/
$cells = [
    ['PROD COD', 'NOME DO PRODUTO', 'QTDE','PREÇO COTADO'],
    [ 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');