php excel高级操作

************************************************************************************** * 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.6.7, 2009-04-22 ************************************************************************************** To be planned: 2009/04/22 (v1.6.7): - General: (MB) Work item 9416 - Deprecate misspelled setStriketrough() and getStriketrough() methods - General: (MB) Work item 9526 - Performance improvement when saving file - Feature: (MB) Work item 9598 - Check that sheet title has maximum 31 characters - Feature: (MB, ET) Work item 9631 - True support for Excel built-in number format codes - Feature: (ET) Work item 9683 - Ability to read defect BIFF5 Excel file without CODEPAGE record - Feature: (MB) Work item 9701 - Auto-detect which reader to invoke - Feature: (ET) Work item 9214 - Deprecate insertion of dates using PHP-time (Unix time) [request for removal of feature] - Feature: (ET) Work item 9747 - Support for entering time values like '9:45', '09:45' using AdvancedValueBinder - Feature: (ET) Work item 9797 - DataType dependent horizontal alignment in HTML and PDF writer - Bugfix: (MB) Work item 9375 - Cloning data validation object causes script to stop - Bugfix: (ET) Work item 9400 - Simultaneous repeating rows and repeating columns not working with PHPExcel_Writer_Excel5 - Bugfix: (MB) Work item 9399 - Simultaneous repeating rows and repeating columns not working with PHPExcel_Writer_Excel2007 - Bugfix: (ET) Work item 9437 - Row outline level not working with PHPExcel_Writer_Excel5 - Bugfix: (ET) Work item 9452 - Occasional notices with PHPExcel_Reader_Excel5 when Excel file contains drawing elements - Bugfix: (ET) Work item 9453 - PHPExcel_Reader_Excel5 fails as a whole when workbook contains images other than JPEG/PNG - Bugfix: (ET) Work item 9444 - Excel5 writer checks for iconv but does not necessarily use it - Bugfix: (ET) Work item 9463 - Altering a style on copied worksheet alters also the original - Bugfix: (MB) Work item 9480 - Formulas are incorrectly updated when a sheet is renamed - Bugfix: (MB) Work item 9513 - PHPExcel_Worksheet::extractSheetTitle not treating single quotes correctly - Bugfix: (MB) Work item 9477 - PHP Warning raised in function array_key_exists - Bugfix: (MB) Work item 9599 - getAlignWithMargins() gives wrong value when using PHPExcel_Reader_Excel2007 - Bugfix: (MB) Work item 9600 - getScaleWithDocument() gives wrong value when using PHPExcel_Reader_Excel2007 - Bugfix: (MB) Work item 9630 - PHPExcel_Reader_Excel2007 not reading the first user-defined number format - Bugfix: (MB) Work item 9647 - Print area converted to uppercase after read with PHPExcel_Reader_Excel2007 - Bugfix: (MB) Work item 9661 - Incorrect reading of scope for named range using PHPExcel_Reader_Excel2007 - Bugfix: (MB) Work item 9690 - Error with pattern (getFillType) and rbg (getRGB) - Bugfix: (ET) Work item 9712 - AdvancedValueBinder affected by system timezone setting when inserting date values - Bugfix: (ET) Work item 9743 - PHPExcel_Reader_Excel2007 not reading value of active sheet index - Bugfix: (ET) Work item 9742 - getARGB() sometimes returns SimpleXMLElement object instead of string with PHPExcel_Reader_Excel2007 - Bugfix: (ET) Work item 9731 - Negative image offset causes defects in 14excel5.xls and 20readexcel5.xlsx - Bugfix: (ET) Work item 9758 - HTML & PDF Writer not working with mergeCells (regression since 1.6.5) - Bugfix: (ET) Work item 9774 - Too wide columns with HTML and PDF writer - Bugfix: (MB) Work item 9775 - PDF and cyrillic fonts - Bugfix: (ET) Work item 9793 - Percentages not working correctly with HTML and PDF writers (shows 0.25% instead of 25%) - Bugfix: (ET) Work item 9791 - PHPExcel_Writer_HTML creates extra borders around cell contents using setUseInlineCss(true) - Bugfix: (ET) Work item 9784 - Problem with text wrap + merged cells in HTML and PDF writer - Bugfix: (ET) Work item 9814 - Adjacent path separators in include_path causing IOFactory to violate open_basedir restriction -------------------------------------------------------------------------------- BREAKING CHANGE! In previous versions of PHPExcel up to and including 1.6.6, when a cell had a date-like number format code, it was possible to enter a date directly using an integer PHP-time without converting to Excel date format. Starting with PHPExcel 1.6.7 this is no longer supported. Refer to the developer documentation for more information on entering dates into a cell. -------------------------------------------------------------------------------- 2009/03/02 (v1.6.6): - General: (MB) Work item 9102 - Improve support for built-in number formats in PHPExcel_Reader_Excel2007 - General: (ET) Work item 9281 - Source files are in both UNIX and DOS formats - changed to UNIX - General: (MB) Work item 9338 - Update documentation: Which language to write formulas in? - Feature: (ET) Work item 8817 - Ignore DEFCOLWIDTH records with value 8 in PHPExcel_Reader_Excel5 - Feature: (ET) Work item 8847 - Support for width, height, offsetX, offsetY for images in PHPExcel_Reader_Excel5 - Feature: (MB) Work item 8870 - Disk Caching in specific folder - Feature: (MBaker) Work item 2346 - Added SUMX2MY2, SUMX2PY2, SUMXMY2, MDETERM and MINVERSE Mathematical and Trigonometric Functions - Feature: (MBaker) Work item 2346 - Added CONVERT Engineering Function - Feature: (MBaker) Work item 2346 - Added DB, DDB, DISC, DOLLARDE, DOLLARFR, INTRATE, IPMT, PPMT, PRICEDISC, PRICEMAT and RECEIVED Financial Functions - Feature: (MBaker) Work item 2346 - Added ACCRINTM, CUMIPMT, CUMPRINC, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELDDISC and YIELDMAT Financial Functions - Feature: (MBaker) Work item 2346 - Added DOLLAR Text Function - Feature: (MBaker) Work item 2346 - Added CORREL, COVAR, FORECAST, INTERCEPT, RSQ, SLOPE and STEYX Statistical Functions - Feature: (MBaker) Work item 2346 - Added PEARSON Statistical Functions as a synonym for CORREL - Feature: (MBaker) Work item 2346 - Added LINEST, LOGEST (currently only valid for stats = false), TREND and GROWTH Statistical Functions - Feature: (MBaker) Work item 2346 - Added RANK and PERCENTRANK Statistical Functions - Feature: (MBaker) Work item 2346 - Added ROMAN Mathematical Function (Classic form only) - Feature: (MB) Work item 8931 - Update documentation to show example of getCellByColumnAndRow($col, $row) - Feature: (MB) Work item 8770 - Implement worksheet, row and cell iterators - Feature: (MB) Work item 9001 - Support for arbitrary defined names (named range) - Feature: (MB, ET) Work item 9016 - Update formulas when sheet title / named range title changes - Feature: (MB) Work item 9103 - Ability to read cached calculated value - Feature: (MBaker, ET) Work item 8483 - Support for Excel 1904 calendar date mode (Mac) - Feature: (ET) Work item 9194 - PHPExcel_Writer_Excel5 improvements writing shared strings table - Feature: (ET) Work item 9248 - PHPExcel_Writer_Excel5 iconv fallback when mbstring extension is not enabled