Modularized conversion of a csv file into a presentable executive spreadsheet.
Project description
Modularized conversion of a csv file into a presentable executive spreadsheet.
With formatting keyword arguments, this program can fit into an automation
suite to send user-friendly reports with varying numbers of rows and columns.
The result is an Excel spreadsheet with a large title on line zero, the table
(a structured and formatted data range) beginning on line 3, and a spreadsheet
tab with a custom name.
Usage:
csv_to_xlsx(infile=<infile>,
outfile=<outfile>,
sheet_name=<sheet name>,
title_name=<title>,
[delimiter=<delimiter>],
[numeric_columns=<numeric columns>],
[title_format=<title format>]
)
Required keyword arguments:
infile: required string; the csv input filename
outfile: required string; the xlsx output filename
sheet_name: required string; the spreadsheet's tab's name
Example: 'weekly-sales'
title_name: required string; the formal name on row 0 of the report,
Example: 'Weekly Sales Report for May 29'
Optional keyword arguments:
delimiter: optional one-character string; the record delimiter
Default: '|'
numeric_columns: optional list of strings; column names to be imported
as numeric data. Excel defaults to importing everything as text.
Example: ['user_id','customer_id']
title_format: an optional xlsxwriter cell format object dictionary
Default: {'bold': True, 'font_size': 14}
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file csv_to_xlsx_report-0.0.4.tar.gz.
File metadata
- Download URL: csv_to_xlsx_report-0.0.4.tar.gz
- Upload date:
- Size: 5.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
8afcdda3243d2bd810b79f4f96aceb311cf2da62be639256baad746826f64738
|
|
| MD5 |
92805a2887e4ac33a9424dc39d69e87e
|
|
| BLAKE2b-256 |
09624cff0844ac3c52c5f3caed7a1f7562cb6749819610d2f1371777e12b565f
|
Provenance
The following attestation bundles were made for csv_to_xlsx_report-0.0.4.tar.gz:
Publisher:
publish-to-pypi.yml on fisherm7/csv_to_xlsx_report
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
csv_to_xlsx_report-0.0.4.tar.gz -
Subject digest:
8afcdda3243d2bd810b79f4f96aceb311cf2da62be639256baad746826f64738 - Sigstore transparency entry: 233530096
- Sigstore integration time:
-
Permalink:
fisherm7/csv_to_xlsx_report@4ab096cdb329a2f44075b20856a824d72d26dd87 -
Branch / Tag:
refs/tags/v0.0.4 - Owner: https://github.com/fisherm7
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-to-pypi.yml@4ab096cdb329a2f44075b20856a824d72d26dd87 -
Trigger Event:
push
-
Statement type:
File details
Details for the file csv_to_xlsx_report-0.0.4-py3-none-any.whl.
File metadata
- Download URL: csv_to_xlsx_report-0.0.4-py3-none-any.whl
- Upload date:
- Size: 4.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
1dbe375dd68807cab8cf88adf0cf40b9ea729508a1e3e0cc7bf7a75f4f1f1ef1
|
|
| MD5 |
91c0ac516328dd115038567c9d4c6cdf
|
|
| BLAKE2b-256 |
8b734214ada8c54a529fb738611f641cc158ea65c96627547a795e8cf147444b
|
Provenance
The following attestation bundles were made for csv_to_xlsx_report-0.0.4-py3-none-any.whl:
Publisher:
publish-to-pypi.yml on fisherm7/csv_to_xlsx_report
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
csv_to_xlsx_report-0.0.4-py3-none-any.whl -
Subject digest:
1dbe375dd68807cab8cf88adf0cf40b9ea729508a1e3e0cc7bf7a75f4f1f1ef1 - Sigstore transparency entry: 233530099
- Sigstore integration time:
-
Permalink:
fisherm7/csv_to_xlsx_report@4ab096cdb329a2f44075b20856a824d72d26dd87 -
Branch / Tag:
refs/tags/v0.0.4 - Owner: https://github.com/fisherm7
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish-to-pypi.yml@4ab096cdb329a2f44075b20856a824d72d26dd87 -
Trigger Event:
push
-
Statement type: