datalogue

datalogue / excel2json / 0.1.0

README.md

Overview

This algorithm can be used to change a file that is an Excel sheet in a new line delimited json. It is in Beta, if you have any feedback, have use cases that we don't handle please send sample data as well as a description of your intentions to support@datalogue.io.

We support .xlsx files

Usage

Input

ParameterDescription
inputFileUriUri of the file as it is accessible on the algorithmia platform
sheetNamethe name of the sheet to extract the data from
outputFileUriUri to be outputed on the algorithmia platform

Output

The output is a file with json delimited by new line characters \n

Examples

A an Excel like this

|id | name
----------
| 0 | Tito
| 1 | Tata

Will be converted to this

{"id":0, "name": "Tito"}
{"id":1, "name": "Tata"}

HEADER1	                | 	HEADER2	
-------------------------------------------------
subheader1 | subheader2	| subheader3 | subheader4
-------------------------------------------------
1	   | 2          | 3          | 4
5          | 6          | 7          | 8
9	   | 10	        | 11	     | 12
13         | 14         | 15         | 16

Will be converted to this

{"HEADER1":{"subheader1":1,"subheader2":2},"HEADER2":{"subheader3":3,"subheader4":4}}
{"HEADER1":{"subheader1":5,"subheader2":6},"HEADER2":{"subheader3":7,"subheader4":8}}
{"HEADER1":{"subheader1":9,"subheader2":10},"HEADER2":{"subheader3":11,"subheader4":12}}
{"HEADER1":{"subheader1":13,"subheader2":14},"HEADER2":{"subheader3":15,"subheader4":16}}