【poi】跨excel文件多sheet页复制

import static org.apache.poi.ss.usermodel.CellType.BLANK;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import java.util.Set;
import java.util.TreeSet;

import org.apache.commons.compress.utils.Lists;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.SheetConditionalFormatting;
import org.apache.poi.ss.usermodel.SheetVisibility;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.ss.util.PaneInformation;
import org.apache.poi.xssf.streaming.SXSSFCell;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFColor;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author trx
 */
public final class CopySheetUtil {
   

	private CopySheetUtil() {
   
	}

	/**
	 * 将来源文件的所有sheet页复制到目标文件中，并最后生成新文件
	 * @param destPath 目标文件
	 * @param srcPaths 来源文件集合
	 * @param newPath 新文件地址
	 * @throws Exception
	 */
	public static void copySheets(String destPath, List<String> srcPaths, String newPath) throws Exception {
   
		SXSSFWorkbook toWriteWb = new SXSSFWorkbook(new XSSFWorkbook(new FileInputStream(destPath)), 1000);
		int numberOfSheets = toWriteWb.getNumberOfSheets();

		List<String> sheetNames = Lists.newArrayList();
		for (int i = 0; i <