<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=utf-8">
<title>エクセルのXMLデータを表示する</title>
<link rel="stylesheet" href="main.css" type="text/css">
<script type="text/javascript" src="prototype.js"></script>
<script type="text/javascript" src="Lib_Excel.js"></script>
<script type="text/javascript"><!--
function loadXMLFile()
{
var filename = "strawberry.xml?cache="+(new Date()).getTime();
new Ajax.Request(filename, { method: "get", onComplete: displayData });
}
function displayData(httpObj)
{
var sheetName = "Sheet1";
var xmlObj = httpObj.responseXML;
var wsObj = getWorkSheet(xmlObj, sheetName);
var w = getWorkSheetColCount(wsObj);
var h = getWorkSheetRowCount(wsObj);
var resultData = "<table border='1' cellspacing='0'>";
for (var posY=0; posY<h; posY++)
{
resultData += "<tr>";
for (var posX=0; posX<w; posX++)
{
var n = getCellData(xmlObj,sheetName,posX,posY);
resultData += "<td>"+n +"</td>";
}
resultData += "</tr>";
}
resultData += "</table>";
$("result").innerHTML = resultData;
}
// --></script>
</head>
<body>
<h1>エクセルのXMLデータを表示する</h1>
<form>
<input type="button" value="XMLファイルを読み込み" onClick="loadXMLFile()"><br>
</form>
<div id="result"></div>
</body>
</html>
説明などは本書を参考にしてください。