Skip to main content

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.

Source Distribution

xltojson-1.1.2.tar.gz (2.4 kB view details)

Uploaded Source

Built Distribution

xltojson-1.1.2-py3-none-any.whl (3.7 kB view details)

Uploaded Python 3

File details

Details for the file xltojson-1.1.2.tar.gz.

File metadata

  • Download URL: xltojson-1.1.2.tar.gz
  • Upload date:
  • Size: 2.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.4

File hashes

Hashes for xltojson-1.1.2.tar.gz
Algorithm Hash digest
SHA256 f28a0897b407b8900c01eea177f3bc71ad53825cd1f60c9ba73d09c07a0a72e1
MD5 03e806114921ff4fd8a8a8f565581bb8
BLAKE2b-256 07efe19ebf1183f7825d2a380b8549cce72d09359cd1e9bd4ade199d0bb87264

See more details on using hashes here.

File details

Details for the file xltojson-1.1.2-py3-none-any.whl.

File metadata

  • Download URL: xltojson-1.1.2-py3-none-any.whl
  • Upload date:
  • Size: 3.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.4

File hashes

Hashes for xltojson-1.1.2-py3-none-any.whl
Algorithm Hash digest
SHA256 003e534f6fe0bdf882c4ca93327df9a0c898adfd0a24d0fa84fcb83381edf730
MD5 260eedfe76880b6f0ea68e262e3e6be3
BLAKE2b-256 7d03365a39db6f29f59ebb8eb200ba9a7642b6c6f962e919b60ebacfd414a060

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page