jbarmash / grails-excel-import Goto Github PK

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!

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.

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.

Dear,

After upgrade to 1.0, I found class ExcelImportUtils is not in project.
Is it missing or has an alternative?

Thanks,
Donny

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

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.

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

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)

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.

Plug-ins you currently have installed are listed below:

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