php到xls不一样像php输出和xls输出（不同）

Question

I'm confused about this script php converter:

  <?php header("Cache-Control: no-cache, no-store, must-revalidate");  
header("Content-Type: application/vnd.ms-excel");  
header("Content-Disposition: attachment; filename=test.xls");  ?>

and after convert to test.xls

I wanna make like this, with color and same like output export.php

with color ,border ,and right placement.

Answer 1

can you please used this library which help you set all thing which you want:

phpexcel

Feature List

also take reference of this Stack overflow