java - 如何在 Grails 2.3.11 中安装 Apache POI
问题描述
使用 Apache 的示例,我正在尝试将 Apache POI 加载到我的 Grails 应用程序中。我有 GGTS(用于 Grails 开发的 Eclipse 克隆设置)作为我的 IDE。当我尝试像这样创建一个新的 HSSFWorkbook 对象时:
HSSFWorkbook workbook = new HSSFWorkbook()
IDE 告诉我无法解析类 HSSFWorkbook。如何正确设置 Apache POI 以便它在 Grails 2.3.11 中工作?我必须使用 Excel 文件,而 Apache POI 给了我更多的控制权。我已经看到它在另一个 Grails 2.3.11 应用程序中工作,所以我知道这是可能的。我更喜欢 Grails 2.3.11 支持的最新版本。
BuildConfig.groovy
grails.servlet.version = "3.0" // Change depending on target container compliance (2.5 or 3.0)
grails.project.class.dir = "target/classes"
grails.project.test.class.dir = "target/test-classes"
grails.project.test.reports.dir = "target/test-reports"
grails.project.work.dir = "target/work"
grails.project.target.level = 1.6
grails.project.source.level = 1.6
grails.server.port.http=8070
//grails.project.war.file = "target/${appName}-${appVersion}.war"
grails.project.fork = [
// configure settings for compilation JVM, note that if you alter the Groovy version forked compilation is required
// compile: [maxMemory: 256, minMemory: 64, debug: false, maxPerm: 256, daemon:true],
// configure settings for the test-app JVM, uses the daemon by default
test: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, daemon:true],
// configure settings for the run-app JVM
run: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, forkReserve:false],
// configure settings for the run-war JVM
war: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256, forkReserve:false],
// configure settings for the Console UI JVM
console: [maxMemory: 768, minMemory: 64, debug: false, maxPerm: 256]
]
grails.project.dependency.resolver = "maven" // or ivy
grails.project.dependency.resolution = {
// inherit Grails' default dependencies
inherits("global") {
// specify dependency exclusions here; for example, uncomment this to disable ehcache:
// excludes 'ehcache'
}
log "error" // log level of Ivy resolver, either 'error', 'warn', 'info', 'debug' or 'verbose'
checksums true // Whether to verify checksums on resolve
legacyResolve false // whether to do a secondary resolve on plugin installation, not advised and here for backwards compatibility
repositories {
inherits true // Whether to inherit repository definitions from plugins
grailsPlugins()
grailsHome()
mavenLocal()
grailsCentral()
mavenCentral()
// uncomment these (or add new ones) to enable remote dependency resolution from public Maven repositories
//mavenRepo "http://repository.codehaus.org"
//mavenRepo "http://download.java.net/maven/2/"
//mavenRepo "http://repository.jboss.com/maven2/"
}
dependencies {
// specify dependencies here under either 'build', 'compile', 'runtime', 'test' or 'provided' scopes e.g.
// runtime 'mysql:mysql-connector-java:5.1.27'
// runtime 'org.postgresql:postgresql:9.3-1100-jdbc41'
test "org.grails:grails-datastore-test-support:1.0-grails-2.3"
runtime 'org.codehaus.groovy:groovy-all:2.4.7'
runtime 'org.apache.poi:poi:3.14'
runtime 'org.apache.poi:poi-ooxml:3.14'
}
plugins {
// plugins for the build system only
build ":tomcat:7.0.54"
// plugins for security
compile ':spring-security-core:2.0.0'
compile ':spring-security-ldap:2.0.0'
// plugins for the compile step
compile ":scaffolding:2.0.3"
compile ':cache:1.1.7'
// plugins needed at runtime but not for compilation
runtime ":hibernate4:4.3.5.4"
runtime ":database-migration:1.4.0"
runtime ":jquery:1.11.1"
runtime ":resources:1.2.8"
runtime ':console:1.5.12'
// Uncomment these (or add new ones) to enable additional resources capabilities
//runtime ":zipped-resources:1.0.1"
//runtime ":cached-resources:1.1"
//runtime ":yui-minify-resources:0.1.5"
// An alternative to the default resources plugin is the asset-pipeline plugin
//compile ":asset-pipeline:1.6.1"
// Uncomment these to enable additional asset-pipeline capabilities
//compile ":sass-asset-pipeline:1.5.5"
//compile ":less-asset-pipeline:1.5.3"
//compile ":coffee-asset-pipeline:1.5.0"
//compile ":handlebars-asset-pipeline:1.3.0.1"
}
}
解决方案
更改您的依赖项块以设置编译时依赖项,并删除不需要的 groovy 依赖项:
dependencies {
test "org.grails:grails-datastore-test-support:1.0-grails-2.3"
compile 'org.apache.poi:poi:3.14'
compile 'org.apache.poi:poi-ooxml:3.14'
}
Grails 已经提供了适当版本的 Groovy,因此您不需要提供它。代码编译需要 POI 依赖项,因此它们应该是编译时依赖项。
如果这不能解决您的问题,至少有可能 GGTS 没有正确下载依赖项,但我怀疑情况会如此。
推荐阅读
- c++ - 扫描 C++ DLL 中的模式时的 EXCEPTION_ACCESS_VIOLATION
- php - Docker-compose WordPress 与 PHP 扩展
- python - AttributeError:“KerasRegressor”对象没有属性“模型”
- mongodb - 必须在操作上设置数据库字段
- python - Openpyxl 合并很慢
- paypal - 电子商务应用的Paypal钱包创建api
- reactjs - 打字稿 ts-nocheck 似乎被忽略了
- java - 使用java将json字符串转换为ndjson字符串
- wolfram-mathematica - ListPlot:(来自 Table 的数据)不是数字列表或数字对
- leaflet - react-leaflet 中的传单插件