edjas 0.5.1

Extract data in JSON from any spreadsheet

EDJAS: Extract Data in JSON from Any Spreadsheet

• Sources at https://github.com/holdenweb/edjas

This project is an attempt to help organisations that insist on managing their businesses, or major aspects thereof, using spreadsheets. Many articles have been written on the limitations of spreadsheet technology. If you have any doubts then look at the "The Problem with Spreadsheets" section of this LinkedIn article. Some large organisations are now providing advice — although in many cases better advice might be: stop using spreadsheets for that!

Rather than try to change the way people do business (imagine "If I Ruled the World" playing softly in the background), EDJAS is intended to help people extract that locked-up data more effectively, in simple and easy-to-understand ways that don't affect existing workflows.

It lets you add data specifications to any existing spreadsheet by creating named ranges in the spreadsheet. By default EDJAS will look for a range name Parameters as its starting point, although this can be overridden on the command line. This range should be precisely two columns wide, and EDJAS treats the left-hand column as names and the right-hand column as values. Normally, the values are used literally after extraction from the spreadsheet. Two formats for the value are given special treatment.

• [range-name]: the named range is exported as a JSON list or, if it's two-dimensional a list of row lists.
• {range_name}: The named range, which must be two columns wide, becomes a JSON object where the left-hand column specifies the names and the right-hand column specifies the values.

The parameter details are used to extract data from the spreadsheet, which is then sent to standard output as JSON.

In the example shown, the version key has a dict value, and in that dict the number key has a value of "1.0.2". The version number can therefore be referenced in the JSON output as version.number. The output from this example is shown below.

A demonstration of the system can be found at https://github.com/holdenweb/edjas-demo.

This is particularly useful for audiences that have an interest in only a limited number of features from a possibly quite large spreadsheet. More generally, JSON is such a widely used format that spreadsheet data can be re-used in a wide range of systems as appropriate.