Solution to conflicts between ThinkPHP and PHPExcel

A long time ago, I knew that a class called PHPExcel (Official Website) could be used to operate Excel. I have never had a chance to try it. Today I tried it and found it very powerful. The downloaded source code package contains detailed documents, almost all functions that can be achieved by manual Excel operations.
An example of reading an Excel file is as follows: Copy codeThe Code is as follows: $ inputFileType = 'excel2007 ';
$ InputFileName = './public/files/import_user_template.xlsx ';
$ Sheetname = 'sheet1 ';
// Specify the Excel type and create a reader
$ ObjReader = PHPExcel_IOFactory: createReader ($ inputFileType );
// Set to read data only, excluding formulas and formats
$ ObjReader-> setReadDataOnly (true );
// Read only the specified sheet
$ ObjReader-> setLoadSheetsOnly ($ sheetname );
$ ObjPHPExcel = $ objReader-> load ($ inputFileName );
$ CurSheet = $ objPHPExcel-> getSheet (0 );
// Maximum column containing data
$ AllColumn = $ curSheet-> getHighestColumn ();
// The largest row containing data
$ AllRow = $ curSheet-> getHighestRow ();
For ($ currentRow = 1; $ currentRow <= $ allRow; $ currentRow ++ ){
For ($ currentCol = 'a'; $ currentCol <= $ allColumn; $ currentCol ++ ){
Echo $ curSheet-> getCell ($ currentCol. $ currentRow)-> getValue (). "\ t ";
}
Echo "\ r \ n ";
}

To be used in ThinkPHP, copy the Classes directory in the source code package to the vender directory of ThinkPHP, change the name to PHPExcel, and then call the Vendor method to loadCopy codeThe Code is as follows: vendor ('phpexcel. PHPExcel ');

However, after reading the Excel file, you can call the M or D Method to instantiate the Model class and the Model class cannot be found. After research, we found that the automatic loader System conflict should be resolved, use the spl_autoload_register function to re-register the autoloader class before calling the M or D method.Copy codeThe Code is as follows: spl_autoload_register (array ('think', 'autoload '));

Solution to PHPExcel call in ThinkPHP
When PHPExcel is called in ThinkPHP, the data can be fully read, but the next step D, M or template call will cause an error. (I don't know if I encountered this problem by myself ?)
After research, we finally found a solution. Share with you. Haha!
1. First download the PHPExcel package and place it under ThinkPHP/Vendor/(that is, the third-party class library directory of Think.
2. Call a function.Copy codeThe Code is as follows: protected function Import_Execl ($ file ){
If (! File_exists ($ file )){
Return array ("error" => 1 );
}
Vendor ("PHPExcel. PHPExcel ");
$ PHPExcel = new PHPExcel ();
$ PHPReader = new PHPExcel_Reader_Excel2007 ();
If (! $ PHPReader-> canRead ($ file )){
$ PHPReader = new PHPExcel_Reader_Excel5 ();
If (! $ PHPReader-> canRead ($ file )){
Return array ("error" => 2 );
}
}
$ PHPExcel = $ PHPReader-> load ($ file );
$ SheetCount = $ PHPExcel-> getSheetCount ();
For ($ I = 0; $ I <$ SheetCount; $ I ++ ){
$ CurrentSheet = $ PHPExcel-> getSheet ($ I );
$ AllColumn = $ this-> ExcelChange ($ currentSheet-> getHighestColumn ());
$ AllRow = $ currentSheet-> getHighestRow ();
$ Array [$ I] ["Title"] = $ currentSheet-> getTitle ();
$ Array [$ I] ["Cols"] = $ allColumn;
$ Array [$ I] ["Rows"] = $ allRow;
$ Arr = array ();
For ($ currentRow = 1; $ currentRow <= $ allRow; $ currentRow ++ ){
$ Row = array ();
For ($ currentColumn = 0; $ currentColumn <$ allColumn; $ currentColumn ++ ){
$ Row [$ currentColumn] = $ currentSheet-> getCellByColumnAndRow ($ currentColumn, $ currentRow)-> getValue ();
}
$ Arr [$ currentRow] = $ row;
}
$ Array [$ I] ["Content"] = $ arr;
}
Spl_autoload_register (array ('think', 'autoload'); // required, otherwise ThinkPHP and PHPExcel will conflict
Unset ($ currentSheet );
Unset ($ PHPReader );
Unset ($ PHPExcel );
Unlink ($ file );
Return array ("error" => 0, "data" => $ array );
}
Protected function ExcelChange ($ str) {// function used with Execl batch Import
$ Len = strlen ($ str)-1;
$ Num = 0;
For ($ I = $ len; $ I >=0; $ I --){
$ Num + = (ord ($ str [$ I])-64) * pow (26, $ len-$ I );
}
Return $ num;
}

3. Call.Copy codeThe Code is as follows: public function import (){
If (isset ($ _ FILES ["import"]) & ($ _ FILES ["import"] ["error"] = 0 )){
$ Result = $ this-> Import_Execl ($ _ FILES ["import"] ["tmp_name"]);
If ($ this-> Execl_Error [$ result ["error"] = 0 ){
$ Execl_data = $ result ["data"] [0] ["Content"];
Unset ($ execl_data [1]);
$ Data = D ("Data ");
Foreach ($ execl_data as $ k => $ v ){
$ D ["serial_no"] = $ v [0];
$ D ["check_no"] = $ v [1];
$ D ["work_no"] = $ v [2];
$ D ["class_name"] = $ v [3];
$ D ["user_name"] = $ v [4];
$ D ["new_class"] = $ v [5];
$ D ["error_level"] = $ v [6];
$ Data-> data ($ d)-> add ();
}
$ This-> success ($ this-> Execl_Error [$ result ["error"]);
} Else {
$ This-> error ($ this-> Execl_Error [$ result ["error"]);
}
} Else {
$ This-> error ("File Upload Failed ");
}
}

4. Error Data:Copy codeThe Code is as follows: protected $ Execl_Error = array ("data imported successfully", "file not found", "Incorrect Execl File Format ");