Excel

Excel

Export to Excel

Methods

exportWithQuery

Export with Query

Excel::exportWithQuery( $qry, $excel_file_name, $conn ): string

Return Value: string Export to Browser.


defineWorksheet

define Worksheet

Excel::defineWorksheet( $fileName ): void

exportWorksheet

export Worksheet

Excel::exportWorksheet( $openXML = true ): void

__construct

construct

Excel::__construct( $fileName = NULL ): void

cellColour

cell Colour

Excel::cellColour( $cells, $colour )

cellColor

cell Color (American)

Excel::cellColor( $cells, $colour )

estimateCellCount

Estimate Cell Count in Spreadsheet

Excel::estimateCellCount( \Gibbon\Contracts\Database\Connection $pdo )

cellFontColour

cell Font Colour

Excel::cellFontColour( $cells, $colour )

cellFontColor

cell Font Color (American)

Excel::cellFontColor( $cells, $colour )

num2alpha

Get a column letter name for given number

Excel::num2alpha( $n ): string

Return Value: string letter