original_string: public function close() {
          global $CFG;
  
          foreach ($this->objPHPExcel->getAllSheets() as $sheet){
              $sheet->setSelectedCells('A1');
          }
          $this->objPHPExcel->setActiveSheetIndex(0);
  
          $filename = preg_replace('/\.xlsx?$/i', '', $this->filename);
  
          $mimetype = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
          $filename = $filename.'.xlsx';
  
          if (is_https()) { // HTTPS sites - watch out for IE! KB812935 and KB316431.
              header('Cache-Control: max-age=10');
              header('Expires: '. gmdate('D, d M Y H:i:s', 0) .' GMT');
              header('Pragma: ');
          } else { //normal http - prevent caching at all cost
              header('Cache-Control: private, must-revalidate, pre-check=0, post-check=0, max-age=0');
              header('Expires: '. gmdate('D, d M Y H:i:s', 0) .' GMT');
              header('Pragma: no-cache');
          }
  
          if (core_useragent::is_ie() || core_useragent::is_edge()) {
              $filename = rawurlencode($filename);
          } else {
              $filename = s($filename);
          }
  
          header('Content-Type: '.$mimetype);
          header('Content-Disposition: attachment;filename="'.$filename.'"');
  
          $objWriter = PHPExcel_IOFactory::createWriter($this->objPHPExcel, $this->type);
          $objWriter->save('php://output');
      }
code: public function close() {
          global $CFG;
  
          foreach ($this->objPHPExcel->getAllSheets() as $sheet){
              $sheet->setSelectedCells('A1');
          }
          $this->objPHPExcel->setActiveSheetIndex(0);
  
          $filename = preg_replace('/\.xlsx?$/i', '', $this->filename);
  
          $mimetype = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet';
          $filename = $filename.'.xlsx';
  
          if (is_https()) { // HTTPS sites - watch out for IE! KB812935 and KB316431.
              header('Cache-Control: max-age=10');
              header('Expires: '. gmdate('D, d M Y H:i:s', 0) .' GMT');
              header('Pragma: ');
          } else { //normal http - prevent caching at all cost
              header('Cache-Control: private, must-revalidate, pre-check=0, post-check=0, max-age=0');
              header('Expires: '. gmdate('D, d M Y H:i:s', 0) .' GMT');
              header('Pragma: no-cache');
          }
  
          if (core_useragent::is_ie() || core_useragent::is_edge()) {
              $filename = rawurlencode($filename);
          } else {
              $filename = s($filename);
          }
  
          header('Content-Type: '.$mimetype);
          header('Content-Disposition: attachment;filename="'.$filename.'"');
  
          $objWriter = PHPExcel_IOFactory::createWriter($this->objPHPExcel, $this->type);
          $objWriter->save('php://output');
      }
code_tokens: public function close ( ) { global $ CFG ; foreach ( $ this -> objPHPExcel -> getAllSheets ( ) as $ sheet ) { $ sheet -> setSelectedCells ( 'A1' ) ; } $ this -> objPHPExcel -> setActiveSheetIndex ( 0 ) ; $ filename = preg_replace ( '/\.xlsx?$/i' , '' , $ this -> filename ) ; $ mimetype = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ; $ filename = $ filename . '.xlsx' ; if ( is_https ( ) ) { // HTTPS sites - watch out for IE! KB812935 and KB316431. header ( 'Cache-Control: max-age=10' ) ; header ( 'Expires: ' . gmdate ( 'D, d M Y H:i:s' , 0 ) . ' GMT' ) ; header ( 'Pragma: ' ) ; } else { //normal http - prevent caching at all cost header ( 'Cache-Control: private, must-revalidate, pre-check=0, post-check=0, max-age=0' ) ; header ( 'Expires: ' . gmdate ( 'D, d M Y H:i:s' , 0 ) . ' GMT' ) ; header ( 'Pragma: no-cache' ) ; } if ( core_useragent :: is_ie ( ) || core_useragent :: is_edge ( ) ) { $ filename = rawurlencode ( $ filename ) ; } else { $ filename = s ( $ filename ) ; } header ( 'Content-Type: ' . $ mimetype ) ; header ( 'Content-Disposition: attachment;filename="' . $ filename . '"' ) ; $ objWriter = PHPExcel_IOFactory :: createWriter ( $ this -> objPHPExcel , $ this -> type ) ; $ objWriter -> save ( 'php://output' ) ; }
docstring: Close the Moodle Workbook
docstring_tokens: Close the Moodle Workbook