The xl-reports from sparkgeo

xl-reports's Introduction

XL Reports

Generate Excel reports!

Create an Excel template file
Define a report configuration
Fetch your data
Generate report

Report Configuration Schema

Report configuration is defined as array/list of objects/dicts.

"cell": Worksheet cell coordinates to insert data, example: "B2"

"range": Worksheet coordinate range to insert data. Range start coordinate is required and end coordinate is optional. examples: "B2:" or "B2:C5"

"data_key": Key to use when fetching values from the data dictionary to insert into the worksheet. example: data["report_date"]

"sheet": Worksheet name.

Example configuration

[
    {
        "cell": "B2",
        "data_key": "account",
        "sheet": "my_sheet"
    },
    {
        "cell": "B4",
        "data_key": "report_date",
        "sheet": "my_sheet"
    },
    {
        "range": "A8",
        "data_key": "report_data",
        "sheet": "my_sheet"
    }
]

Example data

[{
    "account": "Engineering",
    "report_date": str(date.today()),
    "report_data": [
        [23.43, 11.96, 9.66],
        [6.99, 65.87, 45.33],
    ]
}]

xl-reports's People

Contributors

Watchers

xl-reports's Issues

Would something similar to this approach work?

# Software packages.
import pandas as pd
from datetime import date


# Test data.
test_data = {
                "account": "Engineering",
                "report_date": date.today(),
                "report_data": [
                                    [23.43, 11.96, 9.66],
                                    [6.99, 65.87, 45.33],
                                ]
                }

# Create data frame from JSON data.
df = pd.DataFrame(test_data).explode("report_data")

# Append to an exsisting Excel file.
with pd.ExcelWriter("output.xlsx", mode = "a") as f:  
    df.to_excel(f, sheet_name = "sheet_name", header = False)

Recommend Projects