<script language="JavaScript">
var pptApp = new ActiveXObject("PowerPoint.Application");
pptApp.Visible = true;
var pptdoc = pptApp.Presentations.Add(true);
var slide = pptdoc.Slides.Add(1,12) //pptLayoutTitleOnly=11 pptLayoutBlank=12
var shapes = slide.Shapes; //add a MSGraph.Chart object to the slide.
var pptChart = shapes.AddOLEObject(0, 0, 0, 0, "MSGraph.Chart", "", 0, "", 0, "", 0)
var objChart = pptChart.OLEFormat.Object;
var datasheet = objChart.Application.DataSheet;
//datasheet.Cells.Clear() //clear the old data
var ss = new Array(2);
for (var i = 0; i <4; i++) {
ss[i] = new Array(100);
for (var j = 0; j <100; j++) {
ss[i][j] = 9;
}
}
for (var i = 0; i <4; i++) {
for (var j = 0; j <100; j++) {
datasheet.Cells(j+2, i+2) = ss[i][j];
}
}
</script>我的问题是:
datasheet中的数据来自数组。
对单元格逐一赋值,每次增加一个单元格的数据时,chart就得重绘一次。当数据量很大时, 所花费的时间就会很长。请问有什么办法可以解决这个问题?
var pptApp = new ActiveXObject("PowerPoint.Application");
pptApp.Visible = true;
var pptdoc = pptApp.Presentations.Add(true);
var slide = pptdoc.Slides.Add(1,12) //pptLayoutTitleOnly=11 pptLayoutBlank=12
var shapes = slide.Shapes; //add a MSGraph.Chart object to the slide.
var pptChart = shapes.AddOLEObject(0, 0, 0, 0, "MSGraph.Chart", "", 0, "", 0, "", 0)
var objChart = pptChart.OLEFormat.Object;
var datasheet = objChart.Application.DataSheet;
//datasheet.Cells.Clear() //clear the old data
var ss = new Array(2);
for (var i = 0; i <4; i++) {
ss[i] = new Array(100);
for (var j = 0; j <100; j++) {
ss[i][j] = 9;
}
}
for (var i = 0; i <4; i++) {
for (var j = 0; j <100; j++) {
datasheet.Cells(j+2, i+2) = ss[i][j];
}
}
</script>我的问题是:
datasheet中的数据来自数组。
对单元格逐一赋值,每次增加一个单元格的数据时,chart就得重绘一次。当数据量很大时, 所花费的时间就会很长。请问有什么办法可以解决这个问题?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货