我有一段代码看不懂请那位高手指教,不胜感激!
hw352 2003-12-04 03:55:05 <SCRIPT LANGUAGE="JavaScript">
function testF(x1FileName)
{
//此处应该加上对文件类型的判断,x1FileName只能是xls文件,否则出错!
var xls = new ActiveXObject("Excel.Application");
var zjbl,jgbl;
var i;
var j;
var bz;
var str;
var onecount;
var sumval;
onecount=12;
sumval=0;
j=0;
str="";
bz=false;
zjbl="";
jgbl="";
------------------------以上应该是申明变量及赋值,这我懂var xls = new ActiveXObject("Excel.Application");不懂
------------------------------------
xls.visible = false;
var x1Book = xls.Workbooks.Open(x1FileName);
for (i=2;i<xls.ActiveSheet.Rows.Count;i++)
{
jgbl="";
for (j=1;j<onecount; j++)
{
if (xls.ActiveSheet.Cells(i,j).Value==null)
{
bz=true;
}
if (j!=(onecount-1))
{
zjbl="'"+xls.ActiveSheet.Cells(i,j).Value+"',";
jgbl=jgbl+zjbl;
}
else
{
zjbl="'"+xls.ActiveSheet.Cells(i,j).Value+"'";
jgbl=jgbl+zjbl;
}
if (xls.ActiveSheet.Cells(i,j).Value!=null)
{
bz=false;
}
}
str=str+"<input type='hidden' name=h"+i+" value=("+jgbl+")>";
if (bz==true)
{
break;
x1Book.Close;
xls.visible = false;
xls.Quit();
}
sumval=sumval+1;
document.all.hehe.innerHTML=str;
}
str="";
str=str+"<input type='hidden' name=sumval value="+sumval+">";
document.all.haha.innerHTML=str;
//上面这两行,能够将Excel中的数据传递到页面的对象Mform.Mname中去,剩下的你就应该知道了吧(循环取数,判断是否到行和列的末尾等等)
//注意:由于创建ActiveXObject,需要降低客户端IE的安全级别(ActiveX中均启用),否则会出现脚本错误
x1Book.Close;
xls.visible = false;
xls.Quit();
}
</SCRIPT>