mhaemmerle / excel-to-json

Opinionated Excel to JSON converter where nested structures can be defined on different worksheets
http://mhaemmerle.github.io/excel-to-json/
Apache License 2.0
103 stars 25 forks source link

Cell type not respected #21

Open eproxus opened 10 years ago

eproxus commented 10 years ago

Trying to use integers as IDs will break (but only when having multiple tabs), even when setting the Excel cell type to Text.

kadimulam commented 8 years ago

Yes this is correct. Is there a work around for this?

aniquedavla commented 7 years ago

same. did anyone fix this?

this is the stack trace, i don't understand it. `[#<StackTraceElement clojure.core$name.invoke(core.clj:1505)>,

<StackTraceElement excel_to_json.converter$add_sheet_config$fn__5403.invoke(converter.clj:102)>,

<StackTraceElement clojure.lang.ArrayChunk.reduce(ArrayChunk.java:58)>,

<StackTraceElement clojure.core.protocols$fn__6041.invoke(protocols.clj:98)>,

<StackTraceElement clojure.core.protocols$fn6005$G6000__6014.invoke(protocols.clj:19)>,

<StackTraceElement clojure.core.protocols$seq_reduce.invoke(protocols.clj:31)>,

<StackTraceElement clojure.core.protocols$fn__6028.invoke(protocols.clj:48)>,

<StackTraceElement clojure.core.protocols$fn5979$G5974__5992.invoke(protocols.clj:13)>,

<StackTraceElement clojure.core$reduce.invoke(core.clj:6177)>,

<StackTraceElement excel_to_json.converter$add_sheet_config.invoke(converter.clj:97)>,

<StackTraceElement excel_to_json.converter$parse_normal$iter54245428$fn__5429.invoke(converter.clj:144)>,

<StackTraceElement clojure.lang.LazySeq.sval(LazySeq.java:42)>,

<StackTraceElement clojure.lang.LazySeq.seq(LazySeq.java:60)>,

<StackTraceElement clojure.lang.RT.seq(RT.java:484)>,

<StackTraceElement clojure.core$seq.invoke(core.clj:133)>,

<StackTraceElement clojure.core$dorun.invoke(core.clj:2780)>,

<StackTraceElement clojure.core$doall.invoke(core.clj:2796)>,

<StackTraceElement excel_to_json.converter$parse_normal.invoke(converter.clj:141)>,

<StackTraceElement excel_to_json.converter$parse_workbook$iter54395443$fn__5444.invoke(converter.clj:152)>,

<StackTraceElement clojure.lang.LazySeq.sval(LazySeq.java:42)>,

<StackTraceElement clojure.lang.LazySeq.seq(LazySeq.java:60)>,

<StackTraceElement clojure.lang.RT.seq(RT.java:484)>,

<StackTraceElement clojure.core$seq.invoke(core.clj:133)>,

<StackTraceElement clojure.core$dorun.invoke(core.clj:2780)>,

<StackTraceElement clojure.core$doall.invoke(core.clj:2796)>,

<StackTraceElement excel_to_json.converter$parse_workbook.invoke(converter.clj:149)>,

<StackTraceElement excel_to_json.converter$convert.invoke(converter.clj:155)>,

<StackTraceElement excel_to_json.core$convert_and_save.invoke(core.clj:26)>,

<StackTraceElement excel_to_json.core$run.invoke(core.clj:66)>,

<StackTraceElement excel_to_json.cli$_main.doInvoke(cli.clj:80)>,

<StackTraceElement clojure.lang.RestFn.invoke(RestFn.java:408)>,

<StackTraceElement clojure.lang.Var.invoke(Var.java:415)>,

<StackTraceElement user$eval5.invoke(form-init6453711930725614656.clj:1)>,

<StackTraceElement clojure.lang.Compiler.eval(Compiler.java:6619)>,

<StackTraceElement clojure.lang.Compiler.eval(Compiler.java:6609)>,

<StackTraceElement clojure.lang.Compiler.load(Compiler.java:7064)>,

<StackTraceElement clojure.lang.Compiler.loadFile(Compiler.java:7020)>,

<StackTraceElement clojure.main$load_script.invoke(main.clj:294)>,

<StackTraceElement clojure.main$init_opt.invoke(main.clj:299)>,

<StackTraceElement clojure.main$initialize.invoke(main.clj:327)>,

<StackTraceElement clojure.main$null_opt.invoke(main.clj:362)>,

<StackTraceElement clojure.main$main.doInvoke(main.clj:440)>,

<StackTraceElement clojure.lang.RestFn.invoke(RestFn.java:421)>,

<StackTraceElement clojure.lang.Var.invoke(Var.java:419)>,

<StackTraceElement clojure.lang.AFn.applyToHelper(AFn.java:163)>,

<StackTraceElement clojure.lang.Var.applyTo(Var.java:532)>,

<StackTraceElement clojure.main.main(main.java:37)>]`