simplexl 1.0.1

No project description provided

SIMPLEXL

Simplexl is a Python package which is used to create excel files dynamically using a program. This package depends on openpyxl which is native python package for creating excel.

FEATURES

• Generated formatted excel as ouput.
• Automatically pick the width of column based on data size of column.

Installation

pip install simplexl

How to use

The usage of simplexl is as follows

from simplexl import CreateExcel

xl = CreateExcel(
    excel_name="path/name of the excel  #  default = generate-simplexl.xlsx
)

xl.create_sheet(
    sheet_name=sheet_name,   # optional  default = sheet1
    sheet_index=sheet_index  # optional default = 0
    col_data=col_data,
    row_data=row_data
)

Example

from simplexl import CreateExcel

col_data = ['col1', 'col2']
row_data = [
    ('col1_row1', 'col2_row1'),
    ('col1_row2', 'col2_row2')
]
xl = CreateExcel()

xl.create_sheet(
    col_data=col_data,
    row_data=row_data
)

It will create a xlsx file using row and col data

License

Copyright (c) 2022 Devaraju Garigapati

This repository is licensed under the MIT license. See LICENSE for details.