FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
PHPExcel/Examples/01pharSimple.php at 1.8 · phpsong/PHPExcel · GitHub
phpsong
PHPExcel
Repository navigation
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Expand file tree
Breadcrumbs
PHPExcel
/
Examples
/
01pharSimple.php
Copy path
More file actions
More file actions
Latest commit
History
History
History
112 lines (89 loc) · 4.09 KB
Breadcrumbs
PHPExcel
/
Examples
/
01pharSimple.php
Copy path
File metadata and controls
112 lines (89 loc) · 4.09 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
/**
* PHPExcel
*
* Copyright (c) 2006 - 2015 PHPExcel
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
*
* @category PHPExcel
* @package PHPExcel
* @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version ##VERSION##, ##DATE##
*/
/** Error reporting */
error_reporting
(
E_ALL
);
ini_set
(
'
display_errors
'
,
TRUE
);
ini_set
(
'
display_startup_errors
'
,
TRUE
);
date_default_timezone_set
(
'
Europe/London
'
);
define
(
'
EOL
'
,(
PHP_SAPI
==
'
cli
'
) ?
PHP_EOL
:
'
<br />
'
);
/** Include PHPExcel */
require_once
'
../Build/PHPExcel.phar
'
;
// Create new PHPExcel object
echo
date
(
'
H:i:s
'
) ,
"
Create new PHPExcel object
"
,
EOL
;
$
objPHPExcel
=
new
PHPExcel
();
// Set document properties
echo
date
(
'
H:i:s
'
) ,
"
Set document properties
"
,
EOL
;
$
objPHPExcel
->
getProperties
()->
setCreator
(
"
Maarten Balliauw
"
)
->
setLastModifiedBy
(
"
Maarten Balliauw
"
)
->
setTitle
(
"
PHPExcel Test Document
"
)
->
setSubject
(
"
PHPExcel Test Document
"
)
->
setDescription
(
"
Test document for PHPExcel, generated using PHP classes.
"
)
->
setKeywords
(
"
office PHPExcel php
"
)
->
setCategory
(
"
Test result file
"
);
// Add some data
echo
date
(
'
H:i:s
'
) ,
"
Add some data
"
,
EOL
;
$
objPHPExcel
->
setActiveSheetIndex
(
0
)
->
setCellValue
(
'
A1
'
,
'
Hello
'
)
->
setCellValue
(
'
B2
'
,
'
world!
'
)
->
setCellValue
(
'
C1
'
,
'
Hello
'
)
->
setCellValue
(
'
D2
'
,
'
world!
'
);
// Miscellaneous glyphs, UTF-8
$
objPHPExcel
->
setActiveSheetIndex
(
0
)
->
setCellValue
(
'
A4
'
,
'
Miscellaneous glyphs
'
)
->
setCellValue
(
'
A5
'
,
'
éàèùâêîôûëïüÿäöüç
'
);
// Rename worksheet
echo
date
(
'
H:i:s
'
) ,
"
Rename worksheet
"
,
EOL
;
$
objPHPExcel
->
getActiveSheet
()->
setTitle
(
'
Simple
'
);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$
objPHPExcel
->
setActiveSheetIndex
(
0
);
// Save Excel 2007 file
echo
date
(
'
H:i:s
'
) ,
"
Write to Excel2007 format
"
,
EOL
;
$
callStartTime
=
microtime
(
true
);
$
objWriter
= PHPExcel_IOFactory::
createWriter
(
$
objPHPExcel
,
'
Excel2007
'
);
$
objWriter
->
save
(
str_replace
(
'
.php
'
,
'
.xlsx
'
,
__FILE__
));
$
callEndTime
=
microtime
(
true
);
$
callTime
=
$
callEndTime
-
$
callStartTime
;
echo
date
(
'
H:i:s
'
) ,
"
File written to
"
,
str_replace
(
'
.php
'
,
'
.xlsx
'
,
pathinfo
(
__FILE__
,
PATHINFO_BASENAME
)) ,
EOL
;
echo
'
Call time to write Workbook was
'
,
sprintf
(
'
%.4f
'
,
$
callTime
) ,
"
seconds
"
,
EOL
;
// Echo memory usage
echo
date
(
'
H:i:s
'
) ,
'
Current memory usage:
'
, (
memory_get_usage
(
true
) /
1024
/
1024
) ,
"
MB
"
,
EOL
;
// Save Excel5 file
echo
date
(
'
H:i:s
'
) ,
"
Write to Excel5 format
"
,
EOL
;
$
callStartTime
=
microtime
(
true
);
$
objWriter
= PHPExcel_IOFactory::
createWriter
(
$
objPHPExcel
,
'
Excel5
'
);
$
objWriter
->
save
(
str_replace
(
'
.php
'
,
'
.xls
'
,
__FILE__
));
$
callEndTime
=
microtime
(
true
);
$
callTime
=
$
callEndTime
-
$
callStartTime
;
echo
date
(
'
H:i:s
'
) ,
"
File written to
"
,
str_replace
(
'
.php
'
,
'
.xls
'
,
pathinfo
(
__FILE__
,
PATHINFO_BASENAME
)) ,
EOL
;
echo
'
Call time to write Workbook was
'
,
sprintf
(
'
%.4f
'
,
$
callTime
) ,
"
seconds
"
,
EOL
;
// Echo memory usage
echo
date
(
'
H:i:s
'
) ,
'
Current memory usage:
'
, (
memory_get_usage
(
true
) /
1024
/
1024
) ,
"
MB
"
,
EOL
;
// Echo memory peak usage
echo
date
(
'
H:i:s
'
) ,
"
Peak memory usage:
"
, (
memory_get_peak_usage
(
true
) /
1024
/
1024
) ,
"
MB
"
,
EOL
;
// Echo done
echo
date
(
'
H:i:s
'
) ,
"
Done writing files
"
,
EOL
;
echo
'
Files have been created in
'
,
getcwd
() ,
EOL
;
Back
|
FazBrowse Home
|
New Git URL