Generate reports from a excel file and some data.
Project description
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],
]
}]
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
xl_reports-0.1.3.tar.gz
(3.1 kB
view hashes)
Built Distribution
Close
Hashes for xl_reports-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cbac50c3b51cbcccb8881c92bbd45f07ec504e89fe9e8ecdbd53dce1cebd482a |
|
MD5 | ce09ddd12e737245c2398cb6ab105461 |
|
BLAKE2b-256 | 8fadd471e8bdcf832be658b897cbacc649270c5dd7cd22b4376d82ecfee3ced6 |