导入文件报错(common.AssertionFailed at common.Assert.verify)

common.AssertionFailed
    at common.Assert.verify(Unknown Source)
    at jxl.read.biff.WorkbookParser.getName(Unknown Source)
    at jxl.biff.formula.NameRange.read(Unknown Source)
    at jxl.biff.formula.TokenFormulaParser.g(Unknown Source)
    at jxl.biff.formula.TokenFormulaParser.parse(Unknown Source)
    at jxl.biff.formula.FormulaParser.parse(Unknown Source)
    at jxl.biff.DVParser.<init>(Unknown Source)
    at jxl.biff.DataValiditySettingsRecord.initialize(Unknown Source)
    at jxl.biff.DataValiditySettingsRecord.getFirstColumn(Unknown Source)
    at jxl.read.biff.SheetReader.J(Unknown Source)
    at jxl.read.biff.SheetImpl.l(Unknown Source)
    at jxl.read.biff.SheetImpl.getRows(Unknown Source)
    at com.ufgov.fas.client.page.TreeTableAuditPage_JS.importApplys(TreeTableAuditPage_JS.java:1060)
    at com.ufgov.fas.client.page.TreeTableAuditPage_JS.imported(TreeTableAuditPage_JS.java:1034)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.ufgov.fas.client.component.toolbar.PermissionFiltedToolBar.actionPerformed(PermissionFiltedToolBar.java:65)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    at org.jvnet.substance.utils.RolloverButtonListener.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Component.java:6041)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
    at java.awt.Component.processEvent(Component.java:5806)
    at java.awt.Container.processEvent(Container.java:2058)
    at java.awt.Component.dispatchEventImpl(Component.java:4413)
    at java.awt.Container.dispatchEventImpl(Container.java:2116)
    at java.awt.Component.dispatchEvent(Component.java:4243)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
    at java.awt.Container.dispatchEventImpl(Container.java:2102)
    at java.awt.Window.dispatchEventImpl(Window.java:2440)
    at java.awt.Component.dispatchEvent(Component.java:4243)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.ufgov.fas.client.component.toolbar.PermissionFiltedToolBar.actionPerformed(PermissionFiltedToolBar.java:65)
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    at org.jvnet.substance.utils.RolloverButtonListener.mouseReleased(Unknown Source)
    at java.awt.Component.processMouseEvent(Component.java:6041)
    at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
    at java.awt.Component.processEvent(Component.java:5806)
    at java.awt.Container.processEvent(Container.java:2058)
    at java.awt.Component.dispatchEventImpl(Component.java:4413)
    at java.awt.Container.dispatchEventImpl(Container.java:2116)
    at java.awt.Component.dispatchEvent(Component.java:4243)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
    at java.awt.Container.dispatchEventImpl(Container.java:2102)
    at java.awt.Window.dispatchEventImpl(Window.java:2440)
    at java.awt.Component.dispatchEvent(Component.java:4243)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: common.AssertionFailed
    at common.Assert.verify(Unknown Source)
    at jxl.read.biff.WorkbookParser.getName(Unknown Source)
    at jxl.biff.formula.NameRange.read(Unknown Source)
    at jxl.biff.formula.TokenFormulaParser.g(Unknown Source)
    at jxl.biff.formula.TokenFormulaParser.parse(Unknown Source)
    at jxl.biff.formula.FormulaParser.parse(Unknown Source)
    at jxl.biff.DVParser.<init>(Unknown Source)
    at jxl.biff.DataValiditySettingsRecord.initialize(Unknown Source)
    at jxl.biff.DataValiditySettingsRecord.getFirstColumn(Unknown Source)
    at jxl.read.biff.SheetReader.J(Unknown Source)
    at jxl.read.biff.SheetImpl.l(Unknown Source)
    at jxl.read.biff.SheetImpl.getRows(Unknown Source)
    at com.ufgov.fas.client.page.TreeTableAuditPage_JS.importApplys(TreeTableAuditPage_JS.java:1060)
    at com.ufgov.fas.client.page.TreeTableAuditPage_JS.imported(TreeTableAuditPage_JS.java:1034)

导入的时候报这个错,后来发现是导入的模板格式被破坏了,本来excel中设置的下拉被粘贴没了,用原有的模板重新做了数据再导入就可以了

posted @ 2024-04-29 11:23  小小野生程序员sunny  阅读(39)  评论(0编辑  收藏  举报