与其复制不如通过getRange进行批量设置,例如:
- //设置公式
- worksheet.getRange("A1:A10000").setFormula("=SUM($B$1:$B$5)");
- //设置样式
- IStyle style = workbook.getStyles().add("testStyle");
- style.getBorders().get(BordersIndex.EdgeLeft).setLineStyle(BorderLineStyle.Thin);
- style.getBorders().get(BordersIndex.EdgeTop).setLineStyle(BorderLineStyle.Thick);
- style.getBorders().get(BordersIndex.EdgeRight).setLineStyle(BorderLineStyle.Double);
- style.getBorders().get(BordersIndex.EdgeBottom).setLineStyle(BorderLineStyle.Double);
- style.getBorders().setColor(Color.FromArgb(0, 255, 0));
- worksheet.getRange("A1:A10000").setStyle(style);
复制代码
|