Comments on kasper's source: Query your Excel spreadsheet with Java

Hi Tina and others, MetaModel 1.5 is now out :) ...

2011-02-13T18:23:58.845+01:00

Hi Tina and others,

MetaModel 1.5 is now out :)

Read more and get it at:
http://metamodel.eobjects.org/

Hi Tina, Actually I got quite excited when lookin...

2011-02-01T13:23:31.493+01:00

Hi Tina,

Actually I got quite excited when looking into how easy it was to evaluate the formulas so I just implemented the solution today :)

It will be released together with the upcoming MetaModel 1.5 within the next coming weeks. If you can't wait, you can also check it out from SVN yourself and build the latest snapshot. It's available here: http://eobjects.org/svn/MetaModel/trunk

Thanks for the quick response, I hope you can add ...

2011-02-01T10:33:49.347+01:00

Thanks for the quick response, I hope you can add this feature on your next release it would be a great help for me.. thanks again :-)

Hi Tina, Formula calculation is currently not sup...

2011-02-01T09:06:50.027+01:00

Hi Tina,

Formula calculation is currently not supported. I will add a feature request for it, because I actually think that POI (the underlying excel api that we use) is able of calculating at least rather simple formulas, so it might be a feature that is quite easy to add.

Hi, i just want to ask how to get formula values o...

2011-02-01T08:23:44.911+01:00

Hi, i just want to ask how to get formula values of excel columns? when i tried using dataset.getRows(), i only get the formula and not the result value of the formula. thanks.

It seems to work fine, now! Thank you very much :)...

2009-06-18T12:42:59.168+02:00

It seems to work fine, now!
Thank you very much :)

Alright. MetaModel 1.1.6 is out. I'm uploading...

2009-06-17T22:57:08.963+02:00

Alright. MetaModel 1.1.6 is out. I'm uploading to the maven repository as I write this message, but you should be able to download it from google code already if you just need the jar. Let me know how it works.

I've been looking into this and I'm affrai...

2009-06-17T21:59:15.495+02:00

I've been looking into this and I'm affraid you've found a "real" bug this time!

I will fix it right away and post a fix-release. Should be available in a couple of hours, so bear with me :)

Thanks, that worked ;) But I'm not done bothe...

2009-06-17T19:05:31.236+02:00

Thanks, that worked ;)

But I'm not done bothering you...

I'm doing some experiments with your MetaModel. I'm trying to query a spreadsheet with a financial report of some sort.

But I'm stuck at opening and reading the XLS file, with this exception which I don't understand:

Exception in thread "main" java.lang.IllegalStateException: Exception reading from file: d:\report.xls
at dk.eobjects.metamodel.ExcelDataContextStrategy.materializeMainSchemaTable(ExcelDataContextStrategy.java:106)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.materializeTable(QueryPostprocessDataContextStrategy.java:286)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.materializeFromItem(QueryPostprocessDataContextStrategy.java:231)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.executeQuery(QueryPostprocessDataContextStrategy.java:107)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.transformColumnTypes(QueryPostprocessDataContextStrategy.java:154)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.transformColumnTypes(QueryPostprocessDataContextStrategy.java:143)
at dk.eobjects.metamodel.QueryPostprocessDataContextStrategy.autoTransformColumnTypes(QueryPostprocessDataContextStrategy.java:193)
at dk.eobjects.metamodel.DataContextFactory.createExcelDataContext(DataContextFactory.java:156)
at it.previnet.bittoa.metamodel.ExcelQuery.main(ExcelQuery.java:17)
Caused by: java.lang.NullPointerException
at dk.eobjects.metamodel.ExcelDataContextStrategy.getCellValue(ExcelDataContextStrategy.java:168)
at dk.eobjects.metamodel.ExcelDataContextStrategy.materializeMainSchemaTable(ExcelDataContextStrategy.java:81)
... 8 more

Can you help me?

Thanks again ;)

Hi Alberto, Oops, you're right ... That revea...

2009-06-17T18:45:54.062+02:00

Hi Alberto,

Oops, you're right ... That reveals that I made the example by hand and not in eclipse ;-)

The fix is:

query.select(new SelectItem(FunctionType, Column))

Sorry for the inconvenience, I will correct the example right away.

Hi, I downloaded latest version of your MetaModel ...

2009-06-17T18:23:00.262+02:00

Hi,
I downloaded latest version of your MetaModel (1.1.5) and tried your example to query an Excel spreadsheet.

The problem is that I can't even compile since there is not a select(FunctionType, Column) method provided by Query object!

I tried downloading some older versions of your project, but the problem remains.

Can you help me? What am I doing wrong?

Thanks!

Hi Entisar, It just occurred to me, that one thin...

2009-05-21T14:49:03.159+02:00

Hi Entisar,

It just occurred to me, that one thing you might be forgetting is to include the Apache POI jars? As stated on the MetaModel, they are required for using MetaModels excel support. I believe that they are in the lib folder of the distributable zip.

inglyThanks a lot Casper. Im addind the jars in ec...

2009-05-21T12:34:34.806+02:00

inglyThanks a lot Casper.
Im addind the jars in eclipse manually.
I dont have any knowledge about the maven.
I tried deleting them and add then again. but still giving errors.

I liked your API it seems clean and staraight forward comparing with other APIs i found for Excel.
but I may try another one.

Thanks again,
Ent.

Hi Entisar, There must be some other explanation ...

2009-05-20T13:56:07.359+02:00

Hi Entisar,

There must be some other explanation (another cause in the stack trace maybe?) because the class that it is missing (MetaModelException) is in the MetaModel-core.jar file.

I'm writing this from a borrowed machine so I can't make a testcase (for the next couple of weeks actually) myself... Are you manually adding the jar's or are you using Maven? If you use Maven it gets so much easier to manage the dependencies, but that's a long story :)

Thanks a lot for your reply. i've checked it and k...

2009-05-20T13:16:22.774+02:00

Thanks a lot for your reply.
i've checked it and kept only these four JARs, but Im getting now

ava.lang.NoClassDefFoundError: dk/eobjects/metamodel/MetaModelException
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Unknown Source)
at java.lang.Class.privateGetPublicMethods(Unknown Source)
at java.lang.Class.getMethods(Unknown Source)
at org.jboss.ws.metadata.builder.jaxws.JAXWSMetaDataBuilder.processWebMethods(JAXWSMetaDataBuilder.java:885)
at org.jboss.ws.metadata.builder.jaxws.JAXWSWebServiceMetaDataBuilder.buildWebServiceMetaData(JAXWSWebServiceMetaDataBuilder.java:150)
at org.jboss.ws.metadata.builder.jaxws.JAXWSServerMetaDataBuilder.setupProviderOrWebService(JAXWSServerMetaDataBuilder.java:52)
at org.jboss.ws.metadata.builder.jaxws.JAXWSMetaDataBuilderJSE.buildMetaData(JAXWSMetaDataBuilderJSE.java:63)
at org.jboss.wsf.stack.jbws.UnifiedMetaDataDeploymentAspect.create(UnifiedMetaDataDeploymentAspect.java:66)
at org.jboss.wsf.framework.deployment.DeploymentAspectManagerImpl.deploy(DeploymentAspectManagerImpl.java:118)
at org.jboss.wsf.container.jboss42.ArchiveDeployerHook.deploy(ArchiveDeployerHook.java:97)
at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:90)
at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy45.start(Unknown Source)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy9.deploy(Unknown Source)
at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225)
Caused by: java.lang.ClassNotFoundException: dk.eobjects.metamodel.MetaModelException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)

Im not expert in setting up the environment properly, i dontknow if how do i obtain the assembled JAr.

Entiser

Hi entisar, My only guess would be that you are m...

2009-05-19T09:53:00.000+02:00

Hi entisar,

My only guess would be that you are maybe not including all the needed JARs. If you need to use the excel spreadsheet functionality, you will need:

MetaModel-full, MetaModel-excel, MetaModel-querypostprocessor, MetaModel-core.

It just occurs to me that we should probably distribute an assembled jar as well. But that's probably for you to wait for MetaModel 1.1 for :)

Hi Kasper, Thanks a lot for the useful informatio...

2009-05-18T22:36:00.000+02:00

Hi Kasper,

Thanks a lot for the useful information.
I tried the same example and I got correct result. However, Im trying to create a web service that get data from Excel, when I deployed my application, I got the error "NoClassDefFoundError" for the DataContext. I have included the jar file in the project. I'm currently using Eclipse and JBoss.. I hope you can advice me.
Thanks a lot
Entisar

Hi Dimon4k, Actually just yesterday I answered th...

2009-05-18T12:33:00.000+02:00

Hi Dimon4k,

Actually just yesterday I answered that question at the eobjects forums so I'm just going to direct you with a link :)

Hope it works for you:
http://eobjects.org/trac/discussion/7/76

Hi. Kasper, can you explain how to use 'where' cla...

2009-05-17T18:47:00.000+02:00

Hi.
Kasper, can you explain how to use 'where' clause to query data from two worksheets? How to connect them? Is it possible?

Hi Jorge,

I'm honored that you think my wor...

2009-04-01T08:58:00.000+02:00

Hi Jorge,

I'm honored that you think my work is impressive! Thank you very much.

If you want to join in on the development I recommend that you add your email to this mailing list: http://groups.google.com/group/metamodel

Currently the mailing list is rather dead, but we can change that of course :-) Please email in your idea about the HSSFWorkbook constructor for the ExcelDataContextStrategy and we'll take it from there! Looking forward to having you on board :)

i'll sure do that. i've read your blog entirely an...

2009-04-01T00:17:00.000+02:00

i'll sure do that. i've read your blog entirely and i'm amazed about your work. i've only tried metamodel to query some excel files and didn't notice that metamodel is just the tip of the iceberg. congratulations

Hi Jorge,
Glad you found it useful! Currently w...

2009-03-31T16:57:00.000+02:00

Hi Jorge,
Glad you found it useful! Currently what you are asking is not possible. But if you feel like it -take a look at the source code for MetaModel. I'm sure it will be an easy patch to develop and I will welcome it for sure.

2009-03-31T16:28:00.001+02:00

This comment has been removed by the author.

it helped me a lot. congrats for you exceptional p...

2009-03-31T16:28:00.000+02:00

it helped me a lot. congrats for you exceptional piece of work.

one question. is it possible to load directly one HSSFWorkbook object?