PHP生成Excel报表的方法.docx

PHP生成Excel报表的方法

WPSOffice支持桌面和移动办公。且WPS移动版通过GooglePlay平台，已覆盖的50多个国家和地区，WPSforAndroid在应用排行榜上领先于微软及其他竞争对手，居同类应用之首。接下来是小编为大家收集的PHP生成Excel报表的方法，希望能帮到大家。PHP生成Excel报表的方法PHP生成Excel报表$path='/usr/share/pear';//你自定义的PEAR路径set_include_path(get_include_path().PATH_SEPARATOR.$path);//设置PHP环境变量路径为除php.ini默认的以外,再加上你自定义的PEAR路径require'/usr/share/pear/Spreadsheet/Excel/Writer.php';//包含PEAR::Spreadsheet_Excel_Writer类文件$name='atyu30';$work=$_POST['file_body'];$num='10';$filename=$_POST['file_name'];$name_suffix01='_报告.xls';$name_suffix02=iconv('utf-8','gb2312',$name_suffix01);$workbook=newSpreadsheet_Excel_Writer();//实例化PEAR::Spreadsheet_Excel_Writer类$workbook->send($filename.$name_suffix02);//发送Excel文件名供下载$workbook->setVersion(8);$worksheet=&$workbook->addWorksheet('sheet-1');//加入一个工作表sheet-1$worksheet->setInputEncoding('utf-8');//指定行编码$data=array(array('姓名','节目清单','上传数量'),array($name,$work,$num),array($name,$work,$num),);for($row=0;$rowfor($col=0;$col$worksheet->writeString($row,$col,$data[$row][$col]);//在sheet-1中写入数据}}$worksheet=&$workbook->addWorksheet('sheet-2');//加入一个工作表sheet-2$worksheet->setInputEncoding('utf-8');//指定行编码$data=array(array('姓名','节目清单','上传数量'),array($name,$work,$num),array($name,$work,$num),);for($row=0;$rowfor($col=0;$col$worksheet->writeString($row,$col,$data[$row][$col]);//在sheet-2中写入数据}}$workbook->close();//完成下载echo$name;