Hello.
We are using HXTT Excel v1.1. Connection is established to a workbook and names of all worksheets in the connected workbook is also retrieved but when control reaches the line containing the query 'select * from worksheet_name', following exception is raised.
Exception in thread "AWT-EventQueue-0" java.lang.NoSuchFieldError: oo
at com.hxtt.sql.excel.a9.e(Unknown Source)
at com.hxtt.sql.excel.ad.a(Unknown Source)
at com.hxtt.sql.excel.ad.(Unknown Source)
at com.hxtt.sql.excel.v.a(Unknown Source)
at com.hxtt.sql.bl.if(Unknown Source)
at com.hxtt.sql.db.a(Unknown Source)
at com.hxtt.sql.db.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeQuery(Unknown Source)
at ConManETL.eXecute(ConManETL.java:57)
at ETL.makeSrcTable(ETL.java:553)
at ETL.jbNext_actionPerformed(ETL.java:206)
at ETL_jbNext_actionAdapter.actionPerformed(ETL.java:884)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1774)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
where worksheet_name is the name of the worksheet which has already been found by querying the workbook.
|
Can you compress your excel file and send it to our email box(webmaster@hxtt.com)?
We tested our excel file and it works very well.
We will solve this problem asap.
|