如何导入EXCEL数据到数据库？

hiya_nemo

请问，有EXCEL文本数据想要导入数据，请问有案例么？谢谢

jishuang

平台提供的有excel导入组件

/UI2/system/components/justep/excel/demo/excel.w

hiya_nemo

jishuang 发表于 2018-4-12 08:47
平台提供的有excel导入组件

/UI2/system/components/justep/excel/demo/excel.w

按照例子设置，导入的时候显示not implemented yet,报错，这个是什么问题

jishuang

看tomcat控制台完整的错误信息

hiya_nemo

jishuang 发表于 2018-4-13 08:50
看tomcat控制台完整的错误信息

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: not implemented yet
        at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getExternalSheetIndex(XSSFEvaluationWorkbook.java:117)
        at org.apache.poi.ss.formula.FormulaParser.createAreaRefParseNode(FormulaParser.java:613)
        at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:460)
        at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
        at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117)
        at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077)
        at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064)
        at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424)
        at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524)
        at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508)
        at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465)
        at org.apache.poi.ss.formula.FormulaParser.Arguments(FormulaParser.java:1049)
        at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:934)
        at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556)
        at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:427)
        at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266)
        at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117)
        at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077)
        at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064)
        at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424)
        at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524)
        at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508)
        at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465)
        at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1445)
        at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1566)
        at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174)
        at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:146)
        at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:277)
        at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221)
        at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:257)
        at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:150)
        at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:269)
        at com.justep.excel.ImportGenerator.setCellsValue(ImportGenerator.java:238)
        at com.justep.excel.ImportGenerator.generateRecord(ImportGenerator.java:203)
        at com.justep.excel.ImportGenerator.generateSheet(ImportGenerator.java:198)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:131)
        at Excel.importExcel(Excel.java:88)
        ... 27 more

jishuang

2楼发的平台案例操作报错吗？

hiya_nemo

jishuang 发表于 2018-4-26 11:04
2楼发的平台案例操作报错吗？

没有报错

jishuang

看自己的mapping文件设置中有什么特殊的?
excel中的数据都是什么类型的

hiya_nemo

jishuang 发表于 2018-4-26 13:32
看自己的mapping文件设置中有什么特殊的?
excel中的数据都是什么类型的

EXCEL里面的数据我都设置成文本格式了，mapping里面只有name和cell-number配置了

hiya_nemo

jishuang 发表于 2018-4-26 13:32
看自己的mapping文件设置中有什么特殊的?
excel中的数据都是什么类型的

数据库字段全部是string类型