如何把lotus notes数据生成EXCEL的图表?
1.获取lotus notes数据,可以用AJAX来获取数据,也可用代理来print数据
2.把数据写入excel中
oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sheet2 = oWB.Worksheets(2);
for(i=j;i<backstr.getElementsByTagName("viewentry").length;i++)
{
//alert(newOpt.attributes[0].text)
var newOpt = backstr.getElementsByTagName("viewentry")[i];
if(newOpt.attributes[0].text=="2")
{
//alert(newOpt.childNodes[0].text)
sheet2.Cells(i-j+3, 2).value = newOpt.childNodes[0].text;
sheet2.Cells(i-j+3, 3).value = newOpt.childNodes[1].text;
}
else
{
break
}
}
s