No project description provided
Project description
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()
xl.create_sheet(
sheet_name=sheet_name, # optional
sheet_index=sheet_index # optional default = 0
col_data=col_data,
row_data=row_data
)
xl.save(
name="path/name of the excel # default = generate-simplexl.xlsx
)
Example
from simplexl import CreateExcel
sheet1_col_data = ['col1', 'col2']
sheet1_row_data = [
('col1_row1', 'col2_row1'),
('col1_row2', 'col2_row2')
]
sheet2_col_data = ['col1', 'col2']
sheet2_row_data = [
('col1_row1', 'col2_row1'),
('col1_row2', 'col2_row2')
]
xl = CreateExcel()
# Sheet 1
xl.create_sheet(
col_data=sheet1_col_data,
row_data=sheet1_row_data
)
# Sheet 2
xl.create_sheet(
col_data=sheet2_col_data,
row_data=sheet2_row_data
)
xl.save()
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
simplexl-1.0.2.tar.gz
(3.6 kB
view hashes)