phpexcel 读写xls文件例子
发布时间:2020-05-25 06:55:02 所属栏目:PHP 来源:互联网
导读: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)为你收集整理的全部代码内容,希望文章能够帮你解决所遇到的程序开发问题。 如果觉得脚本之家网站内容还不错,欢迎将脚本之家网站推荐给程序员好友。 (编辑:安卓应用网) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |