public function exportDataToExcel(){


        set_time_limit(0);
        ini_set('MAX_EXECUTION_TIME', -1);


        if (isset($_POST['sn_externalid']) && $_POST['sn_externalid'] == 'S'){
           $ShowExternalId = 'Y';
        }else{
            $ShowExternalId = 'N';
        }
        if (isset($_POST['sn_value']) && $_POST['sn_value'] == 'S'){
            $ShowValue = 'Y';
        }else{
            $ShowValue = 'N';
        }
        if (isset($_POST['sn_score']) && $_POST['sn_score'] == 'S'){
            $ShowScore = 'Y';
        }else{
            $ShowScore = 'N';
        }

        $filters = $this->session->userdata('pesquisaaplicada_filters');
        $amb_id = $this->params['amb_id'];
        $return = 'H';
        $Environment = $amb_id;
        $Lang = $this->lang->lang();


        //echo date('Y-m-d 00:00:00.000', strtotime($filters['data_inclusao']));

        //exit();


          if (isset($filters["data_inclusao"]) && !empty($filters["data_inclusao"])){

            $filters["data_inclusao"] =  date('Y-m-d 00:00:00.000', strtotime($filters['data_inclusao']));

          }else{
            $filters["data_inclusao"] = '1969-01-01 00:00:00.000';
          }

          if (isset($filters["data_inclusaofim"]) && !empty($filters["data_inclusaofim"])){

            $filters["data_inclusaofim"] =  date('Y-m-d 23:59:59.999', strtotime($filters['data_inclusaofim']));

          }else{
            $filters["data_inclusaofim"] = '2100-12-31 23:59:59.999';
          }

          if (isset($filters["usu_id"]) && !empty($filters["usu_id"])){

            $filters["usu_id"] =  $filters["usu_id"];

          }else{
           $filters["usu_id"] =  0;
          }

          if (isset($filters["est_id"]) && !empty($filters["est_id"])){

            $filters["est_id"] =  $filters["est_id"];

          }else{
           $filters["est_id"] =  0;
          }

          //echo $filters["data_inclusao"];

        // echo $filters["data_inclusaofim"];

        //chamada da procedure para retorno do Header
        $resultsHeader = $this->pesquisa_aplicada_model->exportDataSP($Environment,$filters['psq_id'],$ShowExternalId,$ShowValue,$ShowScore,$return,$Lang,  $filters["data_inclusao"]  , $filters["data_inclusaofim"],  $filters["usu_id"] , $filters["est_id"]);
        $resultsRow = array();
        $returnRow = 'R';

        //chamada da procedure para retorno das rows
        $resultsRow = $this->pesquisa_aplicada_model->exportDataSPAll($Environment,$filters['psq_id'],$ShowExternalId,$ShowValue,$ShowScore,$returnRow,$Lang, $filters["data_inclusao"]  , $filters["data_inclusaofim"],  $filters["usu_id"] , $filters["est_id"]);

        $file = $amb_id . '_' . $this->params['user_login'] . '.xls';


        //chamada do metodo para o export
       //$this->queryToExcel($resultsHeader, $resultsRow, $file);
        /*
        $fileLocationHeader = getcwd() . "\assets\uploads\\" . "/Header.txt";

        $toBeSaved = serialize($resultsHeader);
        file_put_contents( $fileLocationHeader, $toBeSaved);
        echo "criou o arquivo do header";

        echo "<br />";*/

        $fileLocationRow = getcwd() . "\assets\uploads\\" . "/Rows.txt";

        $toBeSavedRow = serialize($resultsRow);
        file_put_contents( $fileLocationRow, $toBeSavedRow);

        echo "criou o arquivo das rows";

        echo "<br />";

        echo "lendo um arquivo";

        $str = file_get_contents($fileLocationRow);
        $arr = unserialize($str);
        echo "<pre>";
      //  print_r($arr);

        echo count($arr);

          //exit();
    }