Excel

Excel

Export to Excel

• Full name: \Gibbon\Excel
• Parent class:

Methods

• exportWithQuery — Export with Query
• defineWorksheet — define Worksheet
• exportWorksheet — export Worksheet
• __construct — construct
• cellColour — cell Colour
• cellColor — cell Color (American)
• estimateCellCount — Estimate Cell Count in Spreadsheet
• cellFontColour — cell Font Colour
• cellFontColor — cell Font Color (American)
• num2alpha — Get a column letter name for given number

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