<?php
$file="D:/Users/meco/Desktop/tmp/t/x.xlsx";
// 设置ODBC连接字符串
$dsn = "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=$file";
// 连接到XLSX文件
$conn = odbc_connect($dsn, '', '');
// 检查连接是否成功
if (!$conn) {
die("连接失败: " . iconv( "GBK","UTF-8", odbc_errormsg()));
}
// 执行查询
$sql = "SELECT * FROM [Sheet1$]";
$result = odbc_exec($conn, $sql);
// 读取数据
while ($row = odbc_fetch_array($result)) {
print_r($row);
}
// 关闭连接
odbc_close($conn);
