回答編集履歴
1
change sheet name
test
CHANGED
@@ -1,3 +1,25 @@
|
|
1
1
|
http://qiita.com/GENYA/items/5d70f597aa48855d4f9b
|
2
2
|
|
3
3
|
PHPExcel
|
4
|
+
|
5
|
+
|
6
|
+
|
7
|
+
sheet name
|
8
|
+
|
9
|
+
```lang-php
|
10
|
+
|
11
|
+
$excelObj = new PHPExcel();
|
12
|
+
|
13
|
+
//select sheet
|
14
|
+
|
15
|
+
$excelObj->setActiveSheetIndex(0);
|
16
|
+
|
17
|
+
// get setting sheet
|
18
|
+
|
19
|
+
$sheetObj = $book->getActiveSheet();
|
20
|
+
|
21
|
+
// change sheet name
|
22
|
+
|
23
|
+
$sheetObj->setTitle("sheet_name");
|
24
|
+
|
25
|
+
```
|