js 调用winAPI html5 没这功能
具体能容自己修改
<html xmlns="<meta charset="UTF-8">
<head>
<title>Untitled Page</title>
</head>
<script language="javascript" type="text/javascript">
function importXLS(fileName)
{
objCon = new ActiveXObject("ADODB.Connection")
objCon.Provider = "Microsoft.Jet.OLEDB.4.0"
objCon.ConnectionString = "Data Source=" + fileName + "Extended Properties=Excel 8.0"
objCon.CursorLocation = 1
objCon.Open
var strQuery
//Get the SheetName
var strSheetName = "Sheet1$"
var rsTemp = new ActiveXObject("ADODB.Recordset")
rsTemp = objCon.OpenSchema(20)
if(!rsTemp.EOF)
strSheetName = rsTemp.Fields("Table_Name").Value
rsTemp = null
rsExcel = new ActiveXObject("ADODB.Recordset")
strQuery = "SELECT * FROM [" + strSheetName + "]"
rsExcel.ActiveConnection = objCon
rsExcel.Open(strQuery)
while(!rsExcel.EOF)
{
for(i = 0i<rsExcel.Fields.Count++i)
{
alert(rsExcel.Fields(i).value)
}
rsExcel.MoveNext
}
// Close the connection and dispose the file
objCon.Close
objCon =null
rsExcel = null
}
</script>
</head>
<body>
<input type="file" id="f" />
<input type="button" id="b" value="import" onclick="if(f.value=='')alert('请选择xls文件')else importXLS(f.value)" />
</body>
</html>
在IE中使用
你在表二中的c1单元格定义函数公式=vlookup(a1,sheet1!a:c,3,0),回车确认后往下拖就是了。不过这样只是满足了a列的条件没考虑到b列,这样会有误。可以用vba很好地实现你说的要求,要进一步帮助请私信联系。欢迎分享,转载请注明来源:内存溢出
评论列表(0条)