PHP导入导出Excel方法.docVIP

1：类Excel格式，这个其实不是传统意义上的Excel文件，只是因为Excel的兼容能力强，能够正确打开而已。修改这种文件后再保存，通常会提示你是否要转换成Excel文件。优点：简单。缺点：难以生成格式，如果用来导入需要自己分别编写相应的程序。2：Excel格式，与类Excel相对应，这种方法生成的文件更接近于真正的Excel格式。 如果导出中文时出现乱码，可以尝试将字符串转换成gb2312，例如下面就把$yourStr从utf-8转换成了gb2312:$yourStr = mb_convert_encoding(”gb2312″, “UTF-8″, $yourStr); 下面详细列举几种方法。一、PHP导出Excel PHP代码?php /** * PHPExcel * * Copyright (C) 2006 - 2007 PHPExcel * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA * * @category PHPExcel * @package PHPExcel * @copyright Copyright (c) 2006 - 2007 PHPExcel ) * @license LGPL * @version 1.5.0, 2007-10-23 */  /** Error reporting */ error_reporting(E_ALL);  /** Include path **/ set_include_path(get_include_path() . PATH_SEPARATOR . ‘../Classes/’);  /** PHPExcel */ include ‘PHPExcel.php’;  /** PHPExcel_Writer_Excel2007 */ include ‘PHPExcel/Writer/Excel2007.php’;  // Create new PHPExcel object echo date(’H:i:s’) . ” Create new PHPExcel object\n”; $objPHPExcel = new PHPExcel();  // Set properties echo date(’H:i:s’) . ” Set properties\n”; $objPHPExcel-getProperties()-setCreator(”Maarten Balliauw”); $objPHPExcel-getProperties()-setLastModifiedBy(”Maarten Balliauw”); $objPHPExcel-getProperties()-setTitle(”Office 20