phpexcel 读写xls文件例子

开发技术作者： 2024-07-28 01:10:01

phpexcel 读写xls文件例子

下面是编程之家 jb51.cc 通过网络收集整理的代码片段。

编程之家小编现在分享给大家，也给大家做个参考。

<?PHP
include_once('PHPExcel.PHP');
//read excel file;
$PHPExcel = new PHPExcel();    
$PHPReader = new PHPExcel_Reader_Excel5();
$PHPExcel = $PHPReader->load('/home/yuanjianjun/taobao_cat.xls');
$currentSheet = $PHPExcel->getSheet(0);
$allColumn = $currentSheet->getHighestColumn();
$allRow = $currentSheet->getHighestRow();
for($currentRow = 1; $currentRow<=$allRow; $currentRow++){
   for($currentColumn='A'; $currentColumn<=$allColumn; $currentColumn++){  
    $address = $currentColumn.$currentRow;  
    echo $currentSheet->getCell($address)->getValue()."\t";  
   }
   echo "\n";
}
 
 
//write excel file
$objExcel = new PHPExcel();
$objWriter = new PHPExcel_Writer_Excel5($objExcel);
$objProps = $objExcel->getProperties();  
$objProps->setCreator("yuan");
$objProps->setLastModifiedBy("yuan");
$objProps->setTitle("excel test");  
$objProps->setSubject("my excel test");
$objProps->setDescription("hello world.");  
$objProps->setKeywords("PHPExcel");
$objProps->setCategory("EXCEL");
$objExcel->setActiveSheetIndex(0);
$objActSheet = $objExcel->getActiveSheet();
$objActSheet->setTitle('TEST1');
$objActSheet->setCellValue('A1','字符串内容');
$objActSheet->setCellValue('A2',26);
$objActSheet->setCellValue('A3',true);
$objActSheet->setCellValue('A4','=A2+A2');
$objWriter->save('/home/yuanjianjun/helloworld.xls');  
 
 
//copy excel format
$objReader = PHPExcel_IOFactory::createReader('Excel5');
$objPHPExcel = $objReader->load('/home/yuanjianjun/20100301.xls');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');
$objWriter->_PHPExcel->setActiveSheetIndex(0);
$objWriter->_PHPExcel->getActiveSheet()->setCellValue('A1','FESDF');
$objWriter->_PHPExcel->getActiveSheet()->setCellValue('B1','S');
$objWriter->_PHPExcel->getActiveSheet()->setCellValue('C1','FEFSD');
$objWriter->_PHPExcel->getActiveSheet()->setCellValue('D1','SDFD');
$objWriter->_PHPExcel->getActiveSheet()->setCellValue('E1','淘宝CPS');
$objWriter->save('/home/yuanjianjun/copy.xls');

以上是编程之家(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

原创声明

本站部分文章基于互联网的整理，我们会把真正“有用/优质”的文章整理提供给各位开发者。本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。

本文链接：http://www.jiecseo.com/news/show_51992.html

相关资讯： phpexcel 读写xls文件例子