Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
nivedhitha
Creator III
Creator III

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

Hi everyone,

 

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

0683p000009M2CN.png

Please let me know a fix for this issue.

Thanks in advance

Labels (3)
1 Solution

Accepted Solutions
akumar2301
Specialist II
Specialist II

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 .

View solution in original post

1 Reply
akumar2301
Specialist II
Specialist II

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 .