我在下面有一個陣列串列
Array
(
[0] => name
[1] => age
[2] => class
[3] => number
)
Array
(
[0] => jhon
[1] => 24
[2] => 1
[3] => 99
)
Array
(
[0] => ali
[1] => 25
[2] => 2
[3] => 100
)
Array
(
[0] => smith
[1] => 30
[2] => 10
[3] => 109
)
我正在嘗試從以下代碼中提取 xlsx 檔案的資訊并使用庫，但我想洗掉此檔案中的標題
我為此使用以下代碼
$file = $_FILES['excel']['tmp_name'];
$xlsx = SimpleXLSX::parse($file);
foreach( $xlsx->rows() as $r ) {
unset($r[0]);
print_r($r);
}
但是這個洗掉所有陣列的單元格0，我想洗掉下面的陣列
Array
(
[0] => name
[1] => age
[2] => class
[3] => number
)
uj5u.com熱心網友回復：
您可以通過檢查何時是第一行來做到這一點。
$file = $_FILES['excel']['tmp_name'];
$xlsx = SimpleXLSX::parse($file);
$foreach ($xls->rows() as $k => $r ) {
if ( $k === 0 ) {
$header_values = $r;
continue;
}
print_r($r);
}
在此處查看更長的示例 - https://github.com/shuchkin/simplexls/blob/master/examples/02-rows_with_header_values_as_keys.php
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/463413.html
標籤：php