Urgent help needed: I am trying to connect SFTP through Java Snippet (for some security reason, I cannot use SSH Node. In my case, SSH node doesn’t work) in KNIME to read the content of the XLSX file (Connection working fine. Problem is in reading XLSX). I tested the code in Eclipse, and it runs perfectly fine (the dependencies I used are attached below). [2024-02-23_12-55-30] Now, when I implemented this code in the KNIME, I got: WARN Java Snippet 3:22 Evaluation of java snippet failed for row “Row0”.The exception is caused by line 102 of the snippet. Exception message (NoSuchMethodError): 'org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream$Builder org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.builder()’ While I used the same libraries here: [2024-02-23_12-58-30] The problem is that it says the method is not found, while that commons-io jar has the method. [2024-02-23_13-00-28] I know this because the Eclipse project gave me the same issue, which worked when I changed the version of the commons-io. Now, why is KNIME giving me this issue? And how to solve this. Thanks in Advance.

This isn’t a solution to your specific problem but I’m wondering if it can give us any pointers. I have a component on the hub that I have just updated to work with KNIME 5.2 [image] XLSX Sheet Duplicator - 5.2 – takbb Takes a single sheet from a source Excel XLSX file and clones it to a new XLSX file. Multiple named destination sheets may be supplied in which case the origin… It’s purpose is to read an xlsx file, and duplicate a specified sheet, writing it out to a new file with a comma delimited list of sheet names. [image] I was wondering if it could be adapted to read your xlsx file. (i.e. unlink the component, open it and take a look at the Java Edit Variable being used for the java calls) It also uses import org.apache.poi.xssf.usermodel.*; and the following XSSFWorkbook call … try (FileInputStream inputStream = new FileInputStream(inputFilePath); XSSFWorkbook workbook = new XSSFWorkbook(inputStream); ... ... which I think you’d need to replace with your call: try ( InputStream inputStream = channel.get(out_Path); XSSFWorkbook workbook = new XSSFWorkbook(inputStream); ... ... but what is interesting is it doesn’t include apache commons-io, but instead uses the following KNIME bundles: [image] This may (or may not!) be helpful in working out what is going on.

Urgent! ERROR in reading XLSX file from SFTP location via Java Snippet

KNIME Analytics Platform

takbb February 26, 2024, 11:45am 14

In theory the problem is limited to major version changes, although I’ve not had a chance to test this myself as yet…