import com.spire.xls.*;

public class Copy1 {
 public static void main(String[] args) {
  //加載文檔
  Workbook wb = new Workbook();
  wb.loadFromFile("test.xlsx");

  //獲取第一張工作表
  Worksheet sheet0 = wb.getWorksheets().get(0);

  //獲取第三張工作表，命名，并將第一張工作表內(nèi)容復(fù)制到該工作表
  Worksheet sheet2 = wb.getWorksheets().get(2);
  sheet2.setName("Copiedsheet");
  sheet2.copyFrom(sheet0);

  //保存文檔
  wb.saveToFile("Copy1.xlsx",FileFormat.Version2013);
 }
}

import com.spire.xls.*;

public class Copy2 {
 public static void main(String[] args) {
  //加載文檔1，并獲取第一張幻燈片
  Workbook wb1 = new Workbook();
  wb1.loadFromFile("test1.xlsx");
  Worksheet sheet1 = wb1.getWorksheets().get(0);

  //加載文檔2，獲取第三張幻燈片，并將文檔1中的工作表內(nèi)容復(fù)制到該工作表
  Workbook wb2 = new Workbook();
  wb2.loadFromFile("test2.xlsx");
  Worksheet sheet2 = wb2.getWorksheets().get(2);
  sheet2.setName("Copied");
  sheet2.copyFrom(sheet1);

  //保存文檔
  wb2.saveToFile("Copy2.xlsx",FileFormat.Version2013);
 }
}

import com.spire.xls.*;

public class CopyRange {
 public static void main(String[] args) {
  //加載文檔
  Workbook wb = new Workbook();
  wb.loadFromFile("test.xlsx");

  //獲取第一個(gè)工作表
  Worksheet sheet = wb.getWorksheets().get(0);

  //復(fù)制指定單元格范圍中的數(shù)據(jù)
  CellRange range1 = sheet.getCellRange(8,1,8,7);
  CellRange range2 = sheet.getCellRange(11,1,11,7);
  sheet.copy(range1,range2,true);

  //保存文檔
  wb.saveToFile("CopyRange.xlsx",FileFormat.Version2013);
 }
}