Using PHP to Export Excel Sheet

[sh0wtym3]

Hey all,

 

I found the following code online which allows you to create and export an excel sheet using PHP:

      <?php

      $filename ="excelreport.xls";

      $contents = "testdata1 \t testdata2 \t testdata3 \t \n";

      header('Content-type: application/ms-excel');

      header('Content-Disposition: attachment; filename='.$filename);

      echo $contents;

      ?>

 

It works, however, there are certain problems that occur when I try to copy the cells from that php-generated excel sheet, to an excel sheet I have on my PC.

 

I have to copy the content in the cells to notepad, and then to an excel sheet on my pc for it to copy correctly.

 

I think this has to do with encoding the character set for the php generated excel sheet, but I'm not sure what to set it to or how to accomplish that - does anyone know how?

[trq]

You will likely have more success using a decent library such as http://phpexcel.codeplex.com

[sh0wtym3]

Thanks Thorpe, that seems to be exactly what I need

[phpnewbie2010]

Thanks a ton thorpe, http://phpexcel.codeplex.com did work fine

 

You will likely have more success using a decent library such as http://phpexcel.codeplex.com