NAME

xlsx2json

SYNOPSIS

xlsx2json OPTIONS EXCEL_WORKBOOK_NAME [SHEET_NAME]

DESCRIPTION

xlsx2json is a tool that converts individual Excel Workbook Sheets into JSON output.

OPTIONS

-help

display help

-license

display license

-version

display version

-N, -sheets

display sheet names in Excel Workbook

-c, -count

display number of sheets in Excel Workbook

-nl, -newline

if true add a trailing newline

-o, -output

output filename

-quiet

suppress error messages

EXAMPLES

This would get the sheet named “Sheet 1” from “MyWorkbook.xlsx” and save as sheet1.json

    xlsx2json MyWorkbook.xlsx "My worksheet 1" > sheet1.json

This would get the number of sheets in the workbook

    xlsx2json -count MyWorkbook.xlsx

This will output the title of the sheets in the workbook

    xlsx2json -sheets MyWorkbook.xlsx

Putting it all together in a shell script and convert all sheets to into JSON documents..

    xlsx2json -N MyWorkbook.xlsx | while read SHEET_NAME; do
        JSON_NAME="${SHEET_NAME// /-}.json"
        xlsx2json -o "${JSON_NAME}" MyWorkbook.xlsx "$SHEET_NAME"
    done

xlsx2json 1.3.5