<commit_before>
[![Go Report Card](http://goreportcard.com/badge/rsdoiel/xlsx2json)](http://goreportcard.com/report/rsdoiel/xlsx2json)


# xlsx2json

This is a simple command line utility for converting XML based Excel files to useful JSON objects.  It uses <NAME>'s [xlsx](https://github.com/tealeg/xlsx) golang package alone with <NAME>'s [Otto JavaScript interpretor](https://github.com/robertkrimen/otto).

The basic idea is that xlsx2json reads an Excel file and outputs a JSON expression for each row of the spreadsheet. The headings of the columns become the key names and the value is cell's content.  If you provide a mapping functions written in JavaScript that will be use to process a row into a JSON object.

Like most Unix command line utilities xlsx2json will write to standard output (or standard error if there is a problem). Input is always assumed to be an Excel file's content, output is JSON blobs (one row is one blob).

## Basic usage

```
    xlsx2json myfile.xlsx
```
<commit_msg>Quick Save<commit_after>
    this repository has been depreciated and merged with https://github.com/rsdoiel/jsontools

# xlsx2json

This is a simple command line utility for converting XML based Excel files to useful JSON objects.  It uses Geoff Teale's [xlsx](https://github.com/tealeg/xlsx) golang package alone with <NAME>'s [Otto JavaScript interpretor](https://github.com/robertkrimen/otto).

The basic idea is that xlsx2json reads an Excel file and outputs a JSON expression for each row of the spreadsheet. The headings of the columns become the key names and the value is cell's content.  If you provide a mapping functions written in JavaScript that will be use to process a row into a JSON object.

Like most Unix command line utilities xlsx2json will write to standard output (or standard error if there is a problem). Input is always assumed to be an Excel file's content, output is JSON blobs (one row is one blob).

## Basic usage

```
    xlsx2json myfile.xlsx
```

{'fraction_non_alphanumeric': 0.06696878147029205, 'fraction_numerical': 0.005035246727089627, 'mean_word_length': 4.4141689373297, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 5, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '586042', 'n_tokens_mistral': 574, 'n_tokens_neox': 549, 'n_words': 276}