phpExcel中文手册

下面是总结的几个PHP类phpExcel使用方法创建一个excel$objPHPExcel = new PHPExcel();PHP类phpExcel保存excel—2007格式$objWriter
= new PHPExcel_Writer_Excel2007($objPHPExcel);$objWriter=new
PHPExcel_Writer_Excel5($objPHPExcel);//非2007格
式$objWriter->save("xxx.xlsx");直接输出到浏览器$objWriter = new
PHPExcel_Writer_Excel5($objPHPExcel);header("Pragma:
public");header("Expires:
0");header("Cache-Control:must-revalidate,post-check=0,pre-check=0");header("Content-Type:application/force-download");header("Content-Type:application/vnd.ms-execl");header("Content-Type:application/octet-stream");header("Content-Type:application/download");header('Content-Disposition:attachment;filename="resume.xls"

');header("Content-Transfer-Encoding:binary");$objWriter->save("php://output");

PHP类phpExcel设置excel的属性：创建人
$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.”);设置关键字
$objPHPExcel->getProperties()->setKeywords(”office 2007 openxml php”);种类
$objPHPExcel->getProperties()->setCategory(”Test result file”);

PHP类phpExcel设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);设置sheet的name
$objPHPExcel->getActiveSheet()->setTitle(’Simple’);设置单元格的值
$objPHPExcel->getActiveSheet()->setCellValue(’A1′, ‘String’);
$objPHPExcel->getActiveSheet()->setCellValue(’A2′, 12);
$objPHPExcel->getActiveSheet()->setCellValue(’A3′, true);
$objPHPExcel->getActiveSheet()->setCellValue(’C5′, ‘=SUM(C2:C4)’);
$objPHPExcel->getActiveSheet()->setCellValue(’B8′, ‘=MIN(B2:C5)’);合并单元格
$objPHPExcel->getActiveSheet()->mergeCells(’A18:E22′);PHP类phpExcel分离单元格
$objPHPExcel->getActiveSheet()->unmergeCells(’A28:B28′);保护cell
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
// Needs to be set to true in order to enable any worksheet protection!
$objPHPExcel->getActiveSheet()->protectCells(’A3:E13′, ‘PHPExcel’);设置格式
// Set cell number formats
echo date(’H:i:s’) . ” Set cell number formats\n”;
$objPHPExcel->getActiveSheet()->getStyle(’E4′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle(’E4′), ‘E5:E13′ );

PHP类phpExcel设置宽width
// Set column widths
$objPHPExcel->getActiveSheet()->getColumnDimension(’B’)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension(’D’)->setWidth(12);设置font
$objPHPExcel->getActiveSheet()->getStyle(’B1′)->getFont()->setName(’Candara’);
$objPHPExcel->getActiveSheet()->getStyle(’B1′)->getFont()->setSize(20);
$objPHPExcel->getActiveSheet()->getStyle(’B1′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle(’B1′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
$objPHPExcel->getActiveSheet()->getStyle(’B1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle(’E1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle(’D13′)->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle(’E13′)->getFont()->setBold(true);PHP类phpExcel设置align
$objPHPExcel->getActiveSheet()->getStyle(’D11′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(’D12′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(’D13′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle(’A18′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
//垂直居中
$objPHPExcel->getActiveSheet()->getStyle(’A18′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);PHP类phpExcel设置column的border
$objPHPExcel->getActiveSheet()->getStyle(’A4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle(’B4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle(’C4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle(’D4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle(’E4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);设置border的color
$objPHPExcel->getActiveSheet()->getStyle(’D13′)->getBorders()->getLeft()->getColor()->setARGB(’FF993300′);
$objPHPExcel->getActiveSheet()->getStyle(’D13′)->getBorders()->getTop()->getColor()->setARGB(’FF993300′);
$objPHPExcel->getActiveSheet()->getStyle(’D13′)->getBorders()->getBottom()->getColor()->setARGB(’FF993300′);
$objPHPExcel->getActiveSheet()->getStyle(’E13′)->getBorders()->getTop()->getColor()->setARGB(’FF993300′);
$objPHPExcel->getActiveSheet()->getStyle(’E13′)->getBorders()->getBottom()->getColor()->setARGB(’FF993300′);
$objPHPExcel->getActiveSheet()->getStyle(’E13′)->getBorders()->getRight()->getColor()->setARGB(’FF993300′);

PHPExcel 可以导出 图形统计么? 柱形扇形...

PHPExcel执行到$objReader->load()后就无法继续执行了，求帮忙解决一下，可以有偿答谢

//excel导入
public function execldr(){


//下面的路径按照你PHPExcel的路径来修改
require_once *execl/PHPExcel.php*;
require_once *execl/PHPExcel/Reader/Excel5.php*;

//自己设置的上传文件存放路径
$filePath = *uploadfile/execl/*;
$str = "";
//注意设置时区
$time=date("ymdHis");//去当前上传的时间
//获取上传文件的扩展名
$extend=strrchr ($_FILES["uploadfile"]["name"],*.*);
//上传后的文件名
$name=$time.$extend;
$uploadfile=$filePath.$name;//上传后的文件名地址
//move_uploaded_file() 函数将上传的文件移动到新位置。若成功，则返回 true，否则返回 false。
$result=move_uploaded_file($_FILES["uploadfile"]["tmp_name"],$uploadfile);//假如上传到当前目录下
//echo $result;
chmod($uploadfile,0775);
sleep(5);
if($result) //如果上传文件成功，就执行导入excel操作
{
$objReader = PHPExcel_IOFactory::createReader(*Excel5*);//use excel2007 for 2007 format
$objPHPExcel = $objReader->load($uploadfile);
//内容转换为数组
$indata = $objPHPExcel->getSheet(0)->toArray();
$catid=$_POST[*catid*];
$this->db->query("SELECT auto_increment FROM information_schema.`TABLES` WHERE TABLE_NAME=*jzpro*");
$jzid=$this->db->fetch_array();
$id=$jzid[0][*auto_increment*];
//把数据新增到mysql数据库中
$this->db->query("SELECT *FROM jzpro order by id desc limit 1");
$da=$this->db->fetch_array();
$urls=explode("&id=",$da[0][*url*]);
$url=$urls[0];
$url.="&id=$id";
$username=$this->_username;
$time=time();
for($i=2;$i<=count($indata);$i++){
$item=$indata[$i];
$sql = "INSERT INTO jzpro VALUES(NULL,$catid,0,*$item[1]*,**,**,**,*$item[1]*,0,*$url*,0,99,1,0,*administrator*,$time,$time,$item[2],$item[3],*$item[4]*,*$item[5]*,*$item[6]*)";
$this->db->query($sql);
$di=mysql_insert_id();
if($i!=1){
$url=$urls[0];
$idl=$di+1;
$url=$url.="&id=$idl";
}
$return=$this->db->query("INSERT INTO jzpro_data VALUES($di,*$item[7]*,0,**,0,0,**,0,1,**)");
$zh=$this->db->affected_rows();
};
unlink($uploadfile);
if($zh>0){
showmessage("导入成功");
}else{
showmessage("导入失败");
};

}else{
showmessage("execl上传失败");
}
}

导出的时候出现中文乱码，求大神指点

楼主，导出的话添加批注怎么添啊