豆爸的手册
  • 简介
  • 计算机基础
    • 浮点数的二进制表示
  • 架构设计
    • SSO
  • 服务器
    • 开启 gzip 压缩功能
    • 使用Liunx的crontab配置定时任务
    • OpenSSL生成秘钥对
    • 什么是线程安全
    • nginx基本配置与参数说明
    • Nginx日志配置参数
    • Linux命令
      • iostat
    • CGI, FashCGI, PHP-FPM
    • nginx中rewrite模块break和last原理详解
    • OOM
    • XXE漏洞的简单理解和测试
    • Apache 配置反向代理
    • 阿里云OSS STS上传配置
  • PHP
    • Laravel框架
      • Laravel 使用Apache服务器无法获取header中Authorization
      • Laravel5.1 表单数组验证
      • Laravel5 如何验证路由中的变量
      • Laravel 清除表单字段前后空白的Middleware
      • Laravel 获取执行的SQL语句
      • Laravel 将stdClass转换成Eloquent Model
      • 实际开发中如何活用 Closure
      • IoC 容器
    • Symfony框架
    • PHPExcel支持的样式
    • 计算地球上2个经纬度之间的距离
    • 创建一个自己的 Composer/Packagist 包
    • PHP Trait
    • 关于PHP浮点数
    • PHP7.2使用openssl替换mcrypt
    • rpc是什么?php中流行的rpc框架有哪些
  • MySQL
    • MySQL事务隔离级别
    • MySQL使用可重复读作为默认隔离级别的原因
    • FIND_IN_SET vs IN
    • MySQL慢查询
    • 是否使用SQL_CALC_FOUND_ROWS
    • GROUP BY性能优化
    • MySQL分页优化
    • MySQL在2个值之间获取随机数
    • MySQL数据库
      • 建表规约
      • 索引规约
      • SQL 语句
      • ORM 映射
    • MySQL 5.6 原生Online DDL解析
    • mysql使用utf8mb4经验吐血总结
  • HTTP
    • HTTP:Content-Type
    • 从HTTP到HTTPS再到HSTS
    • 主流浏览器中如何清除HSTS设置
    • 也许,这样理解HTTPS更容易
  • JavaScript
    • 跨域资源共享 CORS 详解
  • Git
    • 撤销合并
    • 从其他分支checkout文件或文件夹
    • 批量删除分支和标签
  • 前端
    • Grid布局
    • Flex布局
    • 浅谈OSS跨域功能
  • 书摘
    • 高效程序员的45个习惯
  • OpenResty
    • 新手上路
  • 敏捷开发
    • 为什么Scrum Master不叫Scrum Manager?
  • Postman
    • 使用Newman执行collections的时候,如果上传文件
    • 同步API定义到Postman
  • RESTful API最佳实践
  • 开发工具
  • 设计模式原则
  • Charles 从入门到精通
  • 阿里云OSS STS上传配置
  • 流式分页
Powered by GitBook
On this page

Was this helpful?

  1. PHP

PHPExcel支持的样式

/*** 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' =>
    )
)
PreviousSymfony框架Next计算地球上2个经纬度之间的距离

Last updated 5 years ago

Was this helpful?