how to convert php output design into excel?

[Exequiel]

hello friends, how can i convert into excel file those output data came from my php and sql queries that has a fixed design using css? I'm done converting it into pdf, my only problem is that i want to have a copy of those data into excel.

Any comments are appreciated. Godbless. :)

[Dormilich]

you can try to import the generated HTML file into Excel. however, bear in mind that those two (HTML and Excel) have totally different contexts. HTML is for displaying structured data (much like an image) while Excel is a spreadsheet application.

[Exequiel]

so far this are my code example on how to convert php data into excel. its working, it can convert now into excel. the only problem now is that how can i add styles to those data i have ? how to put bold to text? how to add background colors to headers? how to make text align centered?

<?php
  $data = array(
    array("2-Jul" => "'06/07", "2C62 TT" => "=SUM(C3:D3)", "W" => 898, "Q" => 25, "∑W" => 25, "Ǭ" => 25, "2D43 TT" => 25, "W" => 25, "KFQ" => 3434, "FCAO" => 3434, "R-FCAO" => "=SUM(E3:F3)"),
    array("2-Jul" => "'07/08", "2C62 TT" => "=SUM(C4:D4)", "W" => 444, "Q" => 890, "∑W" => 12, "Ǭ" => 678, "2D43 TT" => 3434, "W" => 676, "KFQ" => 3434, "FCAO" => 3434, "R-FCAO" => "=SUM(E4:F4)")
  );
 
  function filter_data(&$str)
  {
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  }
 
  // file name after download
  $filename = "08 ~ 07 OF A DAY BEFORE YESTERDAY.xls";
 
  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");
 
  $ok = false;
  echo "08 ~ 07 OF A DAY BEFORE YESTERDAY\n";
  foreach($data as $row) 
  {
    if(!$ok) 
    {
      // display field/column names as first row
      echo implode("\t", array_keys($row)) . "\n";
      $ok = true;
    }
    array_walk($row, 'filter_data');
    echo implode("\t", array_values($row)) . "\n";
  }
 
  exit;
?>

by the way, thank you very much to the guidance @Dormilich. :)

[Exequiel]

I made it already, I'm finished, , I used table tag in html to put styles, :) I made it, and i'm done. :D