Metadata-Version: 2.4
Name: csv_to_xlsx_report
Version: 0.0.2
Summary: Modularized conversion of a csv file into a presentable executive spreadsheet.
Project-URL: Homepage, https://github.com/fisherm7/csv_to_xlsx_report
License-Expression: MIT
License-File: LICENSE
Keywords: csv,excel,xlsx
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Requires-Python: >=3.9
Requires-Dist: pandas>=2.2.3
Requires-Dist: xlsxwriter>=3.2.3
Description-Content-Type: text/markdown

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}
```
