Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sheet->getStyle("A1:P1")->applyFromArray(
- array(
- 'borders' => array(
- 'allborders' => array(
- 'style' => PHPExcel_Style_Border::BORDER_THIN,
- 'color' => array('rgb' => '000000')
- )
- ),
- 'fill' => array(
- 'type' => PHPExcel_Style_Fill::FILL_SOLID,
- 'color' => array('rgb' => 'ffcc80')
- )
- )
- );
- ################
- /*** PHPExcel Object ***/
- /* Get the default Style object */
- (PHPExcel_Style) $style = ((PHPExcel) $excel)->getDefaultStyle()
- /*** PHPExcel_Cell Object ***/
- /* Get the Style object for a Cell */
- (PHPExcel_Style) $style = ((PHPExcel) $excel)->getStyle('A1')
- /*** Styles ***/
- /* Apply new Style from array */
- $style->applyFromArray(
- array(
- 'alignment' => array(
- 'horizontal' =>
- PHPExcel_Style_Alignment::HORIZONTAL_GENERAL = 'general'
- PHPExcel_Style_Alignment::HORIZONTAL_LEFT = 'left'
- PHPExcel_Style_Alignment::HORIZONTAL_RIGHT = 'right'
- PHPExcel_Style_Alignment::HORIZONTAL_CENTER = 'center'
- PHPExcel_Style_Alignment::HORIZONTAL_CENTER_CONTINUOUS = 'centerContinuous'
- PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY = 'justify'
- 'vertical' =>
- PHPExcel_Style_Alignment::VERTICAL_BOTTOM = 'bottom'
- PHPExcel_Style_Alignment::VERTICAL_TOP = 'top'
- PHPExcel_Style_Alignment::VERTICAL_CENTER = 'center'
- PHPExcel_Style_Alignment::VERTICAL_JUSTIFY = 'justify'
- 'rotation' => (int)
- 'wrap' => (boolean)
- 'shrinkToFit' => (boolean)
- 'indent' => (int)
- )
- 'borders' => array(
- 'allborders' => array(
- 'style' =>
- PHPExcel_Style_Border::BORDER_NONE = 'none';
- PHPExcel_Style_Border::BORDER_DASHDOT = 'dashDot';
- PHPExcel_Style_Border::BORDER_DASHDOTDOT = 'dashDotDot';
- PHPExcel_Style_Border::BORDER_DASHED = 'dashed';
- PHPExcel_Style_Border::BORDER_DOTTED = 'dotted';
- PHPExcel_Style_Border::BORDER_DOUBLE = 'double';
- PHPExcel_Style_Border::BORDER_HAIR = 'hair';
- PHPExcel_Style_Border::BORDER_MEDIUM = 'medium';
- PHPExcel_Style_Border::BORDER_MEDIUMDASHDOT = 'mediumDashDot';
- PHPExcel_Style_Border::BORDER_MEDIUMDASHDOTDOT = 'mediumDashDotDot';
- PHPExcel_Style_Border::BORDER_MEDIUMDASHED = 'mediumDashed';
- PHPExcel_Style_Border::BORDER_SLANTDASHDOT = 'slantDashDot';
- PHPExcel_Style_Border::BORDER_THICK = 'thick';
- PHPExcel_Style_Border::BORDER_THIN = 'thin';
- 'color' => array(
- 'rgb' =>
- PHPExcel_Style_Color::COLOR_BLACK = 'FF000000';
- PHPExcel_Style_Color::COLOR_WHITE = 'FFFFFFFF';
- PHPExcel_Style_Color::COLOR_RED = 'FFFF0000';
- PHPExcel_Style_Color::COLOR_DARKRED = 'FF800000';
- PHPExcel_Style_Color::COLOR_BLUE = 'FF0000FF';
- PHPExcel_Style_Color::COLOR_DARKBLUE = 'FF000080';
- PHPExcel_Style_Color::COLOR_GREEN = 'FF00FF00';
- PHPExcel_Style_Color::COLOR_DARKGREEN = 'FF008000';
- PHPExcel_Style_Color::COLOR_YELLOW = 'FFFFFF00';
- PHPExcel_Style_Color::COLOR_DARKYELLOW = 'FF808000';
- )
- )
- 'left' => // See 'allborders'
- 'top' => // See 'allborders'
- 'right' => // See 'allborders'
- 'bottom' => // See 'allborders'
- 'diagonal' =>
- 'diagonaldirection' =>
- )
- 'fill' => array(
- 'type' =>
- PHPExcel_Style_Fill::FILL_NONE = 'none';
- PHPExcel_Style_Fill::FILL_SOLID = 'solid';
- PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR = 'linear';
- PHPExcel_Style_Fill::FILL_GRADIENT_PATH = 'path';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKDOWN = 'darkDown';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKGRAY = 'darkGray';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKGRID = 'darkGrid';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKHORIZONTAL = 'darkHorizontal';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKTRELLIS = 'darkTrellis';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKUP = 'darkUp';
- PHPExcel_Style_Fill::FILL_PATTERN_DARKVERTICAL = 'darkVertical';
- PHPExcel_Style_Fill::FILL_PATTERN_GRAY0625 = 'gray0625';
- PHPExcel_Style_Fill::FILL_PATTERN_GRAY125 = 'gray125';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTDOWN = 'lightDown';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRAY = 'lightGray';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTGRID = 'lightGrid';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTHORIZONTAL = 'lightHorizontal';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTTRELLIS = 'lightTrellis';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTUP = 'lightUp';
- PHPExcel_Style_Fill::FILL_PATTERN_LIGHTVERTICAL = 'lightVertical';
- PHPExcel_Style_Fill::FILL_PATTERN_MEDIUMGRAY = 'mediumGray';
- 'rotation' => (double)
- 'startcolor' => // See 'borders' => 'allborders' => 'color'
- 'endcolor' => // See 'borders' => 'allborders' => 'color'
- 'color' => // See 'borders' => 'allborders' => 'color'
- )
- 'font' => array(
- 'name' =>
- 'Arial'
- 'Calibri'
- // etc.
- 'bold' => (boolean)
- 'italic' => (boolean)
- 'superScript' => (boolean)
- 'subScript' => (boolean)
- 'underline' => (boolean)
- 'strike' => (boolean)
- 'size' => (float)
- 'color' => // See 'borders' => 'allborders' => 'color'
- )
- 'numberformat' =>
- 'protection' =>
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement