How to run this java code

YacineCh — Fri, 22 May 2020 10:55:45 GMT

Hello Team,

Please can you help me. I wana run this code in Talend. The objectif is adding Password to xlsx File.

import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.record.crypto.Biff8EncryptionKey;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;

public class ProtectedExcelFile {

public static void main(final String... args) throws Exception {

String fname = "C:\\Users\\ycham006\\Desktop\\REFRENTIEL_ITEM_BYTEL.xlsx";

FileInputStream fileInput = null;
BufferedInputStream bufferInput = null;
POIFSFileSystem poiFileSystem = null;
FileOutputStream fileOut = null;

try {
fileInput = new FileInputStream(fname);
bufferInput = new BufferedInputStream(fileInput);
poiFileSystem = new POIFSFileSystem(bufferInput);

Biff8EncryptionKey.setCurrentUserPassword("secret");
HSSFWorkbook workbook = new HSSFWorkbook(poiFileSystem, true);
HSSFSheet sheet = workbook.getSheetAt(0);

HSSFRow row = sheet.createRow(0);
Cell cell = row.createCell(0);

cell.setCellValue("THIS WORKS!");

fileOut = new FileOutputStream(fname);
workbook.writeProtectWorkbook(Biff8EncryptionKey.getCurrentUserPassword(), "");
workbook.write(fileOut);
}
catch (Exception ex) {

System.out.println(ex.getMessage());
}
finally {
try {

bufferInput.close();
}
catch (IOException ex) {

System.out.println(ex.getMessage());
}

try {

fileOut.close();
}
catch (IOException ex) {

System.out.println(ex.getMessage());
}
}
}
}

Re: How to run this java code

TRF — Mon, 25 May 2020 07:17:44 GMT

You should create a routine.
Here is a tutorial
https://www.talendbyexample.com/talend-code-routines-reference.html

topic Re: How to run this java code in Talend Studio

How to run this java code

Re: How to run this java code