Gitee
\
Acme
Api
app
admin
controller
agent
article
finance
order
record
routine
setting
store
system
ump
user
wechat
widget
model
article
finance
order
record
routine
store
system
ump
user
wechat
index
controller
routine
controller
model
article
routine
store
user
wap
controller
model
store
user
wap
wechat
controller
basic
behavior
system
wap
wechat
Composer
Autoload
Doctrine
Common
Cache
Tests
Common
Cache
EasyWeChat
Broadcast
Card
Comment
Core
Exceptions
Device
Encryption
Foundation
ServiceProviders
Fundamental
Js
Material
Menu
Message
MiniProgram
Core
Encryption
Material
Notice
QRCode
Server
Sns
Staff
Stats
Notice
OpenPlatform
Api
EventHandlers
Payment
CashCoupon
LuckyMoney
MerchantPay
POI
QRCode
Reply
Semantic
Server
ShakeAround
Staff
Stats
Store
Support
Traits
Url
User
FormBuilder
components
interfaces
traits
component
form
GuzzleHttp
Cookie
Exception
Handler
Promise
Psr7
Monolog
Formatter
Handler
Curl
FingersCrossed
Slack
SyslogUdp
Processor
Overtrue
Socialite
Providers
Phinx
Db
Adapter
Table
Migration
Seed
Util
Pimple
Exception
Psr11
Tests
Fixtures
Psr11
Psr
Container
Http
Message
Log
Test
service
Symfony
Bridge
PsrHttpMessage
Factory
Tests
Factory
Fixtures
Component
HttpFoundation
Exception
File
Exception
MimeType
Session
Attribute
Flash
Storage
Handler
Proxy
Tests
File
MimeType
Session
Attribute
Flash
Storage
Handler
Proxy
Polyfill
Mbstring
tests
think
cache
driver
captcha
composer
config
driver
console
command
make
optimize
input
output
descriptor
driver
formatter
question
controller
db
builder
connector
exception
debug
exception
image
gif
log
driver
migration
command
migrate
seed
db
model
relation
paginator
driver
process
exception
pipes
response
session
driver
template
driver
taglib
view
driver
traits
controller
model
think

\servicePHPExcelService

Summary

Methods
Properties
Constants
setUtf8()
setExcelContent()
ExcelSave()
setExcelHeader()
setExcelTile()
No public properties found
No constants found
No protected methods found
$count
$topNumber
$cells
$data
$title
$where
$height
N/A
initialize()
setCellInfo()
$PHPExcel
$cellKey
$styleArray
N/A

Properties

$count

$count :

Type

$topNumber

$topNumber :

Type

$cells

$cells :

Type

$data

$data :

Type

$title

$title :

Type

$where

$where :

Type

$height

$height :

Type

$PHPExcel

$PHPExcel :

Type

$cellKey

$cellKey :

Type

$styleArray

$styleArray :

Type

Methods

setUtf8()

setUtf8(  $title)

设置字体格式

Parameters

$title

string 必选 return string

setExcelContent()

setExcelContent(  $list = null)

execl数据导出

Parameters

$list

也可以为匿名函数 匿名函数参数有 $sheet PHPExcel->getActiveSheet(),self::$topNumber 从第几行设置,$cellkey 行号为数组,self::$cells现在设置的最大行号

特殊处理：合并单元格需要先对数据进行处理

ExcelSave()

ExcelSave() :

保存表格数据，并下载

Returns

setExcelHeader()

setExcelHeader(  $data,   $fun = null) : $this

设置头部信息

Parameters

$data

array
$fun

function() 主要设置边框的粗细

Returns

$this

setExcelTile()

setExcelTile(  $title = '',   $Name = '',   $info = array(),   $funName = null) : $this

设置标题

Parameters

$title

string || array ['title'=>'','name'=>'','info'=>[]]
$Name

string
$info

string || array;
$funName

function($style,$A,$A2) 自定义设置头部样式

Returns

$this

initialize()

initialize(  $data,   $fun)

初始化PHPExcel类

Parameters

$data

array()
$fun

function() return

setCellInfo()

setCellInfo(  $info) : string

设置第二行标题内容

Parameters

$info

array (['name'=>'','site'=>'','phone'=>123] || ['我是表名','我是地址','我是手机号码'] ) || string 自定义

Returns

string