phpでエクセルを開きたいのですが以下のエラーが出ます
php.iniのtimezonをTokyoあたりにすれば解決すると思うのですが、php.iniのファイルがどれなのかわかりません
エラー
Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /Users/#####/Desktop/sample/PHPExcel/Reader/Excel2007.php on line 413
Warning: strtotime(): It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /Users/#####/Desktop/sample/PHPExcel/Reader/Excel2007.php on line 414
以下実行コードです
sample.php
1<?php 2// PHPExcelライブラリ読み込み 3inclede_once 'PHPExcel.php'; 4inclede_once 'PHPExcel/IOFactory.php'; 5 6// ファイルを開く 7$obj = PHPExcel_IOFactory::createReader('Excel2007'); 8$file = $obj->load('sample.xlsx'); 9 10foreach ($file->getSheetNames() as $i => $sheet_name) { 11 // シート名を表示 12 echo mb_convert_encoding($sheet_name, "SJIS", "UTF-8") . "\n"; 13 14 // セルの値を表示 15 $file->setActiveSheetIndex(0); 16 $sheet = $file->getActiveSheet(); 17 foreach ($sheet->getRowIterator() as $row) { 18 foreach ($row->getCellIterator() as $cell) { 19 echo mb_convert_encoding($cell->getCalculatedValue(), "SJIS", "UTF-8") . " "; 20 } 21 echo "\n"; 22 } 23 echo "\n"; 24} 25
phpのversionです。
$php -v
PHP 5.5.31 (cli) (built: Jan 11 2016 23:27:33)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
Macを使用しています。
$locate php.ini
/Applications/MAMP/bin/php/php5.1.6/conf/php.ini
/Applications/MAMP/bin/php/php5.1.6/conf/php.ini.temp
/Applications/MAMP/bin/php/php5.2.17/conf/php.ini
/Applications/MAMP/bin/php/php5.2.17/conf/php.ini.temp
/Applications/MAMP/bin/php/php5.3.29/conf/php.ini
/Applications/MAMP/bin/php/php5.3.29/conf/php.ini.temp
/Applications/MAMP/bin/php/php5.4.34/conf/php.ini
/Applications/MAMP/bin/php/php5.4.34/conf/php.ini.temp
/Applications/MAMP/bin/php/php5.5.18/conf/php.ini
/Applications/MAMP/bin/php/php5.5.18/conf/php.ini.temp
/Applications/MAMP/bin/php/php5.6.2/conf/php.ini
/Applications/MAMP/bin/php/php5.6.2/conf/php.ini.temp
/Applications/MAMP/conf/php5.1.6/php.ini
/Applications/MAMP/conf/php5.2.17/php.ini
/Applications/MAMP/conf/php5.3.10/php.ini
/Applications/MAMP/conf/php5.3.13/php.ini
/Applications/MAMP/conf/php5.3.14/php.ini
/Applications/MAMP/conf/php5.3.20/php.ini
/Applications/MAMP/conf/php5.3.27/php.ini
/Applications/MAMP/conf/php5.3.28/php.ini
/Applications/MAMP/conf/php5.3.29/php.ini
/Applications/MAMP/conf/php5.3.5/php.ini
/Applications/MAMP/conf/php5.3.6/php.ini
/Applications/MAMP/conf/php5.4.10/php.ini
/Applications/MAMP/conf/php5.4.19/php.ini
/Applications/MAMP/conf/php5.4.20/php.ini
/Applications/MAMP/conf/php5.4.21/php.ini
/Applications/MAMP/conf/php5.4.23/php.ini
/Applications/MAMP/conf/php5.4.25/php.ini
/Applications/MAMP/conf/php5.4.26/php.ini
/Applications/MAMP/conf/php5.4.3/php.ini
/Applications/MAMP/conf/php5.4.30/php.ini
/Applications/MAMP/conf/php5.4.32/php.ini
/Applications/MAMP/conf/php5.4.33/php.ini
/Applications/MAMP/conf/php5.4.34/php.ini
/Applications/MAMP/conf/php5.4.4/php.ini
/Applications/MAMP/conf/php5.5.10/php.ini
/Applications/MAMP/conf/php5.5.14/php.ini
/Applications/MAMP/conf/php5.5.17/php.ini
/Applications/MAMP/conf/php5.5.18/php.ini
/Applications/MAMP/conf/php5.5.3/php.ini
/Applications/MAMP/conf/php5.5.5/php.ini
/Applications/MAMP/conf/php5.5.7/php.ini
/Applications/MAMP/conf/php5.5.9/php.ini
/Applications/MAMP/conf/php5.6.0/php.ini
/Applications/MAMP/conf/php5.6.1/php.ini
/Applications/MAMP/conf/php5.6.2/php.ini
/Applications/XAMPP/xamppfiles/etc/php.ini
/Applications/XAMPP/xamppfiles/etc/php.ini-pre1.7.2
/private/etc/php.ini.default
/private/etc/php.ini.default-5.2-previous
どのファイルなんでしょうか?
よろしくお願いします。
回答2件
あなたの回答
tips
プレビュー