您说的效果不对指的是行高不一样吗?
如果指的是行高的话,可以在copyTo完毕后再设置一下行高即可。
- let sheet = spread.getActiveSheet();
- let from = 11;
- let to = 12;
- sheet.addRows(to, 1);
- sheet.copyTo(
- from,
- 0,
- to,
- 0,
- 1,
- sheet.getColumnCount() - 1,
- GC.Spread.Sheets.CopyToOptions.style
- );
- sheet.copyTo(
- from,
- 9,
- to,
- 9,
- 1,
- 7,
- GC.Spread.Sheets.CopyToOptions.span
- );
- sheet.setRowHeight(to, sheet.getRowHeight(from));
复制代码
|