国产Excel开发组件Spire.XLS教程：在 Java 中将工作表从一个工作簿复制到另一个工作簿

*这么优秀的国产工具怎能错过呢！在线下单专享“一口价”，立即购买！想要获取更多福利的朋友可以咨询在线客服哦~

代码如下：

import com.spire.xls.Workbook;import com.spire.xls.Worksheet;public class CopySheetBetweenWorkbooks {    public static void main(String[] args) {        //Create a Workbook object to load the source document        Workbook srcWorkbook = new Workbook();        srcWorkbook.loadFromFile("C:\Users\Administrator\Desktop\source.xlsx");        //Get the specific worksheet to copy        Worksheet originalSheet = srcWorkbook.getWorksheets().get(0);        //Create another Workbook object to load the destination document        Workbook destWorkbook = new Workbook();        destWorkbook.loadFromFile("C:\Users\Administrator\Desktop\destination.xlsx");        //Add the copy of selected sheet to destination document        Worksheet newSheet = destWorkbook.getWorksheets().addCopy(originalSheet);        newSheet.setName(originalSheet.getName());        //Copy the theme of source document to destination document        destWorkbook.copyTheme(srcWorkbook);        //Save to another file        destWorkbook.saveToFile("CopySheetBetweenWorkbooks.xlsx");    }}

是E-iceblue官方友好合作伙伴，如果您对spire.xls，可以联系在线客服了解具体授权价格和使用机制
标签：