import apache poi

Support
#1

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)

#2

Hi,
Thank you for your test project.
As I see you have added the dependency to the core module. ButGUI does not depend on core so that is why you could not use the library on your screen.
Move the dependency to the global module.

#3

Thank you!