时间:2021-07-01 10:21:17 帮助过:30人阅读
- /*
- * PHPExcel.V1.7.6版本 [读取示例]
- */
- include 'PHPExcel/IOFactory.php';
- $filename = "d:/test.xls";
- $readType = PHPExcel_IOFactory::identify($filename); //在不知道文档类型的情况下获取
- $excelReader = PHPExcel_IOFactory::createReader($readType);
- $PHPExcelObj = $excelReader->load($filename);
- $currentSheet = $PHPExcelObj->getSheet(0); //选取第一张表单(Sheet1)为当前操作的表单
- $excelRows = $currentSheet->getHighestRow(); //获取最大行
- $excelColumn = $currentSheet->getHighestColumn(); //获取最大列
- foreach(range(1,$excelRows) as $row){
- $line = '<p>';
- foreach(range('A',$excelColumn) as $column){
- $line .= $currentSheet->getCell($column.$row)->getValue().",";
- }
- $line .= '</p>';
- echo $line;
- }
- <br><font color="#e78608">------解决方案--------------------</font><br>
- <fieldset><legend>探讨</legend><br>我在网上找了个例子,可以通过phpexcel将excel文件导入到数据库中,但是数据一旦超过122条,例如一个excel文件中有123条数据就无法导入。我讲代码贴出来,大家看看:<br>require_once '../phpExcelReader/Excel/reader.php';<br>$data = new Spreadsheet_Excel_Reader();<br>$data->setOutput……<br></fieldset>