generate-qrcode 0.1.3

Génération d'une colonne qrcode dans un fichier : excel

Generate QR Code from Table Column 🚀

This Python package automatically generates QR codes in memory from a specific column of an Excel (.xlsx) or CSV (.csv) file and inserts them directly into a new Excel file, without storing temporary images on your disk.

Installation

Install the package directly via pip:

pip install generate-qrcode

🛠️ Usage

To use the tool, simply import the function addColumnQRcode from the module generateColumn.

The function takes two parameters:

1 - The path or name of the source file (.xlsx or .csv). 2 - The exact column name to transform into QR codes.

Example with Excel

from generate_qrcode.generateColumn import addColumnQRcode

# 1. Define the file and target column
file_name = "file_name.csv"
target_column = "column_name"

# 2. Run the function
# The function generates and automatically returns the path of the new file created
new_file = addColumnQRcode(file_name, target_column)

print(f"Processing complete! You can open: {new_file}")

Example with CSV

from generate_qrcode.generateColumn import addColumnQRcode

file_name = "file_name.csv"
target_column = "column_name"

new_file = addColumnQRcode(file_name, target_column)

print(f"Processing complete! You can open: {new_file}")

🔄 Output

After running the function:

Original data is preserved.

A new column named QR_Code is added at the end of the table.

QR codes are inserted directly into Excel cells at the correct size (100x100).

The output file is saved as [original_name]_qr.xlsx.

📋 Requirements & Dependencies

The package installs and uses the following libraries:

pandas (for reading Excel/CSV data)

openpyxl (for generating enriched Excel files)

qrcode (for creating QR code matrices)

pillow (to customize the visual appearance of generated QR codes)