将数据导出为excel2007格式需要phpexcel库中的哪些文件?我想要最少数量的文件


Which files from phpexcel library are necessary to export data into excel2007 format ? I want minimum number of files

我使用PHPExcel_1.7.9库以.xlsx格式导出数据。这个库包含223个文件和53个文件夹。我想要只对我的功能有用的文件和文件夹(以避免在服务器上上传不必要的文件)。

Bellow是代码,工作非常好。


//----CODE TO EXPORT DATA DIRECTLY AS EXCEL(.XLSX) WITHOUT HELP OF CSV FORMAT ----------  
require_once ROOT_PATH . '/Classes/PHPExcel.php';
        $header=$exportPlugin->getCommonHeader($case,$frmDate,$toDate,$empid,$divId,$excpCode,$reportType,$varType);
        $data=$exportPlugin->getCommonFilterData($case,$frmDate,$toDate,$empid,$divId,$excpCode,$reportType,$varType);
            $base_path1 = dirname(__FILE__);            
            $lastSpacePosition1 = strrpos($base_path1,"'lib");
            $base_path1 = substr($base_path1,0,$lastSpacePosition1);
            $csvName=str_replace(':','',$csvName);
            $pathh=$base_path1.''fileexports'''.$csvName.".xlsx";
            //file_put_contents($pathh, $csvContents);
        $objPHPExcel=new PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0);
        $alpha=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');
        $objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        for($i=0;$igetActiveSheet()->setCellValue($alpha[$i].'1' , $header[$i]);
        }
        $n=3;
        for ($i = 0; $i getActiveSheet()->setCellValue($alpha[$j]. $n, $data[$i][$j]);
                }
        $n++;
        }
        foreach(range('A','Z') as $columnID) {
        $objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);        
        }

        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');
        $objWriter->save($pathh);
        ob_end_clean();     
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment; filename='. $pathh);
        header('Cache-Control: max-age=0');
        readfile($pathh);
        unlink($pathh);         
//-----------------------------------------------------------------------------------------

请告诉我PHPExcel库中有多少个文件或文件夹,我应该保留在项目中,哪些可以删除???

工作环境-
…….服务器-XAMPP
…………Apache/2.2.11(Win32)DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.29
……MySQL客户端版本:5.0.51a
…………PHP扩展名:mysql
O.S-WINDOWS7

如果你必须这样做:

删除除/en子目录中的区域设置文件外的所有区域设置文件。删除所有命名的Readers和Writers以及相关的子目录,但您需要的子目录除外(不过您仍然需要Abstracts和Interface)。删除除Memory/Icache/CacheBase之外的所有CachedObjectStorage选项。如果不使用图表,请删除它们。删除共享PCLZip、OLE文件和Escher。。。。希望我没有误判