★ TouchArcade needs your help. Click here to support us on Patreon.

Convert .xls to JSON with open source project: FleX2Json

10-20-2015, 09:20 PM
#1
Joined: Oct 2010
Location: Beijing, China
Posts: 26
Convert ExcelData to JSON/XML with open source project: FleX2Json

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:
  1. Java based. Run it anywhere.
  2. Run single command to generate JSON files from multiple sheets from multiple .xls sources.
  3. Can custom the output paths and extensions for every source file or even every sheet with simple configuration in config.xml.
  4. Auto-check data types for every attribute if is needed.
  5. Flexibly insert human-readable comment in the excel sheets for every object and attribute.
  6. Support 3-layers JSON structure. However in current version, only the array of basic types is supported in the 3rd layer.
  7. Potential to support unlimited-layers JSON structure in further updates.

X-Match, Can you score 100+ in this puzzle?
iOS
GooglePlay

Last edited by dprat0821; 10-25-2015 at 05:11 AM.
10-25-2015, 05:14 AM
#2
Joined: Oct 2010
Location: Beijing, China
Posts: 26
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.

X-Match, Can you score 100+ in this puzzle?
iOS
GooglePlay