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.2.tar.gz
(3.1 kB
view hashes)
Built Distribution
Close
Hashes for xl_reports-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7a86d6ad1b92a7acffa1eba0b38f64df0aab6e30ffa6f2d3216a3eef648d589 |
|
MD5 | 82a06833816c5175120cccad5de59925 |
|
BLAKE2b-256 | 449fe087d0f77c280310386825f611fb1d62df367ce6c403f9b1939aba7a4b18 |