Hi guys, We, GeekMouse studio open sourced our internal tool "FleX2Json" under MIT license. With comprehensive configurable options, "FleX2Json" is targeted to make both the design of .xls and the conversion of JSON quick and flexible. Hope it can help your projects and welcome for any comment. Features: Java based. Run it anywhere. Run single command to generate JSON files from multiple sheets from multiple .xls sources. Can custom the output paths and extensions for every source file or even every sheet with simple configuration in config.xml. Auto-check data types for every attribute if is needed. Flexibly insert human-readable comment in the excel sheets for every object and attribute. Support 3-layers JSON structure. However in current version, only the array of basic types is supported in the 3rd layer. Potential to support unlimited-layers JSON structure in further updates.
Hi, we've upgraded FleX2Json to v0.92, it now supports XML output, Excel 07 format (.xlsx) input and a parametrizing mode. Check it out HERE.