- var dataArray = [];
- var dataObj = "=IF(ISBLANK(A1), 1, 0)";
- var data = [];
- for (var index = 0; index< 200; index++) {
- dataArray.push(dataObj);
- }
- for (var index = 0; index< 44; index++) {
- data.push(dataArray);
- }
- dataObj = "=IF(ISERROR(N72/N14), 1, N72/N14)";
- var data1 = [];
- dataArray = [];
- for (var index = 0; index< 200; index++) {
- dataArray.push(dataObj);
- }
- for (var index = 0; index< 510; index++) {
- data1.push(dataArray);
- }
- dataObj = "=SUMIFS(N42:N81, B42:B81, 2)*N84";
- var data2 = [];
- dataArray = [];
- for (var index = 0; index< 200; index++) {
- dataArray.push(dataObj);
- }
- for (var index = 0; index< 1290; index++) {
- data2.push(dataArray);
- }
- // 描画中断
- spread.suspendPaint();
- // ?算中断
- sheet.suspendCalcService(false);
- sheet.setArray(2, 14, data, true);
- sheet.setArray(48, 14, data1, true);
- sheet.setArray(560, 14, data2, true);
- // 描画再?
- spread.resumePaint();
- // ?算再?
- sheet.resumeCalcService(false);
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图