<?php
/** Error reporting */
error_reporting(E_ALL);/** Include path **/
ini_set('include_path', ini_get('include_path').';../Classes/');/** PHPExcel */
include 'PHPExcel.php';/** PHPExcel_Writer_Excel2007 */
include 'PHPExcel/Writer/Excel2007.php';// Create new PHPExcel object
echo date('H:i:s') . " Create new PHPExcel object\n";
$objPHPExcel = new PHPExcel();// Set properties
echo date('H:i:s') . " Set properties\n";
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
// Add some data
echo date('H:i:s') . " Add some data\n";
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'world!');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('D2', 'world!');// Rename sheet
echo date('H:i:s') . " Rename sheet\n";
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Save Excel 2007 file
echo date('H:i:s') . " Write to Excel2007 format\n";
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));// Echo done
echo date('H:i:s') . " Done writing file.\r\n";这个phpexcel官网的代码。
我运行的时候,常出问题。Warning: include(PHPExcel.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include() [function.include]: Failed opening 'PHPExcel.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include(PHPExcel/Writer/Excel5.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 12Warning: include() [function.include]: Failed opening 'PHPExcel/Writer/Excel5.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 12
14:43:25 Create new PHPExcel object
Fatal error: Class 'PHPExcel' not found in D:\WebSite\htdocs\phpexcel-sample1.php on line 16
首先:我改了,把phpexcel2007 改成了phpexcel5.php 因为我没有office2007.
其次,我不知道这个ini_set() 要怎么用,我知道这是面对ini.php设置的。但我不知道。classes这个文件是
要放在那个目录下。是php的根目录,还是放在网站默认的目录。
如果能够明白放在那里,我相信问题可以很好的解决,麻烦知道怎么做的高手,给个方向。谢谢!
/** Error reporting */
error_reporting(E_ALL);/** Include path **/
ini_set('include_path', ini_get('include_path').';../Classes/');/** PHPExcel */
include 'PHPExcel.php';/** PHPExcel_Writer_Excel2007 */
include 'PHPExcel/Writer/Excel2007.php';// Create new PHPExcel object
echo date('H:i:s') . " Create new PHPExcel object\n";
$objPHPExcel = new PHPExcel();// Set properties
echo date('H:i:s') . " Set properties\n";
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");
// Add some data
echo date('H:i:s') . " Add some data\n";
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('B2', 'world!');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Hello');
$objPHPExcel->getActiveSheet()->SetCellValue('D2', 'world!');// Rename sheet
echo date('H:i:s') . " Rename sheet\n";
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Save Excel 2007 file
echo date('H:i:s') . " Write to Excel2007 format\n";
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));// Echo done
echo date('H:i:s') . " Done writing file.\r\n";这个phpexcel官网的代码。
我运行的时候,常出问题。Warning: include(PHPExcel.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include() [function.include]: Failed opening 'PHPExcel.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include(PHPExcel/Writer/Excel5.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 12Warning: include() [function.include]: Failed opening 'PHPExcel/Writer/Excel5.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 12
14:43:25 Create new PHPExcel object
Fatal error: Class 'PHPExcel' not found in D:\WebSite\htdocs\phpexcel-sample1.php on line 16
首先:我改了,把phpexcel2007 改成了phpexcel5.php 因为我没有office2007.
其次,我不知道这个ini_set() 要怎么用,我知道这是面对ini.php设置的。但我不知道。classes这个文件是
要放在那个目录下。是php的根目录,还是放在网站默认的目录。
如果能够明白放在那里,我相信问题可以很好的解决,麻烦知道怎么做的高手,给个方向。谢谢!
解决方案 »
- unix网络编程(书中的例子如何编译运行)
- 【图】W7下MySQL启动时的一个奇怪问题
- 正则高手进,小弟谢过
- 为什么php做项目速度很快?
- switch语句怪异问题~
- 如何实现向svn提交代码时触发执行某脚本
- PHP如何自动生成HTML文件?
- 求简单实用的在线编辑器,
- 请问如果可以得到一个随机字符串,希望能够确保该字串数据库中唯一的
- 讨论 :mysql和ms sqlserver之间的数据交换??
- 以FastCGI方式运行的apache,是不是应该装 NTS版本PHP?
- 求助:1005:Can't create table 'vote.voteradd' (errno: 150)外键连接的表创建错误。
Warning: include(PHPExcel.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include() [function.include]: Failed opening 'PHPExcel.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 9Warning: include(PHPExcel/Writer/Excel2007.php) [function.include]: failed to open stream: No such file or directory in D:\WebSite\htdocs\phpexcel-sample1.php on line 12Warning: include() [function.include]: Failed opening 'PHPExcel/Writer/Excel2007.php' for inclusion (include_path='.;C:\php5\pear;../Classes/') in D:\WebSite\htdocs\phpexcel-sample1.php on line 12
14:49:30 Create new PHPExcel object
Fatal error: Class 'PHPExcel' not found in D:\WebSite\htdocs\phpexcel-sample1.php on line 16
看不懂ini_set(),看明白,把库的地址放在ini_set( string,values);就OK了。。