<? /**  * Simple class to properly output CSV data to clients. PHP 5 has a built  * in method to do the same for writing to files (fputcsv()), but many times  * going right to the client is beneficial.  *  * @author Jon Gales  */ class CSV_Writer {     public $data = array();     public $deliminator;     /**      * Loads data and optionally a deliminator. Data is assumed to be an array      * of associative arrays.      *      * @param array $data      * @param string $deliminator      */     function __construct($data, $deliminator = ",")     {         if (!is_array($data))         {             throw new Exception('CSV_Writer only accepts data as arrays');         }         $this->data = $data;         $this->deliminator = $deliminator;     }     private function wrap_with_quotes($data)     {         $data = preg_replace('/"(.+)"/', '""$1""', $data);         return sprintf('"%s"', $data);     }     /**      * Echos the escaped CSV file with chosen delimeter      *      * @return void      */     public function output()     {         foreach ($this->data as $row)         {             $quoted_data = array_map(array('CSV_Writer', 'wrap_with_quotes'), $row);             echo sprintf("%s/n", implode($this->deliminator, $quoted_data));         }     }     /**      * Sets proper Content-Type header and attachment for the CSV outpu      *      * @param string $name      * @return void      */     public function headers($name)     {         header('Content-Type: application/csv');         header("Content-disposition: attachment; filename={$name}.csv");     } } /* //$data = array(array("one","two","three"), array(4,5,6)); $data[] = array("one","two","three"); $data[] = array(4,5,6); $csv = new CSV_Writer($data); $csv->headers('test'); $csv->output(); */

<?php require_once 'Spreadsheet/Writer.php'; $workbook = new Spreadsheet_Excel_Writer(); /* 生成 CSV $filename = date('YmdHis').'.csv'; $workbook->send($filename); // 发送 Excel 文件名供下载 */ // 生成 Excel $filename = date('YmdHis').'.xls'; $workbook->send($filename); // 发送 Excel 文件名供下载 $workbook->setVersion(8); $workbook->setBIFF8InputEncoding('UTF-8'); $worksheet =& $workbook->addWorksheet("Sheet-1"); $data[]= array('id','username','company','email','mob','daytime','intent'); $data[] = array(1,'老梁','**工作室','jb51.net','1363137966*',time(),'y'); $total_row = count($data); $total_col = count($data[0]); for ($row = 0; $row < $total_row; $row ++) {    for ($col = 0; $col < $total_col; $col ++) {   $worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-1 中写入数据    } } /* $worksheet =& $workbook->addWorksheet("Sheet-2"); $data[]= array('id','username','company','email','mob','daytime','intent'); $data[] = array(1,'老梁','**工作室','jb51.net','1363137966*',time(),'y'); $total_row = count($data); $total_col = count($data[0]); for ($row = 0; $row < $total_row; $row ++) {    for ($col = 0; $col < $total_col; $col ++) {   $worksheet->writeString($row, $col, $data[$row][$col]); // 在 sheet-2 中写入数据    } } */ $workbook->close(); // 完成下载 ?>

<? require "excel_class.php"; Read_Excel_File("Book1.xls",$return); for ($i=0;$i<count($return[Sheet1]);$i++) {     for ($j=0;$j<count($return[Sheet1][$i]);$j++)     {         echo $return[Sheet1][$i][$j]."|";     }     echo "<br>"; } ?>

<? require "excel_class.php"; Read_Excel_File("Book1.xls",$return); Create_Excel_File("ddd.xls",$return[Sheet1]); ?>