使用jacob 合并excel

使用jacob 合并excel

 

 

try {
           
            String tempDir = System.getProperty("java.io.tmpdir");
            ActiveXComponent excel = new ActiveXComponent("Excel.Application");
            Dispatch workbooks = excel.getProperty("Workbooks").toDispatch();
            Dispatch workbook = Dispatch.call(
                    workbooks,
                    "Open","master.xls" ).toDispatch();
            Variant[] vargs = new Variant[copyFromFilesArray.length + 2];
            vargs[0] = new Variant("Sheet1.CombineWorkbooks");
            SequenceUUID oGeneration = SequenceUUID.getInstance();
            String tempFile = tempDir + oGeneration.getUUID() + ".xls";
            vargs[1] = new Variant(tempFile);
            for (int i = 0; i < copyFromFilesArray.length; i++) {
                vargs[i + 2] = new Variant(copyFromFilesArray[i]);
            }
            Dispatch.call(excel, "Run", vargs);
            return tempFile;
        } finally {
            ComThread.Release();
        }