pear install OLE

pear install Spreadsheet_Excel_Writer-beta

PHP Code Example

 // Include PEAR::Spreadsheet_Excel_Writer

 require_once "Spreadsheet/Excel/Writer.php";

 

 // Create an instance, passing the filename to create

 $xls =& new Spreadsheet_Excel_Writer('sheets/binary.xls');

 

 // Add a worksheet to the file, returning an object to add data to

 $sheet =& $xls->addWorksheet('Binary Count');

 $sheet->setColumn(0,2,20); //Set column width of columns 0 thru 2 to 20

 // Write some data using write(Row#,Col#,Data)

   $sheet->write(0,0,"orange"); // Row 0, Column 0

   $sheet->write(1,0,"apple"); //Row 1, Column 0

   $sheet->write(2,0,"banana");

   $sheet->write(0,1,"orange"); //Row 0, Column 1

   $sheet->write(1,1,"orange"); //Row 1, Column 1

   $sheet->write(2,0,"yellow");

 

 

 // Finish the spreadsheet, dumping it to the browser

 $xls->close();