会python真的可以为所欲为0(回)
397天前
这里还有人吗1(回)
582天前这里还有人吗0(回)
582天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
807天前到处都是羊，不想上班0(回)
887天前
鸽子
0(回)
891天前<?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'); |
