jbarmash / grails-excel-import Goto Github PK
View Code? Open in Web Editor NEWExcel Import & Export Plugin, Uses Apache POI Library
Home Page: http://www.grails.org/plugin/excel-import
Excel Import & Export Plugin, Uses Apache POI Library
Home Page: http://www.grails.org/plugin/excel-import
java.lang.IllegalStateException: The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook.
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:1158)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.createCellStyle(HSSFWorkbook.java:76)
at org.grails.plugins.excelimport.ExcelImportService.setCellValue(ExcelImportService.groovy:591)
The ExcelImportService is creating a new CellStyle for each date cell, and thus exceeds the limit of 4,000 styles. I am about to check in a proposed fix.
Thanks for your effort on handy on plugin!
Sample application pointing to SVN is missing, do you have a copy of that in github or somewhere.
Could you please share that!
Hello.
I'm using this plugin and is a great tool and very easy, but I need to read merge cells from an Excel file and I don't know how to do it.
I read on Google that this is possible with Apache POI, but it's possible with this plugin?
Thank you very much.
Kind regards,
Miguel.
I want to use your plugin in a grails 2.0.1 app. I installed the plugin without problems but when I try to run the app the plugin unistalls automatically. Thanks in advanced for your feedback.
grails> install-plugin excel-import
| Plugin installed.
excel-import 1.0.0 -- Excel, Excel 2007 & CSV Importer Using Apache POI
hibernate 2.0.1 -- Hibernate for Grails
jquery 1.7.1 -- JQuery for Grails
resources 1.1.5 -- Resources
spring-security-core1.2.7.1 -- Spring Security Core Plugin
tomcat 2.0.1 -- Apache Tomcat plugin for Grails
webxml 1.4.1 -- WebXmlConfig
grails> run-app
| Uninstalled plugin [excel-import]
| Compiling 76 source files
Thanks in advanced
Dear,
After upgrade to 1.0, I found class ExcelImportUtils is not in project.
Is it missing or has an alternative?
Thanks,
Donny
In the Readme.txt you mention ExcelImportUtils and it was indeed available in version 0.9.6 of the plugin. Unfortunately I can't find it in the most recent code base ...
Can you give me a hint? Thanks.
Best regards,
Stefan
While using the grails-excel-import plugin during run-app, the import of the file works perfectly.
After building a WAR and running the same on Tomcat, we are seeing the following error:
groovy.lang.MissingPropertyException: No such property: sheetName for class: org.apache.poi.hssf.usermodel.HSSFSheet
at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:50)
at org.codehaus.groovy.runtime.callsite.PojoMetaClassGetPropertySite.getProperty(PojoMetaClassGetPropertySite.java:35)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGetProperty(AbstractCallSite.java:227)
at org.grails.plugins.excelimport.ExcelImportService.convertColumnMapOneRow(ExcelImportService.groovy:168)
at org.grails.plugins.excelimport.ExcelImportService$convertColumnMapOneRow.callCurrent(Unknown Source)
at org.grails.plugins.excelimport.ExcelImportService.convertColumnMapManyRows(ExcelImportService.groovy:131)
at org.grails.plugins.excelimport.ExcelImportService$convertColumnMapManyRows.callCurrent(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:133)
at org.grails.plugins.excelimport.ExcelImportService.convertColumnMapConfigManyRows(ExcelImportService.groovy:102)
at org.grails.plugins.excelimport.ExcelImportService$convertColumnMapConfigManyRows.callCurrent(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(CallSiteArray.java:49)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:133)
at org.grails.plugins.excelimport.ExcelImportService.columns(ExcelImportService.groovy:82)
at org.grails.plugins.excelimport.ExcelImportService.columns(ExcelImportService.groovy)
at org.grails.plugins.excelimport.ExcelImportService$columns.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120)
at com.example.package.SomeService.importStuff(SomeService.groovy:253)
This is being observed while calling ExcelImportService.columns as follows:
columnList = excelImportService.columns(workbook, columnConfig)
Any suggestions for this issue or any resolution would be highly appreciated.
Thanks,
KD
Hi, I am getting the following error after installing the plugin for Grails 2.0 :
Error Error executing script RunApp: loader constraint violation: loader (instance of ) previously initiated loading for a different type with name "org/w3c/dom/TypeInfo" (Use --stacktrace to see the full trace)
I have managed to solve it by replacing the C:\Users.grails\ivy-cache\org.apache.xmlbeans\xmlbeans\jars\xmlbeans-2.3.0.jar with the one comes with the plugin
C:\Users.grails\2.0.0\projects\testing\plugins\excel-import-1.0.0\lib\xmlbeans-2.3.0-without-w3c.jar
Just wondering whether there is a better way ? Thx.
Hi,
I have tried to install excel-import 1.0 with Grails 2.0 and get the following error due to the falcone-util 1.0 which excel-import depends on. Any suggestion ?
Thx.
Regards,
Thum
grails> run-app
| Compiling 184 source files.
| Error Compilation error: startup failed:
Compile error during compilation with javac.
C:\Users\ckthum.grails\2.0.0\projects\iTCM-std\plugins\falcone-util-1.0\src\jav
a\util\TreeKey.java:3: warning: sun.misc.ASCIICaseInsensitiveComparator is Sun p
roprietary API and may be removed in a future release
import sun.misc.ASCIICaseInsensitiveComparator;
^
C:\Users\ckthum.grails\2.0.0\projects\iTCM-std\plugins\falcone-util-1.0\src\jav
a\com\infusion\util\domain\event\hibernate\InterceptableSession.java:31: com.inf
usion.util.domain.event.hibernate.InterceptableSession is not abstract and does
not override abstract method getLoadQueryInfluencers() in org.hibernate.engine.S
essionImplementor
public class InterceptableSession implements EventSource, Session {
^
C:\Users\ckthum.grails\2.0.0\projects\iTCM-std\plugins\falcone-util-1.0\src\jav
a\com\infusion\util\domain\event\hibernate\InterceptableSessionFactory.java:40:
com.infusion.util.domain.event.hibernate.InterceptableSessionFactory is not abst
ract and does not override abstract method getTypeHelper() in org.hibernate.Sess
ionFactory
public class InterceptableSessionFactory implements SessionFactory , SessionFact
oryImplementor{
^
C:\Users\ckthum.grails\2.0.0\projects\iTCM-std\plugins\falcone-util-1.0\src\jav
a\util\TreeKey.java:18: warning: sun.misc.ASCIICaseInsensitiveComparator is Sun
proprietary API and may be removed in a future release
private static final Comparator STRING_COMPARATOR = new ASCIICaseInsensitive
Comparator();
^
Note: Some input files use or override a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
Note: Some input files use unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
2 errors
2 warnings
1 error
| Error Error running script run-app: org.codehaus.groovy.grails.cli.ScriptExitE
xception (Use --stacktrace to see the full trace)
Hi,
Would you please upgrade to apache POI 3.8, since it resolves many 3.7 issues, i currently use this workraound BuildConfig.groovy :
compile ('org.apache.poi:poi:3.8')
compile ('org.apache.poi:poi-ooxml:3.8') {
excludes 'xmlbeans'
}
and
compile (":export:1.5") {
excludes "org.apache.poi:poi"
}
Thanks
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.