PHPOffice / PhpSpreadsheet

     * @throws     \PhpOffice\PhpSpreadsheet\Writer\Exception

     * @return     \PhpOffice\PhpSpreadsheet\Style\Font[]        All fonts in PhpSpreadsheet

     */

    public function allFonts(\PhpOffice\PhpSpreadsheet\SpreadSheet $spreadsheet = null)

    {

        // Get an array of unique fonts

        $aFonts = [];

        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style $style */

        foreach ($aStyles as $style) {

            if (!array_key_exists($style->getFont()->getHashCode(), $aFonts)) {

                $aFonts[$style->getFont()->getHashCode()] = $style->getFont();

            }

        }

        return $aFonts;

    }

    /**

     * Get an array of all borders

     * @throws     \PhpOffice\PhpSpreadsheet\Writer\Exception

     * @return     \PhpOffice\PhpSpreadsheet\Style\Borders[]        All borders in PhpSpreadsheet

     */

    public function allBorders(\PhpOffice\PhpSpreadsheet\SpreadSheet $spreadsheet = null)

    {

        // Get an array of unique borders

        $aBorders = [];

        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style $style */

        foreach ($aStyles as $style) {

            if (!array_key_exists($style->getBorders()->getHashCode(), $aBorders)) {

                $aBorders[$style->getBorders()->getHashCode()] = $style->getBorders();

            }

        }

        return $aBorders;

    }

    /**

     * Get an array of all number formats

     * @throws     \PhpOffice\PhpSpreadsheet\Writer\Exception

     * @return     \PhpOffice\PhpSpreadsheet\Style\NumberFormat[]        All number formats in PhpSpreadsheet

     */

    public function allNumberFormats(\PhpOffice\PhpSpreadsheet\SpreadSheet $spreadsheet = null)

    {

        // Get an array of unique number formats

        $aNumFmts = [];

        $aStyles = $this->allStyles($spreadsheet);

        /** @var \PhpOffice\PhpSpreadsheet\Style $style */

        foreach ($aStyles as $style) {

            if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !array_key_exists($style->getNumberFormat()->getHashCode(), $aNumFmts)) {

                $aNumFmts[$style->getNumberFormat()->getHashCode()] = $style->getNumberFormat();

            }

        }

        return $aNumFmts;

    }

}