title: Exporting data from database in php,and the file format for excel export should be as windows 97-2003 workbook
body: <p>Below is my code to export data from mysql database. It works properly, but while exporting excel file, file saved as in tab delimeter format. I just need to save it in windows 97-2003 workbook. I keep changing on header's, but it doesn't work.. while open those file it popups some alert such as "the file you are trying to open,'filename.xls', is in different format than specified by the file extension.." I need to rid on it. Can any one give suggestion.. thanks in advance :)  </p>
  
  <p>HTML coding:</p>
  
  <pre><code>&lt;input type="submit" name="frmDownload" id="frmDownload" value="CSV" title="Export" class="frmDownloadButton" /&gt;
  &lt;input type="submit" name="frmDownload" id="frmDownload" value="Excel" title="Export" class="frmDownloadButton" /&gt;
  &lt;input type="submit" name="frmDownload" id="frmDownload" value="TEXT" title="Export" class="frmDownloadButton" /&gt;
  &lt;input type="submit" name="frmDownload" id="frmDownload" value="XML" title="Export" class="frmDownloadButton" /&gt;  
  </code></pre>
  
  <p>PHP routine:</p>
  
  <pre><code>if ($_POST["frmDownload"]) { 
      $output = "";
      $line_terminated="\r\n";
      $strDatas = array();
      $field_terminated = doGetFieldDelimeter($_POST);
      $export_schema = "Name".$field_terminated."Code".$field_terminated."Email".$field_terminated."Designation".$field_terminated."Number".$field_terminated."Salary".$field_terminated."Age";
      $strDataQuery = doSelectRecords();
      $strDatas = $strDataQuery;
      $output.= doGetExportSchema($_POST,$export_schema);
      $delimeter = doGetDelimeterForTextFile($_POST);
      $output.= doExportData($_POST, $strDatas, $field_terminated, $line_terminated, $delimeter);
      $output.= doGetXmlTitle($_POST);
      doGetHeader($_POST,$output,$objPHPExcel);
      echo $output;
      exit;
  }
  </code></pre>
  
  <p>functions:</p>
  
  <pre><code>function doSelectRecords()
  {
      $strSql = "SELECT * FROM tbl_employee";
      $strResult = SelectQry($strSql);
      return $strResult;
  }
  
  
  function SelectQry($Qry) {
      $result = mysql_query($Qry) or die ("QUERY Error:".$Qry."&lt;br&gt;".mysql_error());      
      $numrows = mysql_num_rows($result); 
      if ($numrows == 0) {            
          return;
      } else {
         $row = array(); 
         $record = array();
         while ($row = mysql_fetch_array($result)) { 
              $record[] = $row; 
         }        
      }   
      return MakeStripSlashes($record);
  }
  
  function doGetExportSchema($objArray,$export_schema)
  {
  
      if ($objArray["frmDownload"] =="XML") {
          $output.= '';
          $output.= '&lt;employee&gt;';
      } else {
          $output.= $export_schema;
      }
      return $output;
  }
  
  function doGetDelimeterForTextFile($objArray)
  {
      if($objArray["frmDownload"] =="TEXT") {
          $delimeter = '\t';
      } else {
          $delimeter = '';
      }
      return $delimeter;
  }
  
  function doExportData($objArray,$strDatas,$field_terminated,$line_terminated,$delimeter = NULL)
  {
  
      for ($k=0; $k&lt;count($strDatas); $k++) {
          $strData = $strDatas[$k];
          if ($objArray["frmDownload"] == "XML") {
              $output.= $line_terminated;
              $output.= '&lt;row&gt;';
              $output.= $line_terminated;
              $output.= '&lt;name&gt;'.$strData['1'].'&lt;/name&gt;'.$field_terminated;
              $output.= '&lt;code&gt;'.$strData['2'].'&lt;/code&gt;'.$field_terminated;
              $output.= '&lt;email&gt;'.$strData['3'].'&lt;/email&gt;'.$field_terminated;
              $output.= '&lt;designation&gt;'.$strData['4'].'&lt;/designation&gt;'.$field_terminated;
              $output.= '&lt;number&gt;'.$strData['5'].'&lt;/number&gt;'.$field_terminated;
              $output.= '&lt;salary&gt;'.$strData['6'].'&lt;/salary&gt;'.$field_terminated;
              $output.= '&lt;age&gt;'.$strData['7'].'&lt;/age&gt;'.$field_terminated;
              $output.= '&lt;/row&gt;'.$field_terminated;
          } else {
              $output.= $line_terminated;
              $output.= $strData['1'].$field_terminated;
              $output.= $strData['2'].$field_terminated;
              $output.= $strData['3'].$field_terminated;
              $output.= $strData['4'].$field_terminated;
              $output.= $strData['5'].$field_terminated;
              $output.= $strData['6'].$field_terminated;
              $output.= $strData['7'].$delimeter;
          }
      }
      return $output;
  }
  
  
  function doGetFieldDelimeter($objArray) 
  {
  
      switch ($objArray["frmDownload"]) {
          case "CSV":
              echo $field_terminated= ",";
              break;
          case "Excel":
              echo $field_terminated="\t";
              break;
          case "TEXT":
              echo $field_terminated="|";
              break;
          case "XML":
              echo $field_terminated="\r\n";
              break;
      }
      return $field_terminated;
  }
  
  function doGetXmlTitle($objArray)
  {
      if ($objArray["frmDownload"] == "XML") {
          $output.= '&lt;/employee&gt;';
      }
      return $output;
  }
  
  function doGetHeader($objArray,$output,$objPHPExcel = NULL)
  {
      header("Content-Description: File Transfer");
      switch ($objArray["frmDownload"]) {
          case "CSV":
              header("Content-Type: application/csv");
              header("Content-Disposition: attachment; filename=employee_details.csv");
              break;
          case "Excel":
              header("Pragma: public");
              header("Expires: 0");
              header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
              header("Content-Type: application/force-download");
              header("Content-Type: application/octet-stream");
              header("Content-Type: application/download");;
              header("Content-Disposition: attachment;filename=Report.xls");
              header("Content-Transfer-Encoding: binary ");
              break;
          case "TEXT":
              header("Content-Type: application/txt");
              header("Content-Disposition: attachment; filename=employee_details.txt");
              break;
          case "XML":
              header("Content-Type: application/xml");
              header("Content-Disposition: attachment; filename=employee_details.xml");
              break;
      }
      header("Content-Transfer-Encoding: binary");
      header("Expires: 0");
      header("Cache-Control: must-revalidate");
      header("Pragma: public");
      header("Content-Length: ".strlen($output));
      ob_clean();
      flush();
  }
  </code></pre>