php操作excel 导入导出 excel导入导出到mysql

************************************************************************************** * PHPExcel * * Copyright (c) 2006 - 2009 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 * * @copyright Copyright (c) 2006 - 2009 PHPExcel (http://www.codeplex.com/PHPExcel) * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL * @version 1.7.2, 2010-01-11 ************************************************************************************** Fixed in SVN: 2010/01/11 (v1.7.2): - General: (ET) Applied patch 4362 - General: (ET) Applied patch 4363 (modified) - General: (MBaker) Work item 10874 - 1.7.1 Extremely Slow - Refactored PHPExcel_Calculation_Functions::flattenArray() method and set calculation cache timer default to 2.5 seconds - General: (MBaker) Allow formulae to contain line breaks - General: (ET) Work item 10910 - split() function deprecated in PHP 5.3.0 - General: (ET) sys_get_temp_dir() requires PHP 5.2.1, not PHP 5.2 [provide fallback function for PHP 5.2.0] - General: (MBaker) Applied patch 4640 - Implementation of the ISPMT() Financial function by Matt Groves - General: (MBaker) Work item 11052 - Put the example of formula with more arguments in documentation - General: (MBaker) Improved accuracy for the GAMMAINV() Statistical Function - Feature: (ET) Work item 10409 - XFEXT record support to fix colors change from Excel5 reader, and copy/paste color change with Excel5 writer - Excel5 reader reads RGB color information in XFEXT records for borders, font color and fill color - Feature: (MBaker) Work Item 2346 - Implement more Excel calculation functions - Implemented the FVSCHEDULE(), XNPV(), IRR(), MIRR(), XIRR() and RATE() Financial functions - Implemented the SUMPRODUCT() Mathematical function - Implemented the ZTEST() Statistical Function - Feature: (ET) Work item 10919 - Multiple print areas in one sheet - Feature: (ET) Work item 10930 - Store calculated values in output by PHPExcel_Writer_Excel5 - Feature: (ET) Work item 10939 - Sheet protection options in Excel5 reader/writer - Feature: (MBaker) Modification of the COUNT(), AVERAGE(), AVERAGEA(), DEVSQ, AVEDEV(), STDEV(), STDEVA(), STDEVP(), STDEVPA(), VARA() and VARPA() SKEW() and KURT() functions to correctly handle boolean values depending on whether they're passed in as values, values within a matrix or values within a range of cells. - Feature: (ET) Work item 9932 - Cell range selection - Feature: (MB) Work item 10266 - Root-relative path handling - Feature: (ET) Work item 11315 - Named Ranges not working with PHPExcel_Writer_Excel5 - Bugfix: (MB) Work item 11206 - Excel2007 Reader fails to load Apache POI generated Excel - Bugfix: (MB) Work item 11154 - Number format is broken when system's thousands separator is empty - Bugfix: (MB) Work item 11401 - ReferenceHelper::updateNamedFormulas throws errors if oldName is empty - Bugfix: (MB) Work item 11296 - parse_url() fails to parse path to an image in xlsx - Bugfix: (ET) Work item 10876 - Workaround for iconv_substr() bug in PHP 5.2.0 - Bugfix: (ET) Work item 10877 - 1 pixel error for image width and height with PHPExcel_Writer_Excel5 - Bugfix: (MBaker) Fix to GEOMEAN() Statistical function - Bugfix: (ET) Work item 10884 - setValue('-') and setValue('.') sets numeric 0 instead of 1-character string - Bugfix: (ET) Work item 10885 - Row height sometimes much too low after read with PHPExcel_Reader_Excel5 - Bugfix: (ET) Work item 10888 - Diagonal border. Miscellaneous missing support. - Constant PHPExcel_Style_Borders::DIAGONAL_BOTH added to support double-diagonal (cross) - PHPExcel_Reader_Excel2007 not always reading diagonal borders (only recognizes 'true' and not '1') - PHPExcel_Reader_Excel5 support for diagonal borders - PHPExcel_Writer_Excel5 support for diagonal borders - Bugfix: (ET) Work item 10894 - Session bug: Fatal error: Call to a member function bindValue() on a non-object in ...\Classes\PHPExcel\Cell.php on line 217 - Bugfix: (ET) Work item 10896 - Colors messed up saving twice with same instance of PHPExcel_Writer_Excel5 (regression since 1.7.0) - Bugfix: (ET) Work item 10917 - Method PHPExcel_Worksheet::setDefaultStyle is not working - Bugfix: (ET) Work item 10897 - PHPExcel_Reader_CSV::canRead() sometimes says false when it shouldn't - Bugfix: (ET) Work item 10922 - Changes in workbook not picked up between two saves with PHPExcel_Writer_Excel2007 - Bugfix: (ET) Work item 10913 - Decimal and thousands separators missing in HTML and PDF output - Bugfix: (ET) Work item 10936 - Notices with PHPExcel_Reader_Excel5 and named array constants - Bugfix: (MBaker) Work item 10938 - Calculation engine limitation on 32-bit platform with integers > 2147483647 - Bugfix: (ET) Work item 10959 - Shared(?) formulae containing absolute cell references not read correctly using Excel5 Reader - Bugfix: (MBaker) Work item 10962 - Warning messages with intersection operator involving single cell - Bugfix: (ET) Work item 10980 - Infinite loop in Excel5 reader caused by zero-length string in SST - Bugfix: (ET) Work item 10983 - Remove unnecessary cell sorting to improve speed by approx. 18% in HTML and PDF writers - Bugfix: (MBaker) Work item 10977 - Cannot read A1 cell content - OO_Reader - Bugfix: (ET) Work item 11000 - Transliteration failed, invalid encoding 2009/11/02 (v1.7.1): - General: (ET) Work item 10687 - ereg() function deprecated in PHP 5.3.0 - General: (MB) Work item 10739 - Writer Interface Inconsequence - setTempDir and setUseDiskCaching - General: (ET) Upgrade to TCPDF 4.8.009 - Feature: (ET) Work item 7333 - Support for row and column styles (feature request) - Basic implementation for Excel2007/Excel5 reader/writer - Feature: (ET) Work item 10459 - Hyperlink to local file in Excel5 reader/writer - Feature: (MB) Work item 10472 - Color Tab (Color Sheet's name) - Feature: (ET) Work item 10488 - Border style "double" support in PHPExcel_Writer_HTML - Feature: (ET) Work item 10492 - Multi-section number format support in HTML/PDF/CSV writers - Feature: (MBaker) - Some additional performance tweaks in the calculation engine - Feature: (MBaker) - Fix result of DB() and DDB() Financial functions to 2dp when in Gnumeric Compatibility mode - Feature: (MBaker) - Added AMORDEGRC(), AMORLINC() and COUPNUM() Financial function (no validation of parameters yet) - Feature: (MBaker) - Improved accuracy of TBILLEQ(), TBILLPRICE() and TBILLYIELD() Financial functions when in Excel or Gnumeric mode - Feature: (MBaker) - Added INDIRECT() Lookup/Reference function (only supports full addresses at the moment) - Feature: (MB) Work item 10498 - PHPExcel_Reader_CSV::canRead() improvements - Feature: (ET) Work item 10500 - Input encoding option for PHPExcel_Reader_CSV - Feature: (ET) Work item 10493 - Colored number format support, e.g. [Red], in HTML/PDF output - Feature: (ET) Work item 10559 - Color Tab (Color Sheet's name) [Excel5 reader/writer support] - Feature: (MBaker) Initial version of SYLK (slk) and Excel 2003 XML Readers (Cell data and basic cell formatting) - Feature: (MBaker) Initial version of Open Office Calc (ods) Reader (Cell data