Documentation

XlsComponent extends Injectable
in package

Table of Contents

Constants

FORMAT  = ['QTY_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER, 'QUANTITY' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER, 'WEIGHT' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'NET_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'VAT_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'VAT_RATE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00, 'GROSS_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'CURR_EXC_RATE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL, 'CURRENCY_EXCHANGE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL]

Methods

add2SpreadSheet()  : Spreadsheet
addComments2SpreadSheet()  : mixed
highlightColumn()  : mixed

Constants

FORMAT

public mixed FORMAT = ['QTY_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER, 'QUANTITY' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER, 'WEIGHT' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'NET_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'VAT_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'VAT_RATE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00, 'GROSS_VALUE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00, 'CURR_EXC_RATE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL, 'CURRENCY_EXCHANGE' => \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL]

Methods

add2SpreadSheet()

public static add2SpreadSheet(array<string|int, mixed> $headers, array<string|int, mixed> $cont[, Spreadsheet|null $spreadsheet = null ][, array<string|int, mixed> $opt = [] ]) : Spreadsheet
Parameters
$headers : array<string|int, mixed>
$cont : array<string|int, mixed>
$spreadsheet : Spreadsheet|null = null
$opt : array<string|int, mixed> = []
Tags
throws
Exception
Return values
Spreadsheet

addComments2SpreadSheet()

public static addComments2SpreadSheet(mixed $spreadsheet, mixed $sheet, mixed $headers, mixed $comments) : mixed
Parameters
$spreadsheet : mixed
$sheet : mixed
$headers : mixed
$comments : mixed

highlightColumn()

public static highlightColumn(mixed $spreadsheet, mixed $sheet, mixed $headers, mixed $highlighted) : mixed
Parameters
$spreadsheet : mixed
$sheet : mixed
$headers : mixed
$highlighted : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results