Html中使用M$控件系列之OWC-數(shù)據(jù)透視表篇
發(fā)表時(shí)間:2024-05-30 來(lái)源:明輝站整理相關(guān)軟件相關(guān)文章人氣:
[摘要]<form name="form1" id="form1"> <input name=strFile id=strFile type=file>數(shù)據(jù)表名:<input name=strTName strTName type=te...
<form name="form1" id="form1">
<input name=strFile id=strFile type=file>數(shù)據(jù)表名:<input name=strTName strTName type=text><input type=button name="btnRead" id="btnRead" value="Read Data" onclick="VBSCRIPT:ReadData()">
</form>
<br>
<object id="PivotTable1" classid="CLSID:0002E520-0000-0000-C000-000000000046">
</object>
<script language="VBScript">
<!--
Sub ReadData()
strPath = document.form1.strFile.value
strName = document.form1.strTName.value
PivotTable1.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & _
"data source=" & strPath
'數(shù)據(jù)表名
PivotTable1.DataMember = strName
'展開(kāi)
PivotTable1.ActiveView.AutoLayout
End Sub
-->
</script>