Skip to main content

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

csv_to_xlsx_report-0.0.4.tar.gz (5.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

csv_to_xlsx_report-0.0.4-py3-none-any.whl (4.2 kB view details)

Uploaded Python 3

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

Hashes for csv_to_xlsx_report-0.0.4.tar.gz
Algorithm Hash digest
SHA256 8afcdda3243d2bd810b79f4f96aceb311cf2da62be639256baad746826f64738
MD5 92805a2887e4ac33a9424dc39d69e87e
BLAKE2b-256 09624cff0844ac3c52c5f3caed7a1f7562cb6749819610d2f1371777e12b565f

See more details on using hashes here.

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

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file csv_to_xlsx_report-0.0.4-py3-none-any.whl.

File metadata

File hashes

Hashes for csv_to_xlsx_report-0.0.4-py3-none-any.whl
Algorithm Hash digest
SHA256 1dbe375dd68807cab8cf88adf0cf40b9ea729508a1e3e0cc7bf7a75f4f1f1ef1
MD5 91c0ac516328dd115038567c9d4c6cdf
BLAKE2b-256 8b734214ada8c54a529fb738611f641cc158ea65c96627547a795e8cf147444b

See more details on using hashes here.

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

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page