Format cells of excel file

[dheeraja]

Hi Guys,

I am looking for a way to format excel cells using PHP, I am exporting mysql data to excel file using below method:

 

$fields = array("Date", "Time In", "Time Out", "Hours", "Project", "Component", "Sub-Component", "Work Done", "Supervisor Changes", PHP_EOL);
file_put_contents($filename, implode("\t", $fields), FILE_APPEND);

 

Now I want to make BOLD all this header fields, so please help me to this construct..

 

Thank you

[taquitosensei]

You can't. Not with the way you're doing it. You're creating a text file that excel happens to be able to open. You'd have to create an excel compatible file to be able to do formatting. I used pears spreadsheet writer http://pear.php.net/package/Spreadsheet_Excel_Writer  /but it only creates files compatible up to excel 2003. If you need to auto sort and other features from later than 2003 there's phpexcel http://phpexcel.codeplex.com/