<html>
<body>
<script lanage="javascript">
function createexcel()
{
var exceldemo = new activexobject("excel.application");
exceldemo.visible = true;
var workbook = exceldemo.workbooks.add();
var sheet = workbook.activesheet;
sheet.cells(1,1).value = "1月";
sheet.cells(2,1).value = "2月";
sheet.cells(3,1).value = "3月";
sheet.cells(4,1).value = "4月";
sheet.cells(1,2).value = "120";
sheet.cells(2,2).value = "250";
sheet.cells(3,2).value = "310";
sheet.cells(4,2).value = "80";
exceldemo.visible = true;
exceldemo.usercontrol = true;
oresizerange = sheet.range("b1:b4");
var chart = sheet.parent.charts.add();
chart.chartwizard(oresizerange, -4100, null, 2);
chart.seriescollection(1).xvalues = sheet.range("a1","a4");
chart.seriescollection(1).name = '月报';
chart.location(2, sheet.name);
sheet.shapes("chart 1").top = sheet.rows(10).top;
sheet.shapes("chart 1").left = sheet.columns(2).left;
}
</script>
<p><input id=button1 type=button value="生成excel" onclick="createexcel()"></p>
</body>
</html>
