topic org.apache.poi.xssf cannot be resolved to a type in Talend Studio

org.apache.poi.xssf cannot be resolved to a type

nivedhitha — Fri, 01 Feb 2019 20:26:18 GMT

Hi everyone,

Im using the below code in tJava to find the number of sheets in an excel workbook.But ended up with the below error.

Please let me know a fix for this issue.

Thanks in advance

Re: org.apache.poi.xssf cannot be resolved to a type

akumar2301 — Sat, 02 Feb 2019 14:22:38 GMT

By default, POI library jars are not in class path so import does not work .
You might have to use one of excel component , so that these jars becomes part of build.
OR
You might have to use tLibrary to load all related POI jars .