PHPExcel用户：读取电子表格文件及操作指南.pdfVIP

Contents

PHPExcelUserDocumentation–ReadingSpreadsheetFi1

1.SpreadsheetFileFormats1

2.Security3

3.LoadingaSpreadsheetFile4

4.CreatingaReaderandLoadingaSpreadsheetFile5

5.SpreadsheetReaderOptions6

5.1.ReadingOnlyDatafromaSpreadsheetFile6

5.2.ReadingOnlyNamedWorkSheetsfromaFile7

5.3.ReadingOnlySpecificColumnsandRowsfromaFile(ReadFilters)8

5.4.CombiningMultipleFiintoaSinglePHPExcelObject11

5.5.CombiningReadFilterswiththesetSheetIndex()methodtosplitalargeCSVfileacross

multipleWorksheets12

5.6.PipeorTabSeparatedValueFi14

5.7.ABriefWordabouttheAdvancedValueBinder15

6.ErrorHandling16

7.HelperMethods17

内容

PHPExcel用户文档–电子表格文件.1

1.电子表格文件格式.1

2.安全性.3

3.加载电子表格文件.4

4.创建阅读器并加载电子表格文件.5

5.电子表格阅读器选项.6

5.1.只电子表格文件中的数据.6

5.2.仅从文件中命名工作表.7

5.3.仅文件中的特定列和行（过滤器）.8

5.4.将多个文件组合成单个PHPExcel对象.11

5.5.将过滤器与setSheetIndex()方法相结合，将大型CSV文件拆分到多个工作表中.12

5.6.管道符或制表符分隔值文件.14

5.7.关于AdvancedValueBinder的简要介绍.15

6.错误处理.16

7.辅助方法.17

1.SpreadsheetFileFormats

PHPExcelcanreadanumberofdifferentspreadsheetfileformats,althoughnotallfeaturesare

supportedbyallofthereaders.ChecktheFunctionalityCross-Referencedocument(Functionality

Cross-Reference.xls)foralistthatidentifieswhichfeaturesaresupportedbywhichreaders.

Currently,PHPExcelsupportsthefollowingFileTypesforReading:

Excel5

The