文件名称: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
本网站为编程资源及源代码搜集、介绍的搜索网站,版权归原作者所有! 粤ICP备11031372号
1999-2046 搜珍网 All Rights Reserved.