Hi
I have followed the instructions for adding a third party library but it is not working for me.
I have added the library in project properties/advanced:
dependencies {
compile(globalModule)
provided(servletApi)
jdbc(hsql)
testRuntime(hsql)
compile('org.apache.poi:poi-ooxml:3.16')
}
after that I open with Idea and add the code
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet("Datatypes in Java");
It appears with read and when I alt+enter am able to select “add library to class path” and Idea recognizes the code but then when I try to compile I get
:app-web:compileJavaC:\Users\User\studio-projects\tester\modules\web\src\com\company\tester\web\screens\Screen.java:4: error: package org.apache.poi.xssf.usermodel does not exist
import org.apache.poi.xssf.usermodel.XSSFSheet;
^
C:\Users\User\studio-projects\tester\modules\web\src\com\company\tester\web\screens\Screen.java:5: error: package org.apache.poi.xssf.usermodel does not exist
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
^
C:\Users\User\studio-projects\tester\modules\web\src\com\company\tester\web\screens\Screen.java:14: error: cannot find symbol
XSSFWorkbook workbook = new XSSFWorkbook();
^
symbol: class XSSFWorkbook
location: class Screen
C:\Users\User\studio-projects\tester\modules\web\src\com\company\tester\web\screens\Screen.java:14: error: cannot find symbol
XSSFWorkbook workbook = new XSSFWorkbook();
^
symbol: class XSSFWorkbook
location: class Screen
C:\Users\User\studio-projects\tester\modules\web\src\com\company\tester\web\screens\Screen.java:15: error: cannot find symbol
XSSFSheet sheet = workbook.createSheet("Datatypes in Java");
^
symbol: class XSSFSheet
location: class Screen
5 errors
FAILED
test project attached
please help, thank you
tester.zip (251.7K)