try { FileInputStream fileInput = new FileInputStream("sample.xls"); BufferedInputStream bufferInput = new BufferedInputStream(fileInput); POIFSFileSystem poiFileSystem = new POIFSFileSystem(bufferInput); Biff8EncryptionKey.setCurrentUserPassword("password"); HSSFWorkbook workbook = new HSSFWorkbook(poiFileSystem, true); HSSFSheet sheet = workbook.getSheetAt(0); HSSFRow row = sheet.createRow(0); Cell cell = row.createCell(0); cell.setCellValue("Hello World"); FileOutputStream fileOut = new FileOutputStream(fname); workbook.writeProtectWorkbook(Biff8EncryptionKey.getCurrentUserPassword(), ""); workbook.write(fileOut); } catch (Exception ex) { }
workbook.writeProtectWorkbook(Biff8EncryptionKey.getCurrentUserPassword(), ""); workbook.write(fileOut);
HSSFWorkbook wb1 = new HSSFWorkbook(leftIs); HSSFWorkbook wb2 = new HSSFWorkbook(new FileInputStream(newFile)); wb1.writeProtectWorkbook("", "CIFSContentComparator"); wb2.writeProtectWorkbook("", "CIFSContentComparator");
HSSFWorkbook wb1 = new HSSFWorkbook(leftIs); HSSFWorkbook wb2 = new HSSFWorkbook(new FileInputStream(newFile)); wb1.writeProtectWorkbook("", "CIFSContentComparator"); wb2.writeProtectWorkbook("", "CIFSContentComparator");