使用phpexcel读写xls文件
来源:互联网 发布:删除表中数据的sql语句 编辑:程序博客网 时间:2024/06/06 21:38
<?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');
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');
转载自:http://www.dedecms.com/knowledge/program/php/2012/0620/1655.html
0 0
- 使用phpexcel读写xls文件
- 使用 PHPExcel 读取\修改 xls文件
- 使用 phpExcel 读取xls/xlsx文件到数据库
- XLS文件的读写
- 使用PHPExcel生成excel、xls的格式文件
- PHP在使用PHPExcel组件导出xls文件乱码的解决
- 使用phpexcel导出到xls文件的时候出现乱码解决【已解决】
- 使用phpexcel导出到xls文件的时候出现乱码解决
- 使用phpexcel导出到xls文件的时候出现乱码解决
- PHP在使用PHPExcel组件导出xls文件乱码的解决
- 使用PHPExcel导出文件
- 用PHPExcel将数据写进xls并保存成xls文件
- PHP读写excel文件 (封装 PHPExcel )
- C++里如何读写xls文件
- 利用NPOI组件读写XLS文件
- 【原创】.NET读写Excel工具Spire.Xls使用(2)Excel文件的控制
- java使用jxl包读写excel表格文件,即xls格式文件
- 使用ExcelDataReader读写excel(.xls,.xlsx)
- 栈应用--行编辑程序
- android判断设备是模拟器还是真机
- hdu 4826 Labyrinth
- 算个鸟的第一贴
- Linux下git基本使用总结<2>
- 使用phpexcel读写xls文件
- loarunner 学习之路二
- 假如给你一百万(看完你会放下很多,很多)
- var_dump()函数输出不完整,有省略号的解决办法
- Ubuntu搭建Eclipse+JDK+SDK的Android
- 专注于<递归算法和分治思想>
- Transact-SQL 语法规则
- varchar和nvarchar的区别:
- java 正则表达式的一个理解.