satthi / PhpExcelWrapper

    * @param string $fontName フォント名

    * @author hagiwara

    */

    public function setFontName($col, $row, $sheetNo, $fontName)

    {

        if (is_null($fontName)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setName($fontName);

    }

    /**

    * setUnderline

    * @param boolean $underline 下線を引くか

    * @author hagiwara

    */

    public function setUnderline($col, $row, $sheetNo, $underline)

    {

        if (is_null($underline)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setUnderline($underline);

    }

    /**

    * setFontBold

    * @param boolean $bold 太字を引くか

    * @author hagiwara

    */

    public function setFontBold($col, $row, $sheetNo, $bold)

    {

        if (is_null($bold)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setBold($bold);

    }

    /**

    * setItalic

    * @param boolean $italic イタリックにするか

    * @author hagiwara

    */

    public function setItalic($col, $row, $sheetNo, $italic)

    {

        if (is_null($italic)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setBold($italic);

    }

    /**

    * setStrikethrough

    * @param boolean $strikethrough 打ち消し線をつけるか

    * @author hagiwara

    */

    public function setStrikethrough($col, $row, $sheetNo, $strikethrough)

    {

        if (is_null($strikethrough)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setStrikethrough($strikethrough);

    }

    /**

    * setColor

    * @param string $color 色(ARGB)

    * @author hagiwara

    */

    public function setColor($col, $row, $sheetNo, $color)

    {

        if (is_null($color)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->getColor()->setARGB($color);

    }

    /**

    * setSize

    * @param integer $size

    * @author hagiwara

    */

    public function setSize($col, $row, $sheetNo, $size)

    {

        if (is_null($size)) {

            return;

        }

        $cellInfo = $this->cellInfo($col, $row);

        $this->getSheet($sheetNo)->getStyle($cellInfo)->getFont()->setSize($size);

    }

    /**

    * setAlignHolizonal