404

D7net
:/ var / www / html / rosario / adm / app / gre / Models / Cotacao /
Filename : ModCtRespondePrecoGerarSpread.php
back
<?php

namespace App\gre\Models\Cotacao;

if (!defined('URL')) {
    header("Location: /");
    exit();
}

//use phpOffice\src\PhpSpreadsheet\Spreadsheet; //classe responsável pela manipulação da planilha

//use phpOffice\src\PhpSpreadsheet\Writer\Xlsx; //classe que salvará a planilha em .xlsx
/**
 * Description of GrsListarPsaudemedico
 *
 * @copyright (c) year, Carlos Marques - CM
 */
   require $_SERVER['DOCUMENT_ROOT']."/rosario/adm/vendor/autoload.php";
class ModCtRespondePrecoGerarSpread
{

    private $Dados;
    private $Resultado;
    private $PageId;
    private $DadosExcel;

use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PHPOffice\phpspreadsheet\Writer\Xlsx;
use PHPOffice\phpspreadsheet\Shared\Date;

  
 function getResultado()
    {
        return $this->Resultado;
    }
    
    public function gerarCotacao($PageId = null, $Dados = null)
    {


 






$spreadsheet = new Spreadsheet(); //instanciando uma nova planilha

$sheet = $spreadsheet->getActiveSheet(); //retornando a aba ativa

$sheet->setCellValue('A1', 'Nome'); //Definindo a célula A1

$sheet->setCellValue('B1', 'Nota 1'); //Definindo a célula B1

$sheet->setCellValue('C1', 'Nota 2');

$sheet->setCellValue('D1', 'Media');

$sheet->setCellValue('A2', 'pokemaobr');

$sheet->setCellValue('B2', 5);

$sheet->setCellValue('C2', 3.5);

$sheet->setCellValue('D2', '=((B2+C2)/2)'); //Definindo a fórmula para o cálculo da média

$sheet->setCellValue('A3', 'bob');

$sheet->setCellValue('B3', 7);

$sheet->setCellValue('C3', 8);

$sheet->setCellValue('D3', '=((B3+C3)/2)');

$sheet->setCellValue('A4', 'boina');

$sheet->setCellValue('B4', 9);

$sheet->setCellValue('C4', 9);

$sheet->setCellValue('D4', '=((B4+C4)/2)');


$writer = new Xlsx($spreadsheet); //Instanciando uma nova planilha

$writer->save('spreadsheet1.xlsx'); //
}
}