PHPExcel export problem

[Naurich]

Hello everyone.

I can not export data with PHPExcel library. I have two buttons, where one is for data filtering, and another for data export to excel. Filtering is working fine, but when I making export to excel, it giving me just some characters, but not data. Here is my code, could someone explain me, what I am doing wrong.

<?phpinclude_once 'partials/headers.php';?><?phpif(isset($_POST['search'])) {      $search = "%".$_POST['search_text']."%";        //validate the token        if(!empty($search)) {            //check if user exist in the database                $sqlQuery = "SELECT * FROM pers_dat_sanem WHERE par_ko_sniedz LIKE :search";                 $statement = $db->prepare($sqlQuery);                $statement->execute(array(':search'=> $search));                   function getRow($statement) {                    return $statement->fetch();                }        } }?><br><form action="search.php" method="post">                <div class="form-group">                       <div class="input-group">                            <span class="input-group-addon">Meklēt</span>                            <input type="text" name="search_text" id="search_text" placeholder="<?php if(isset ($_POST['search_text'])) {echo ($_POST['search_text']);} ?>" class="form-control" value="" />                       </div>                  </div>                 <div align="center">                <button type="submit" name="search" class="btn btn-default" value="search">Meklēt</button>            </div></form><div class="table-responsive" id="nod_dat"> <?php if(isset($statement)) { $statement->rowCount() > 0 ?>     <h4 align="center">Saņemto personas datu meklēšanas rezultāti</h4>  <table id="result_np" class="table table bordered">      <tr>                                      <th>Datu saņemšanas laiks</th>                                      <th>Persona kas sniedz datus</th>                                        <th>Personas datu sniedzēja adrese</th>                                       <th>Persona kas saņem datus</th>                                        <th>Persona par ko sniedz datus</th>                                        <th>Saņemtie datu veidi</th>                                        <th>Datu saņemšanas mērķis</th>                               </tr>      <?php }; ?><?php if(isset($statement)) {while($row = getRow($statement)) :?>                <tr>                       <td><?php echo $row["dat_san_laik"]; ?></td>                      <td><?php echo $row["pers_kas_dod"]; ?></td>                     <td><?php echo $row["kas_dod_adrese"]; ?></td>                     <td><?php echo $row["pers_kas_sanem"]; ?></td>                      <td><?php echo $row["par_ko_sniedz"]; ?></td>                       <td><?php echo $row["datu_veidi"]; ?></td>                        <td><?php echo $row["datu_san_merk"]; ?></td>                                </tr>          <?php endwhile; ?>  </table>      <form method="post">        <fieldset>            <legend>Lejupielādēt rezultātu</legend>            <p>                <input type="submit" name="download" id="download" value="Lejupielādēt failu">            </p>        </fieldset>    </form>  <?php }; ?></div><?php    if (isset($_POST['download'])) {            require_once 'src/PHPExcel.php';                try {                    $sheet = new PHPExcel();                        $sheet->getProperties()->setCreator('www.zemgale.lv/dvi')                               ->setLastModifiedBy('www.zemgale.lv/dvi')                               ->setTitle('Atrasto datu izdruka')                               ->setKeywords('dati subjekts apstrāde');                    $sheet->getDefaultStyle()->getAlignment()->setVertical(                                PHPExcel_Style_Alignment::VERTICAL_TOP);                    $sheet->getDefaultStyle()->getAlignment()->setHorizontal(                PHPExcel_Style_Alignment::HORIZONTAL_CENTER);        $sheet->getDefaultStyle()->getFont()->setName('Arial');        $sheet->getDefaultStyle()->getFont()->setSize(12);                $sheet->setActiveSheetIndex(0);        $activeSheet = $sheet->getActiveSheet();        $activeSheet->getPageSetup()->setOrientation(                PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE)                ->setFitToWidth(1)                ->setFitToHeight(0);                $activeSheet->getHeaderFooter()->setOddHeader('&C&B&16' .                     $sheet->getProperties()->getTitle())                    ->setOddFooter('&CPage &P of &N');        // Set column headings        $sheet->getActiveSheet()                ->setCellValue('A1', 'Datu saņemšanas laiks')                ->setCellValue('B1', 'Persona kas sniedz datus')                ->setCellValue('C1', 'Personas datu sniedzēja adrese')                ->setCellValue('D1', 'Persona kas saņem datus')                ->setCellValue('E1', 'Persona par ko sniedz datus')                ->setCellValue('F1', 'Saņemtie datu veidi')                ->setCellValue('G1', 'Datu saņemšanas mērķis')                ;        // Populate individual cells with data               //column number, which we will be incrementing$colnum=1;foreach ($row as $value){    $colnum++;    $sheet->getActiveSheet()->SetCellValue('A'."$colnum", $value["dat_san_laik"]);    $sheet->getActiveSheet()->SetCellValue('B'."$colnum", $value["pers_kas_dod"]);    $sheet->getActiveSheet()->SetCellValue('C'."$colnum", $value["kas_dod_adrese"]);    $sheet->getActiveSheet()->SetCellValue('D'."$colnum", $value["pers_kas_sanem"]);    $sheet->getActiveSheet()->SetCellValue('E'."$colnum", $value["par_ko_sniedz"]);    $sheet->getActiveSheet()->SetCellValue('F'."$colnum", $value["datu_veidi"]);    $sheet->getActiveSheet()->SetCellValue('G'."$colnum", $value["datu_san_merk"]);}              // Generate Excel file and download        header('Content-Type: application/vnd.ms-excel;');        header('Content-Disposition: attachment;filename="data.xls"');        header('Cache-Control: max-age=0');         $writer = PHPExcel_IOFactory::createWriter($sheet, 'Excel2007');        $writer->save('php://output');        exit;    } catch (Exception $e) {        $error = $e->getMessage();    }} ?>