dhk.csv2xlsx 1.0.1

Read a CSV file and write an XLSX file with optional formatting.

dhk.csv2xlsx

Introduction

dhk.csv2xlsx is a Python command-line tool for reading a CSV file and writing an XLSX file with optional formatting. It leverages the Python standard library csv module and the XlsxWriter package.

Simple Installation

A pedestrian command for installing the package is given below. Alternatively, for a more rewarding installation exercise, see section Recommended Installation.

pip install dhk.csv2xlsx

Usage

$ csv2xlsx --help
usage: csv2xlsx [-h] [--settings-file SETTINGS_FILE] [--verbose] [--force]
                [--output OUTPUT_FILE]
                CSV_FILE

Read a CSV file and write an XLSX file.

positional arguments:
  CSV_FILE              CSV file

options:
  -h, --help            show this help message and exit
  --settings-file, -s SETTINGS_FILE
                        settings file; default: None
  --verbose, -v         verbose
  --force, -f           force; suppress prompts
  --output, -o OUTPUT_FILE
                        output file; default: CSV_FILE - .csv + .xlsx

Examples:

    csv2xlsx \
        CSV_FILE

    csv2xlsx \
        --settings-file SETTINGS_FILE \
        CSV_FILE

    csv2xlsx \
        --settings-file SETTINGS_FILE \
        --output OUTPUT \
        CSV_FILE

Recommended Installation

pyenv is a tool for installing multiple Python environments and controlling which one is in effect in the current shell.

pipx is a tool for installing and running Python applications in isolated environments.

Assuming these have been installed correctly...

Install Python Under pyenv

The version of Python under which this package was last developed and tested is stored in .python-version.

To capture this Python version to a shell variable, execute the commands below. PYTHON_VERSION should be set to something like 3.13.3.

PYTHON_VERSION="$(
    wget \
        -O - \
        https://raw.githubusercontent.com/DavidKiesel/python-csv2xlsx/refs/heads/main/.python-version
)"

echo "$PYTHON_VERSION"

To determine if the .python-version version of Python has already been installed under pyenv, execute the command below. If it has not been installed, then a warning message will be displayed.

PYENV_VERSION="$PYTHON_VERSION" \
python --version

If it has already been installed, then proceed to section Install Package Using pipx.

Otherwise, to install the given version of Python under pyenv, execute the command below.

pyenv install "$PYTHON_VERSION"

If the install was successful, then proceed to section Install Package Using pipx.

If instead there is a warning that the definition was not found, then you will need to upgrade pyenv.

If pyenv was installed through a package manager, then consider upgrading it through that package manager. For example, if pyenv was installed through brew, then execute the commands below.

brew update

brew upgrade pyenv

Alternatively, you could attempt to upgrade pyenv through the command below.

pyenv update

Once pyenv has been upgraded, to install the given version of Python under pyenv, execute the command below.

pyenv install "$PYTHON_VERSION"

Install Package Using pipx

Only proceed from here if the instructions in section Install Python Under pyenv have been completed successfully.

At this point, shell variable PYTHON_VERSION should already contain the appropriate Python version. If not, execute the commands below.

PYTHON_VERSION="$(
    wget \
        -O - \
        https://raw.githubusercontent.com/DavidKiesel/python-csv2xlsx/refs/heads/main/.python-version
)"

echo "$PYTHON_VERSION"

To install the package hosted at PyPI using pipx, execute the command below.

pipx \
    install \
    --python "$(PYENV_VERSION="$PYTHON_VERSION" pyenv which python3)" \
    dhk.csv2xlsx