剛剛開始使用 phpspreadsheet。我試圖弄清楚如何在上傳時跳過 Excel 文件中的標(biāo)題行。require '../vendor/autoload.php';if (pathinfo($_FILES['upexcel']['name'], PATHINFO_EXTENSION) == 'csv') { $reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();} else { $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();}$spreadsheet = $reader->load($_FILES['upexcel']['tmp_name']);$worksheet = $spreadsheet->getActiveSheet();$sql = "INSERT INTO `testCommission` (`One`, `two`, `three`, `four`, `five`, `six`, `seven`) VALUES (?, ?, ?, ?, ?, ?, ?)";foreach ($worksheet->getRowIterator() as $row) { // Fetch data $cellIterator = $row->getCellIterator(); $cellIterator->setIterateOnlyExistingCells(false); $data = []; foreach ($cellIterator as $cell) { $data[] = $cell->getValue(); }我可以用上面的腳本做什么來實現(xiàn)這個目標(biāo)？
2 回答
HUH函數(shù)
TA貢獻(xiàn)1836條經(jīng)驗 獲得超4個贊
您需要檢測，當(dāng)它是第一行時，像這樣的二進(jìn)制變量會有所幫助
<?php
require '../vendor/autoload.php';
if (pathinfo($_FILES['upexcel']['name'], PATHINFO_EXTENSION) == 'csv') {
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
} else {
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
}
$spreadsheet = $reader->load($_FILES['upexcel']['tmp_name']);
$worksheet = $spreadsheet->getActiveSheet();
$sql = "INSERT INTO `testCommission` (`One`, `two`, `three`, `four`, `five`, `six`, `seven`) VALUES (?, ?, ?, ?, ?, ?, ?)";
$isheader = 0;
foreach ($worksheet->getRowIterator() as $row) {
// Fetch data
if($isheader > 0) {
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(false);
$data = [];
foreach ($cellIterator as $cell) {
$data[] = $cell->getValue();
}
} else
{ $isheader = 1; }
}
?>
嗶嗶one
TA貢獻(xiàn)1854條經(jīng)驗 獲得超8個贊
使用過濾器類。
不要忘記自動加載：
require_once?(?'vendor/autoload.php'?);
創(chuàng)建過濾器：
class FirstRowFilter implements \PhpOffice\PhpSpreadsheet\Reader\IReadFilter
{
? ? public function readCell($column, $row, $worksheetName = '') {
? ? ? ? //? Return true for rows after first row
? ? ? ? return $row > 0;
? ? }
}
適用于讀者：
$reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xlsx");
$filterRow = new FirstRowFilter();
$reader->setReadFilter($filterRow);
加載文件：
$spreadsheet = $reader->load($file);
讀取器將僅加載指定行之后的行。
- 2 回答
- 0 關(guān)注
- 235 瀏覽
添加回答
舉報
0/150
提交
取消