NOTE: This is still WIP so bugs might occure.

Exceliser is a tool for helping you serialize your excel documents to json or deserialize json back to excel document.

To install this package simply run following command in your terminal:

pip install exceliser

After installing the library on your machine (or virtual environment) you can serialize/deserialize documents via package CLI.

python -m exceliser --serialize --file test.xlsx --output-name test.json

python -m exceliser --deserialize --file test.json --output-name test.xlsx

You can also import exceliser library directly to your scripts to help you with serialization/deserialization of excel documents.

from exceliser.workbook import serialize

# serialize data to dict
data = serialize(path="/path/to/myworkbook.xlsx")

from exceliser.workbook import deserialize

# deserialize data from dict to worbook
workbook = deserialize(path="/path/to/mydata.json")

# save deserialized worbook as excel file
worbook.save('myworbook.xlsx')

To run all tests simply run following make command in your terminal:

make test

To see rest of the commands, including ones for running tests type following in the terminal:

make help

Serialization of excel documents to json makes them suitable for storing to database and deserialized when needed rather then keeping them as files.

• Srdjan Stankovic