Documentation

ExportHelper
in package

Table of Contents

Constants

OPTIONS  = ['font' => ['bold' => true], 'alignment' => ['horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT], 'borders' => ['allBorders' => ['borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR]], 'fill' => ['fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR, 'rotation' => 0, 'startColor' => ['argb' => 'FFA0A0A0'], 'endColor' => ['argb' => 'FFFFFFFF']]]

Methods

exportDataXls()  : mixed
exportGridExcel()  : mixed
exportGridPdf()  : mixed
exportDataXlsGeneric()  : mixed
exportDataXlsInventarioEstoque()  : mixed
exportDataXlsInventarioEstoqueLoteCompra()  : mixed
exportDataXlsMovAplicacaoFinanceira()  : mixed
getHeader()  : mixed
setHeaderSheet()  : mixed
setStyle()  : mixed

Constants

OPTIONS

public mixed OPTIONS = ['font' => ['bold' => true], 'alignment' => ['horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT], 'borders' => ['allBorders' => ['borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR]], 'fill' => ['fillType' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_GRADIENT_LINEAR, 'rotation' => 0, 'startColor' => ['argb' => 'FFA0A0A0'], 'endColor' => ['argb' => 'FFFFFFFF']]]

Methods

exportDataXls()

public static exportDataXls(array<string|int, mixed> $data[, string $fileName = 'exporte' ][, array<string|int, mixed> $header = [] ][, mixed $format_config_import = false ]) : mixed
Parameters
$data : array<string|int, mixed>
$fileName : string = 'exporte'
$header : array<string|int, mixed> = []
$format_config_import : mixed = false

exportGridExcel()

public static exportGridExcel(array<string|int, mixed> $data, array<string|int, mixed> $headers, mixed $pagina, mixed $fileName, mixed $baseUrl) : mixed
Parameters
$data : array<string|int, mixed>
$headers : array<string|int, mixed>
$pagina : mixed
$fileName : mixed
$baseUrl : mixed

exportGridPdf()

public static exportGridPdf(array<string|int, mixed> $data, array<string|int, mixed> $headers, array<string|int, mixed> $totalizador, mixed $pagina, mixed $fileName, mixed $baseUrl) : mixed
Parameters
$data : array<string|int, mixed>
$headers : array<string|int, mixed>
$totalizador : array<string|int, mixed>
$pagina : mixed
$fileName : mixed
$baseUrl : mixed

exportDataXlsGeneric()

private static exportDataXlsGeneric(mixed &$spreadsheet, mixed $data, mixed $coluns[, mixed $config_cell = [] ]) : mixed
Parameters
$spreadsheet : mixed
$data : mixed
$coluns : mixed
$config_cell : mixed = []

exportDataXlsInventarioEstoque()

private static exportDataXlsInventarioEstoque(mixed &$spreadsheet, mixed $data, mixed $coluns, mixed $config_cell) : mixed
Parameters
$spreadsheet : mixed
$data : mixed
$coluns : mixed
$config_cell : mixed

exportDataXlsInventarioEstoqueLoteCompra()

private static exportDataXlsInventarioEstoqueLoteCompra(mixed &$spreadsheet, mixed $data, mixed $coluns, mixed $config_cell) : mixed
Parameters
$spreadsheet : mixed
$data : mixed
$coluns : mixed
$config_cell : mixed

exportDataXlsMovAplicacaoFinanceira()

private static exportDataXlsMovAplicacaoFinanceira(mixed &$spreadsheet, mixed $data, mixed $coluns, mixed $config_cell) : mixed
Parameters
$spreadsheet : mixed
$data : mixed
$coluns : mixed
$config_cell : mixed

getHeader()

private static getHeader(mixed $data) : mixed
Parameters
$data : mixed

setHeaderSheet()

private static setHeaderSheet(mixed &$spreadsheet, mixed $header, mixed $data) : mixed
Parameters
$spreadsheet : mixed
$header : mixed
$data : mixed

setStyle()

private static setStyle(mixed &$spreadsheet, mixed $type, mixed $column, mixed $row[, mixed $size = '' ][, mixed $value = '' ]) : mixed
Parameters
$spreadsheet : mixed
$type : mixed
$column : mixed
$row : mixed
$size : mixed = ''
$value : mixed = '' 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results