pydeepxlsx 1.0.4

XLSX file as a template

pydeepxlsx

pydeepxlsx is a package used to build a XLSX file using openpyxl and a XLSX file as a template.

flowchart LR
    id1[(Database)]
    id2(XLSX template file)
    id3[[pydeepxl]]
    id4(XLSX generated file)
    id1-->id3
    id2-->id3
    id3-->id4

Install it from PyPI

pip install project_name

Usage

See Documentation

Simple use case

from pydeepxlsx import PyDeepXLSX

xlsx = PyDeepXLSX('./demo.xlsx')
xlsx.copy_as_it('Demo', 0)
xlsx.append_lines(
    'Demo',
    [
        {
            'item': 'Titi',
            'unit_price': 3500,
            'quantity': 0.05,
            'vat': 0.1
        },
        {
            'item': 'Toto',
            'unit_price': 1500,
            'quantity': 0.001,
            'vat': 0.2
        }
    ]
)
xlsx.wb.save('./test.xlsx')

Development

Read the CONTRIBUTING.md file.