如何使用phpexcel读取数据并将其插入数据库? [英] How to use phpexcel to read data and insert into database?
本文介绍了如何使用phpexcel读取数据并将其插入数据库?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个php
应用程序,我想从其中读取excel的数据,将其插入数据库,然后为特定用户生成pdf报告.
我进行了很多搜索,但没有给出关于这两个方面的具体说明.
I have a php
application where I want to read data from excel, Insert into database and then generate pdf reports for specific users.
I searched a lot but nothing specific given about both things.
推荐答案
使用PHPExcel库读取Excel文件并将数据传输到数据库中
Using the PHPExcel library to read an Excel file and transfer the data into a database
// Include PHPExcel_IOFactory
include 'PHPExcel/IOFactory.php';
$inputFileName = './sampleData/example1.xls';
// Read your Excel workbook
try {
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch(Exception $e) {
die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
}
// Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
// Loop through each row of the worksheet in turn
for ($row = 1; $row <= $highestRow; $row++){
// Read a row of data into an array
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row,
NULL,
TRUE,
FALSE);
// Insert row data array into your database of choice here
}
任何事情都变得非常取决于您的数据库以及如何在其中构造数据
Anything more becomes very dependent on your database, and how you want the data structured in it
这篇关于如何使用phpexcel读取数据并将其插入数据库?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文