Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

This python package translates Excel data to JSON

Project description

xltojson

This Python Package provides the functionality to translate excel data to JSON object.

Excel provides a very intuitive way of organising data using its rich customizations provided by its functions.

Nowadays, many software applications uses JSON (JavaScript Object Notation) to transfer data. If data is in excel format, it can be a cumbersome task to manually translate data to JSON.

Excel File Format

Each spreadsheet is translated to a python dictionary with key same as the spreadsheet name. The spreadsheet with name "Main" encloses all the other spreadsheet data.

Following is a simple code snippet using which a user can translate file containing excel data to a JSON file.

Usage:

   from xltojson import parse
   parse.translate_excel_to_json(input_excel_file_path, output_json_file_path)

:peace_symbol:

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for xltojson, version 1.1.2
Filename, size File type Python version Upload date Hashes
Filename, size xltojson-1.1.2-py3-none-any.whl (3.7 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size xltojson-1.1.2.tar.gz (2.4 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page