| 搜索 |
public function excelToHtml(){
$id=I("id");
$path="./Uploads/ExcelHtmlData/";
$filename=M('Excelfiles')->field("files")->find($id);
$filename =$filename['files'];
$bro=getbrowser();
if(strpos($bro['browser'],'Explorer') and $bro['version'] < 9){
$file_name=md5(pathinfo($filename,PATHINFO_FILENAME));
$htmldata=$path.$file_name.'.html';
if (is_file($htmldata)) {
}else{
vendor("PHPExcel.PHPExcel");
$filename=".".iconv("UTF-8", "GBK", $filename);
$ext=pathinfo($filename,PATHINFO_EXTENSION);
if (strlen($ext)==4) {
$objReader =new \PHPExcel_Reader_Excel2007();
}else{
$objReader =new \PHPExcel_Reader_Excel5();
}
$objWriteHTML =new \PHPExcel_Writer_HTML($objReader->load($filename));
$objWriteHTML->writeAllSheets();
$html=$objWriteHTML->save($htmldata);
}
}else{
$tourl="https://view.officeapps.live.com/op/view.aspx?src=http://oa.xinxing-pipes.com/gufenduibiao";
$htmldata=$tourl.urlencode($filename);
}
$this->assign("html", $htmldata);
$this->display();
}
然后在模板文件引入即可