PHPExcel Developer Documentation
Author:
Version:
Date:
1. Contents
!"#$%"&'$
()*&
+'
'
"&')
,&&
-"&'
.'/01
2*'
/01"
-"&'3&
-"&'34'
2&
25
601")3&)"5
'-*7 ,$5
8-*'3"-&95
"-'9)%4)5
5-'"'&&*'5
-"-7*
'%'&-&'"-
-%""%
")"-
(-
6-'&)*'
&-
8+&&
+""):-
5-)"&'
-&4&
-3&'6
'%'&6
;"%6
-3'-'
6'%'&
;"%
8-%-
-%
5+&&&-*'8
+&&'18
<:&-8
,&"377
-'&&'
-'&'-'
6-5
,&-&-:
/01=!()
-/01=,&=,&-/01=!()
-/01=2=2-/01=!()
018>"&'$?:
/01=,&=018
/01=2=018
/01<4"<
9&:
/01=,&=9&
/01=2=9&
016>((?:
/01=,&=016
/01=2=016
6@>"&@?
6/01=,&=@
6/01=2=@
/.$ 6
/01=2=/.$6
8<(
8/01=2=<(
8&
/01<4"<
2. Prerequisites
2.1. Software requirements
.'-&&4"-/01A
» /46
» /1"'"=9"7&
2.2. Installation instructions
)A")''&)
)""&
+&B*)&/01:.'7'4&7)
"-7&B7)-'/&"'B1"A
set_include_path(get_include_path() . PATH_SEPARATOR . '/path/to/PHPExcel/');
2.3. Useful tools
.'''4)'&4"--/01
'/01&1"-"&4'7
2.3.1. OpenXML / SpreadsheetML
» File format documentation
'"A%%C-%%.6==*%.6=47=&
'
» OpenXML Explained e-book
'"A%%"1&4"-%%58"1
» Microsoft O!ce Compatibility Pack for Word, Excel, and PowerPoint 2007
File Formats
'"A%%%&&%&"1D)&E578C5CC
C778&F&")-E
» OpenXML Package Explorer
'"A%%&"1%*-01"%
2.3.2. Frequently asked questions
.'"CC&(+G"-/017&
'"A%%&"1%/01%2*%@"1D
E(+GF-.E,
There seems to be a problem with character encoding...
) .(C&-1/01'"&H
&-'"74'1'/I4>?
PHP complains about ZipArchive not being found
*),B")"'"=9"1'&77&
Protection on my worksheet is not working?
2')*)'*'">--
"B"'7-&-B?B*)7*').'
1"7&*'A
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
/01<4"<
Feature X is not working with PHPExcel_Writer_Y
J/01"&',&%2.'
)&&)-7""-":'4-
"&":
(1":"&0+,"&'=01=B'''
7016
Formulas don’t seem to be calculated in Excel2003 using compatibility pack?
.'7'4'"7)"*B018&")')
/01=2=016))&&4B
01
Setting column width is not 100% accurate
.)-&'B1""72'"':01B'
&'8"''&7
$**-7'&&'"7A
'"A%%""%*7%5
.'7:1&>'&&?7)-'&A
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Arial Cyr');
/01<4"<
6
- 1
- 2
前往页