基于特定工作表的复制范围？-灵析社区

刘一抗二二

Java: public void CopyRange() { Workbook wb = new Workbook(); wb.getWorksheets().add(); IWorksheet sheet1 = wb.getWorksheets().get(0); IWorksheet sheet2 = wb.getWorksheets().get(1); //在Sheet1中添加测试数据 Object[][] data = new Object[][] { { 1 }, { 3 }, { 5 }, { 7 }, { 9 } }; sheet1.getRange("A1:A5").setValue(data); //把数据从sheet1上复制到sheet2中 sheet1.getRange("A1:A5").copy(sheet2.getRange("A1:A5")); //或者使用 剪切 //sheet1.getRange("A1:A5").cut(sheet2.getRange("A1:A5")); //保存为Excel wb.save("output/CopyRange.xlsx"); } 参考资料："https://demo.grapecity.com.cn/documents-api-excel-java/demos/..." (https://link.segmentfault.com/?enc=hTbfT%2BGrpW4b92wJsyX6%2Bw%3D%3D.bXTgyypiRnDdV96zsFbw0GW928ba37u6IiOjdLGt6O8oa0YKfuWPnrsrp1%2BxT4ebNNOjVRX02efTwbq0xKeOHldCYDWt3w3UIHa2qXuN8cyuY%2FrZNKHAT901akI4vZzT)