<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title> New Document </title>
<script language="JavaScript">
<!--
var excelFileName = "D:\\UserData.xls"; var oWB;
function showExcel()
{
//objID為表格ID
//需要在浏覽器安全級别設定中啟用ActiveX
// Start Excel and get Application object.
var oXL=null;
try{
oXL = new ActiveXObject("Excel.Application");
}catch(e)
{
alert(e.message); return ;
}
if (oXL == null){
alert("建立Excel檔案失敗，可能是您的計算機上沒有正确安裝Microsoft Office Excel軟體或浏覽器的安全級别設定過高！");
return;
}
try {
// Get a new workbook.
oWB = oXL.Workbooks.Open(excelFileName);
for (i = 1; i <= oWB.Sheets.Count; i++) {
if (oWB.Sheets(i).name.lastIndexOf("使用者資訊") != -1){
showSheet(i);
}
}
} catch (e){
alert(e.message);
} oWB.Close();
//不close工作簿的話，後果還是挺嚴重的。
oWB = null;
oXL = null;
function showSheet(sheetNO){
var oSheet = oWB.Sheets(sheetNO);
document.write("<table border='1px'>");
for (i = 1; i <= oSheet.UsedRange.Rows.Count; i++)
{
document.write("<tr>");
for (j = 1; j <= oSheet.UsedRange.Columns.Count; j++){
value = oSheet.Cells(i, j).value;
if (value == "undefined"){
value = " "; }
document.write(i == 1 ? "<th nowrap=true><b>" : "<td>");
document.write(value);
document.write(i == 1 ? "</b></th>" : "</td>");
document.write("</tr>"); }
document.write("</table>");
oSheet = null;
}
</script>
</head>
<body onload="showExcel();">
</body> </html>