您还可以参考这个clipboardPaste 来实现这个效果,具体代码如下:
- var sheet = spread.getActiveSheet();
- var fromRange = [new GC.Spread.Sheets.Range(15,0,1,33)];
- var toRanges = [new GC.Spread.Sheets.Range(16,0,3,33)];
- spread.commandManager().execute({cmd: "clipboardPaste", sheetName: "首页",
- fromSheet: sheet, fromRanges: fromRange,
- pastedRanges: toRanges, isCutting: false, clipboardText: "",
- pasteOption: GC.Spread.Sheets.ClipboardPasteOptions.formatting});
复制代码
实现效果如下:
|