文件名称:PHP 读取Excel文件库
介绍说明--下载内容均来自于网络,请自行研究使用
调用示例:
require_once(dirname(__FILE__) . '/includes/PHPExcel/PHPExcel/IOFactory.php');
//$book = "xxxx.xls";这个是要读取的Excel文件名
$objPHPExcel = PHPExcel_IOFactory::load($book);
$Columns = $objPHPExcel->getActiveSheet()->getHighestColumn();
$Rows = $objPHPExcel->getActiveSheet()->getHighestRow();
for ($row = 1; $row getActiveSheet()->getCell("B".$row)->getValue();
}
require_once(dirname(__FILE__) . '/includes/PHPExcel/PHPExcel/IOFactory.php');
//$book = "xxxx.xls";这个是要读取的Excel文件名
$objPHPExcel = PHPExcel_IOFactory::load($book);
$Columns = $objPHPExcel->getActiveSheet()->getHighestColumn();
$Rows = $objPHPExcel->getActiveSheet()->getHighestRow();
for ($row = 1; $row getActiveSheet()->getCell("B".$row)->getValue();
}
(系统自动生成,下载前可以参看下载内容)
下载文件列表
压缩包 : PHPExcel.rar 列表 PHPExcel\Calculation\Exception.php PHPExcel\Calculation\ExceptionHandler.php PHPExcel\Calculation\FormulaParser.php PHPExcel\Calculation\FormulaToken.php PHPExcel\Calculation\Function.php PHPExcel\Calculation\functionlist.txt PHPExcel\Calculation\Functions.php PHPExcel\Calculation.php PHPExcel\Cell\AdvancedValueBinder.php PHPExcel\Cell\DataType.php PHPExcel\Cell\DataValidation.php PHPExcel\Cell\DefaultValueBinder.php PHPExcel\Cell\Hyperlink.php PHPExcel\Cell\IValueBinder.php PHPExcel\Cell.php PHPExcel\Comment.php PHPExcel\DocumentProperties.php PHPExcel\DocumentSecurity.php PHPExcel\HashTable.php PHPExcel\IComparable.php PHPExcel\IOFactory.php PHPExcel\NamedRange.php PHPExcel\Reader\CSV.php PHPExcel\Reader\DefaultReadFilter.php PHPExcel\Reader\Excel2003XML.php PHPExcel\Reader\Excel2007.php PHPExcel\Reader\Excel5\Escher.php PHPExcel\Reader\Excel5.php PHPExcel\Reader\IReader.php PHPExcel\Reader\IReadFilter.php PHPExcel\Reader\OOCalc.php PHPExcel\Reader\Serialized.php PHPExcel\Reader\SYLK.php PHPExcel\ReferenceHelper.php PHPExcel\RichText\ITextElement.php PHPExcel\RichText\Run.php PHPExcel\RichText\TextElement.php PHPExcel\RichText.php PHPExcel\Shared\Date.php PHPExcel\Shared\Drawing.php PHPExcel\Shared\Escher\DgContainer\SpgrContainer\SpContainer.php PHPExcel\Shared\Escher\DgContainer\SpgrContainer.php PHPExcel\Shared\Escher\DgContainer.php PHPExcel\Shared\Escher\DggContainer\BstoreContainer\BSE\Blip.php PHPExcel\Shared\Escher\DggContainer\BstoreContainer\BSE.php PHPExcel\Shared\Escher\DggContainer\BstoreContainer.php PHPExcel\Shared\Escher\DggContainer.php PHPExcel\Shared\Escher.php PHPExcel\Shared\Excel5.php PHPExcel\Shared\File.php PHPExcel\Shared\Font.php PHPExcel\Shared\JAMA\CHANGELOG.TXT PHPExcel\Shared\JAMA\CholeskyDecomposition.php PHPExcel\Shared\JAMA\docs\docs.php PHPExcel\Shared\JAMA\docs\download.php PHPExcel\Shared\JAMA\docs\example.php PHPExcel\Shared\JAMA\docs\includes\credits.php PHPExcel\Shared\JAMA\docs\includes\footer.php PHPExcel\Shared\JAMA\docs\includes\header.php PHPExcel\Shared\JAMA\docs\includes\navbar.php PHPExcel\Shared\JAMA\docs\index.php PHPExcel\Shared\JAMA\docs\package.php PHPExcel\Shared\JAMA\docs\test.php PHPExcel\Shared\JAMA\EigenvalueDecomposition.php PHPExcel\Shared\JAMA\examples\benchmark.php PHPExcel\Shared\JAMA\examples\LagrangeInterpolation.php PHPExcel\Shared\JAMA\examples\LagrangeInterpolation2.php PHPExcel\Shared\JAMA\examples\LevenbergMarquardt.php PHPExcel\Shared\JAMA\examples\LMQuadTest.php PHPExcel\Shared\JAMA\examples\MagicSquareExample.php PHPExcel\Shared\JAMA\examples\polyfit.php PHPExcel\Shared\JAMA\examples\Stats.php PHPExcel\Shared\JAMA\examples\tile.php PHPExcel\Shared\JAMA\LUDecomposition.php PHPExcel\Shared\JAMA\Matrix.php PHPExcel\Shared\JAMA\QRDecomposition.php PHPExcel\Shared\JAMA\SingularValueDecomposition.php PHPExcel\Shared\JAMA\tests\TestMatrix.php PHPExcel\Shared\JAMA\utils\Error.php PHPExcel\Shared\JAMA\utils\Maths.php PHPExcel\Shared\OLE\ChainedBlockStream.php PHPExcel\Shared\OLE\OLE_File.php PHPExcel\Shared\OLE\OLE_PPS.php PHPExcel\Shared\OLE\OLE_Root.php PHPExcel\Shared\OLE.php PHPExcel\Shared\OLERead.php PHPExcel\Shared\PasswordHasher.php PHPExcel\Shared\PDF\2dbarcodes.php PHPExcel\Shared\PDF\barcodes.php PHPExcel\Shared\PDF\cache\chapter_demo_1.txt PHPExcel\Shared\PDF\cache\chapter_demo_2.txt PHPExcel\Shared\PDF\cache\table_data_demo.txt PHPExcel\Shared\PDF\cache\utf8test.txt PHPExcel\Shared\PDF\CHANGELOG.TXT PHPExcel\Shared\PDF\config\lang\eng.php PHPExcel\Shared\PDF\config\lang\ita.php PHPExcel\Shared\PDF\config\tcpdf_config.php PHPExcel\Shared\PDF\config\tcpdf_config_alt.php PHPExcel\Shared\PDF\fonts\arialunicid0-chinese-simplified.php PHPExcel\Shared\PDF\fonts\arialunicid0-chinese-traditional.php PHPExcel\Shared\PDF\fonts\arialunicid0-japanese.php PHPExcel\Shared\PDF\fonts\arialunicid0-korean.php PHPExcel\Shared\PDF\fonts\arialunicid0.php PHPExcel\Shared\PDF\fonts\courier.php PHPExcel\Shared\PDF\fonts\freefont-20090104\AUTHORS PHPExcel\Shared\PDF\fonts\freefont-20090104\ChangeLog PHPExcel\Shared\PDF\fonts\freefont-20090104\COPYING PHPExcel\Shared\PDF\fonts\freefont-20090104\CREDITS PHPExcel\Shared\PDF\fonts\freefont-20090104\INSTALL PHPExcel\Shared\PDF\fonts\freefont-20090104\README PHPExcel\Shared\PDF\fonts\freesans.ctg.z PHPExcel\Shared\PDF\fonts\freesans.php PHPExcel\Shared\PDF\fonts\freesans.z PHPExcel\Shared\PDF\fonts\freesansb.ctg.z PHPExcel\Shared\PDF\fonts\freesansb.php PHPExcel\Shared\PDF\fonts\freesansb.z PHPExcel\Shared\PDF\fonts\freesansbi.ctg.z PHPExcel\Shared\PDF\fonts\freesansbi.php PHPExcel\Shared\PDF\fonts\freesansbi.z PHPExcel\Shared\PDF\fonts\freesansi.ctg.z PHPExcel\Shared\PDF\fonts\freesansi.php PHPExcel\Shared\PDF\fonts\freesansi.z PHPExcel\Shared\PDF\fonts\helvetica.php PHPExcel\Shared\PDF\fonts\helveticab.php PHPExcel\Shared\PDF\fonts\helveticabi.php PHPExcel\Shared\PDF\fonts\helveticai.php PHPExcel\Shared\PDF\fonts\README.TXT PHPExcel\Shared\PDF\fonts\uni2cid_ac15.php PHPExcel\Shared\PDF\fonts\uni2cid_ag15.php PHPExcel\Shared\PDF\fonts\uni2cid_aj16.php PHPExcel\Shared\PDF\fonts\uni2cid_ak12.php PHPExcel\Shared\PDF\htmlcolors.php PHPExcel\Shared\PDF\images\_blank.png PHPExcel\Shared\PDF\LICENSE.TXT PHPExcel\Shared\PDF\README.TXT PHPExcel\Shared\PDF\tcpdf.crt PHPExcel\Shared\PDF\tcpdf.fdf PHPExcel\Shared\PDF\tcpdf.php PHPExcel\Shared\PDF\unicode_data.php PHPExcel\Shared\PDF.php PHPExcel\Shared\String.php PHPExcel\Shared\trend\bestFitClass.php PHPExcel\Shared\trend\exponentialBestFitClass.php PHPExcel\Shared\trend\linearBestFitClass.php PHPExcel\Shared\trend\logarithmicBestFitClass.php PHPExcel\Shared\trend\polynomialBestFitClass.php PHPExcel\Shared\trend\powerBestFitClass.php PHPExcel\Shared\trend\trendClass.php PHPExcel\Shared\XMLWriter.php PHPExcel\Shared\ZipStreamWrapper.php PHPExcel\Style\Alignment.php PHPExcel\Style\Border.php PHPExcel\Style\Borders.php PHPExcel\Style\Color.php PHPExcel\Style\Conditional.php PHPExcel\Style\Fill.php PHPExcel\Style\Font.php PHPExcel\Style\NumberFormat.php PHPExcel\Style\Protection.php PHPExcel\Style.php PHPExcel\Worksheet\BaseDrawing.php PHPExcel\Worksheet\CellIterator.php PHPExcel\Worksheet\ColumnDimension.php PHPExcel\Worksheet\Drawing\Shadow.php PHPExcel\Worksheet\Drawing.php PHPExcel\Worksheet\HeaderFooter.php PHPExcel\Worksheet\HeaderFooterDrawing.php PHPExcel\Worksheet\MemoryDrawing.php PHPExcel\Worksheet\PageMargins.php PHPExcel\Worksheet\PageSetup.php PHPExcel\Worksheet\Protection.php PHPExcel\Worksheet\Row.php PHPExcel\Worksheet\RowDimension.php PHPExcel\Worksheet\RowIterator.php PHPExcel\Worksheet\SheetView.php PHPExcel\Worksheet.php PHPExcel\WorksheetIterator.php PHPExcel\Writer\CSV.php PHPExcel\Writer\Excel2007\Comments.php PHPExcel\Writer\Excel2007\ContentTypes.php PHPExcel\Writer\Excel2007\DocProps.php PHPExcel\Writer\Excel2007\Drawing.php PHPExcel\Writer\Excel2007\Rels.php PHPExcel\Writer\Excel2007\StringTable.php PHPExcel\Writer\Excel2007\Style.php PHPExcel\Writer\Excel2007\Theme.php PHPExcel\Writer\Excel2007\Workbook.php PHPExcel\Writer\Excel2007\Worksheet.php PHPExcel\Writer\Excel2007\WriterPart.php PHPExcel\Writer\Excel2007.php PHPExcel\Writer\Excel5\BIFFwriter.php PHPExcel\Writer\Excel5\Escher.php PHPExcel\Writer\Excel5\Font.php PHPExcel\Writer\Excel5\Parser.php PHPExcel\Writer\Excel5\Workbook.php PHPExcel\Writer\Excel5\Worksheet.php PHPExcel\Writer\Excel5\Xf.php PHPExcel\Writer\Excel5.php PHPExcel\Writer\HTML.php PHPExcel\Writer\IWriter.php PHPExcel\Writer\PDF.php PHPExcel\Writer\Serialized.php PHPExcel.php PHPExcel\Shared\Escher\DggContainer\BstoreContainer\BSE PHPExcel\Shared\Escher\DgContainer\SpgrContainer PHPExcel\Shared\Escher\DggContainer\BstoreContainer PHPExcel\Shared\JAMA\docs\includes PHPExcel\Shared\PDF\config\lang PHPExcel\Shared\PDF\fonts\freefont-20090104 PHPExcel\Shared\Escher\DgContainer PHPExcel\Shared\Escher\DggContainer PHPExcel\Shared\JAMA\docs PHPExcel\Shared\JAMA\examples PHPExcel\Shared\JAMA\tests PHPExcel\Shared\JAMA\utils PHPExcel\Shared\PDF\cache PHPExcel\Shared\PDF\config PHPExcel\Shared\PDF\fonts PHPExcel\Shared\PDF\images PHPExcel\Reader\Excel5 PHPExcel\Shared\Escher PHPExcel\Shared\JAMA PHPExcel\Shared\OLE PHPExcel\Shared\PDF PHPExcel\Shared\trend PHPExcel\Worksheet\Drawing PHPExcel\Writer\Excel2007 PHPExcel\Writer\Excel5 PHPExcel\Calculation PHPExcel\Cell PHPExcel\Reader PHPExcel\RichText PHPExcel\Shared PHPExcel\Style PHPExcel\Worksheet PHPExcel\Writer PHPExcel