php 导出文件压缩包 ZipArchive

    //写入xls文件
    function pro_xls($sContent,$_userid,$sname){
        //生成xls文件
        $exportdir =PHP_ROOT.'data/export/'.$_userid.'/';
        if(!is_dir($exportdir)) mkdir($exportdir);
        $elsfile=$exportdir.$sname.'.xls';
        $file = fopen($elsfile, 'w');
        fwrite($file, $sContent);
        fclose($file);
        return  $elsfile;

    }
    //zip
    function pro_zip($aFiles,$_userid,$sname){
        //zip
        $exportdir =PHP_ROOT.'data/export/'.$_userid.'/';
        $zipname=$sname.'.zip';
        $zip_file_path=$exportdir.$zipname;
        $oZip = new ZipArchive();
        if($oZip->open($zip_file_path,ZipArchive::CREATE)==TRUE){

        foreach ($aFiles as $file){
            $oZip->addFile($exportdir.$file, $file);
        }
        $oZip->close();
        //下载链接
        $downfile="http://".$_SERVER['HTTP_HOST'].'/data/export/'.$_userid.'/'.$zipname;
        return $downfile;
        }
        return false;


    }
    //csv用  
    function pro_zip_csv($info,$sContent,$_userid,$sname){
        $exportdir =PHP_ROOT.'data/export/'.$_userid.'/';
        if(!is_dir($exportdir)) mkdir($exportdir);

        //生成csv文件
        $elsfile=$exportdir.$sname.'.csv';
        $fp = fopen($elsfile, 'w');
         //Windows下使用BOM来标记文本文件的编码方式 
        fwrite($fp,chr(0xEF).chr(0xBB).chr(0xBF)); 
        foreach ($info as $line) { 
            fputcsv($fp, $line);
        }
        fclose($fp);           

        //zip
        $zipname=time().'.zip';
        $zip_file_path=$exportdir.$zipname;
        $oZip = new ZipArchive();
        if($oZip->open($zip_file_path,ZipArchive::CREATE)==TRUE){
            $oZip->addFile($elsfile, $sname.'.csv');
            $oZip->close();
            //下载链接
            $downfile="http://".$_SERVER['HTTP_HOST'].'/data/export/'.$_userid.'/'.$zipname;
            return $downfile;
        }
        return false;
    }
1.获取PHPExcel 2.添加如下方法: function Excel_Export($filename,$data,$sheet){ error_reporting(E_ALL); ini_set('display_errors','On'); /** Include path **/ set_include_path(get_include_path() . PATH_SEPARATOR . '../Classes/'); /** PHPExcel */ include 'api/excel/PHPExcel.php'; /** PHPExcel_Writer_Excel2007 */ include 'api/excel/PHPExcel/Writer/Excel2007.php'; // Create new PHPExcel object //echo date('H:i:s') . "Create new PHPExcel object\n"; $objPHPExcel = new PHPExcel(); // Set properties //echo date('H:i:s') . "Set properties\n"; $objPHPExcel->getProperties()->setCreator("E421083458"); $objPHPExcel->getProperties()->setLastModifiedBy("E421083458"); $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"); // Add some data //echo date('H:i:s') . "Add some data\n"; $objPHPExcel->setActiveSheetIndex(0); $charlist = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"); //print_r($data); foreach($data as $key=>$value){ $j=0; if($key==0){ foreach($value as $k=>$v){ if($j<25){ $objPHPExcel->getActiveSheet()->setCellValue($charlist[$j].($key+1), mb_convert_encoding($k, "UTF-8", "GBK")); $j++; } } $j=0; } foreach($value as $k=>$v){ if($j<25){ //echo $charlist[$j].($key+1)."<br/>"; //echo $v."<br/>"; $objPHPExcel->getActiveSheet()->setCellValue($charlist[$j].($key+2), mb_convert_encoding($v, "UTF-8", "GBK")); $j++; } } } // Rename sheet //echo date('H:i:s') . "Rename sheet\n"; $objPHPExcel->getActiveSheet()->setTitle(mb_convert_encoding($sheet,
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值