Question

因此,我得以在外壳表上显示其数据,但这种数据可插入我的表格。我看不出这个部分,这里是我迄今所看到的:

    $path = $_GET[ file ];
include("../class/sql.php");
require  ../class/PHPExcel.php ;
require_once  ../class/PHPExcel/IOFactory.php ;
$objPHPExcel = PHPExcel_IOFactory::load($path);
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
    $worksheetTitle     = $worksheet->getTitle();
    $highestRow         = $worksheet->getHighestRow(); // e.g. 10
    $highestColumn      = $worksheet->getHighestColumn(); // e.g  F 
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    $nrColumns = ord($highestColumn) - 64;
    echo  <br>Data: <table width="100%" cellpadding="3" cellspacing="0"><tr> ;
    for ($row = 1; $row <= $highestRow; ++ $row) {

        echo  <tr> ;
        for ($col = 0; $col < $highestColumnIndex; ++ $col) {
            $cell = $worksheet->getCellByColumnAndRow($col, $row);
            $val = $cell->getValue();
            if($row === 1)
            echo  <td style="background:#000; color:#fff;">  . $val .  </td> ;
            else
                echo  <td>  . $val .  </td> ;
        }
        echo  </tr> ;
    }
    echo  </table> ;
}

b 以前的PHPExcel是一件很麻烦的事,我没有时间通过它来读,以充分理解: 我不得不在午宴上这样做。预收

Edit:这是它应该做的思想,价值观部分是我所不知的。

$sql = "insert into tablename (col1, col2, col3) values(...)";
//start at row 2 so headers are not inserted
for ($row = 2; $row <= $highestRow; ++ $row) {

    for ($col = 0; $col < $highestColumnIndex; ++ $col) {
        $cell = $worksheet->getCellByColumnAndRow($col, $row);
        $val = $cell->getValue();
        //here s my prob..
        echo $val;
    }
    $result = mysql_query($sql);
}

Answer 1

您应创建一个阵列,并将其储存在数据库中,例如:

for ($row = 2; $row <= $highestRow; ++ $row) {
$val=array()
for ($col = 0; $col < $highestColumnIndex; ++ $col) {
    $cell = $worksheet->getCellByColumnAndRow($col, $row);
    $val[] = $cell->getValue();
    //here s my prob..
    //echo $val;
}

$sql="insert into tablename (col1, col2, col3) values(`".$val[0]."`, `".$val[1]."`, `".$val[2].")";
$result = mysql_query($sql);


}

Answer 2

如果你想要利用PHPExcel来做到这一点:

<?php
//include the following 2 files
require  Classes/PHPExcel.php ;
require_once  Classes/PHPExcel/IOFactory.php ;

$SERVER =  localhost ;
$USERNAME =  username ;
$PASSWORD =   password ;
$DB =  database ;
$DSN = "mysql:host=".$SERVER.";dbname=".$DB."";
$connection = new PDO($DSN,$USERNAME,$PASSWORD);

$path = "test.xlsx";

$objPHPExcel = PHPExcel_IOFactory::load($path);
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
    $worksheetTitle     = $worksheet->getTitle();
    $highestRow         = $worksheet->getHighestRow(); // e.g. 10
    $highestColumn      = $worksheet->getHighestColumn(); // e.g  F 
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    $nrColumns = ord($highestColumn) - 64;
    echo "<br>The worksheet ".$worksheetTitle." has ";
    echo $nrColumns .   columns (A-  . $highestColumn .  )  ;
    echo   and   . $highestRow .   row. ;
    echo  <br>Data: <table border="1"><tr> ;
    for ($row = 1; $row <= $highestRow; ++ $row) {
        echo  <tr> ;
        for ($col = 0; $col < $highestColumnIndex; ++ $col) {
            $cell = $worksheet->getCellByColumnAndRow($col, $row);
            $val = $cell->getValue();
            $dataType = PHPExcel_Cell_DataType::dataTypeForValue($val);
            echo  <td>  . $val .  <br>(Typ   . $dataType .  )</td> ;
        }
        echo  </tr> ;
    }
    echo  </table> ;
}

for ($row = 2; $row <= $highestRow; ++ $row) {
    $val=array();
for ($col = 0; $col < $highestColumnIndex; ++ $col) {
   $cell = $worksheet->getCellByColumnAndRow($col, $row);
   $val[] = $cell->getValue();
}

 $Connection="INSERT INTO `users` (name, family, type) VALUES ( ".$val[1] . " , " . $val[2] . " , " . $val[3]. " )";

}
?>

Answer 3

这是一种使用早期图书馆面读书的良好文章。

http://major.io/2008/11/07/importing-excel-files-into-mysql-with-php/

检查

友情链接