Creates xlsx from json via openpyxl.
Project description
xlsx_from_json
Creates xlsx from json via openpyxl.
Usage
Create .json file with following structure:
{
"rows": [
{
"cells": [
{
"value": "Sample text",
// merge 5x2 cell range
"width": 5,
"height": 2,
// openpyxl style: https://openpyxl.readthedocs.io/en/2.5/styles.html
"style": {
"font": {
"name": "Times New Roman",
"size": 12
},
"border": {
"bottom": {
// openpyxl border styles: // https://openpyxl.readthedocs.io/en/stable/_modules/openpyxl/styles/borders.html
"border_style": "medium",
"color": "FFFFFFFF"
}
}
}
}
],
// move row by 2x1
"skip_columns": 2,
"skip_rows": 1,
// change row height
"row_height": 10
}
],
"start_column": 1,
"start_row": 1,
// change column widths
"column_widths": [
{
// column_number or column_letter
"column_number": 1,
"width": 10
}
],
// set number format (e.g. 1.234 -> 1.23)
"number_format": "0.00"
}
Create openpyxl workbook via xlsx_from_json
function:
import json
from xlsx_from_json import xlsx_from_json
with open("data.json", encoding="utf-8") as f:
json_data = json.load(f)
wb = xlsx_from_json(json_data)
Created workbook will have values and styles defined above:
sheet = wb.active
assert sheet.cell(row=2, cell=3).value == "Sample text"
You can pass default style to xlsx builder:
from xlsx_from_json import Style
from openpyxl.styles import Font
default_style = Style(font=Font("Times New Roman", 12, True))
wb = xlsx_from_json(json_data, default_style)
sheet = wb.active
assert sheet.cell(row=2, cell=3).font.name == "Times New Roman"
assert sheet.cell(row=2, cell=3).font.size == 12
assert sheet.cell(row=2, cell=3).font.bold
Now you can use workbook according to openpyxl guide.
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
xlsx_from_json-0.3.0.tar.gz
(5.0 kB
view hashes)
Built Distribution
Close
Hashes for xlsx_from_json-0.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 753815a87478a260e7ea88ef8fda691462e27688324e8d7b5f3c7361cd82631d |
|
MD5 | d0c8b4d6c95946e52af7ae588edc9b4b |
|
BLAKE2b-256 | 8996b8ce7effea8a18ce7c3fb3a1b7b4566ce1812920ccd7aed075722d540dda |