在写一个用到PHPEXCEL的程序时,发现总是得去找相关的PHPEXCEL操作的代码复制过来,下次再找,影响了速度不说,打乱了原来的程序思路,于是干脆把常用操作写成了函数,函数名简单易记,这样就不用考虑PHPEXCEL的相关问题了,更容易回到原来的程序开发思路上,顺风顺雨,一路帆风,其实应该自己整理成一个类的,这样更好用了
$objExcel->setActiveSheetIndex(0); $objActSheet = $objExcel->getActiveSheet(); //函数:设置border function setBorder($index){ global $objActSheet; $objActSheet->getStyle($index)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN ); $objActSheet->getStyle($index)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN ); $objActSheet->getStyle($index)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN ); $objActSheet->getStyle($index)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN ); $objActSheet->getStyle($index)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objActSheet->getStyle($index)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objActSheet->getStyle($index)->getAlignment()->setWrapText(true); } //设置宽度 function setWidth($index,$width=5){ global $objActSheet; $objActSheet->getColumnDimension(gbkToUtf8($index))->setWidth($width); } //设置背景 function setBg($index){ global $objActSheet; $objActSheet->getStyle($index)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_PATTERN_DARKUP); $objActSheet->getStyle($index)->getFill()->getStartColor()->setARGB('FFFFFFFF' ); } //设置值 function setValue($index,$value){ global $objActSheet; $objActSheet->setCellValue($index,gbkToUtf8($value) ); } //合并单元格 function mergeCell($fc,$lc){ global $objActSheet; $objActSheet->mergeCells($fc.":".$lc); }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
$
objExcel
->
setActiveSheetIndex
(
0
)
;
$
objActSheet
=
$
objExcel
->
getActiveSheet
(
)
;
//函数:设置border
function
setBorder
(
$
index
)
{
global
$
objActSheet
;
$
objActSheet
->
getStyle
(
$
index
)
->
getBorders
(
)
->
getTop
(
)
->
setBorderStyle
(
PHPExcel_Style_Border
::
BORDER
_THIN
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getBorders
(
)
->
getLeft
(
)
->
setBorderStyle
(
PHPExcel_Style_Border
::
BORDER
_THIN
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getBorders
(
)
->
getRight
(
)
->
setBorderStyle
(
PHPExcel_Style_Border
::
BORDER
_THIN
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getBorders
(
)
->
getBottom
(
)
->
setBorderStyle
(
PHPExcel_Style_Border
::
BORDER
_THIN
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getAlignment
(
)
->
setHorizontal
(
PHPExcel_Style_Alignment
::
HORIZONTAL_CENTER
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getAlignment
(
)
->
setVertical
(
PHPExcel_Style_Alignment
::
VERTICAL_CENTER
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getAlignment
(
)
->
setWrapText
(
true
)
;
}
//设置宽度
function
setWidth
(
$
index
,
$
width
=
5
)
{
global
$
objActSheet
;
$
objActSheet
->
getColumnDimension
(
gbkToUtf8
(
$
index
)
)
->
setWidth
(
$
width
)
;
}
//设置背景
function
setBg
(
$
index
)
{
global
$
objActSheet
;
$
objActSheet
->
getStyle
(
$
index
)
->
getFill
(
)
->
setFillType
(
PHPExcel_Style_Fill
::
FILL_PATTERN_DARKUP
)
;
$
objActSheet
->
getStyle
(
$
index
)
->
getFill
(
)
->
getStartColor
(
)
->
setARGB
(
'FFFFFFFF'
)
;
}
//设置值
function
setValue
(
$
index
,
$
value
)
{
global
$
objActSheet
;
$
objActSheet
->
setCellValue
(
$
index
,
gbkToUtf8
(
$
value
)
)
;
}
//合并单元格
function
mergeCell
(
$
fc
,
$
lc
)
{
global
$
objActSheet
;
$
objActSheet
->
mergeCells
(
$
fc
.
":"
.
$
lc
)
;
}
|