那只能用复制的方式了,先把sheet2也导入到显示的spread中,到后可以隐藏起来。
然后将sheet2 的内容复制到sheet1 的下半部分。导入完成后再把sheet2 删除掉
spread.commandManager().execute({cmd: "clipboardPaste", sheetName: "Sheet1", fromSheet: sheet2, fromRanges: fromRange, pastedRanges: toRanges, isCutting: false, clipboardText: "", pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.all});
var fromRange = [new GC.Spread.Sheets.Range(0, 0, 3, 2)];
var toRanges = [new GC.Spread.Sheets.Range(5, 0, 3, 2)];
http://sphelp.grapecity.com/webh ... me.html#sccopy.html |