Optimised way to write in Excel files.
Project description
Excel Write
Optimised way to write in excel files.
Developed by Dipan Nanda (c) 2023
Example of Usage
write_in_excel
from excel-write import write_in_excel
write_in_excel(df, location, sheet)
"""
:param DataFrame df: The DataFrame used to export to Excel
:param str sheet: The name that is to be assigned to the file
:param str location: Location where the file is to be created
:param bool index: including index or not
"""
auto_adjust_excel_width
from excel-write import auto_adjust_excel_width
auto_adjust_column_width_index(df, writer, sheet_name="MySheet", margin=3)
"""
:param DataFrame df: The DataFrame used to export the Excel
:param pd.ExcelWriter writer: The pandas exporter with engine="xlsxwriter"
:param str sheet_name: The name of the sheet
:param int margin: How many extra space (beyond the maximum size of the string)
:param int length_factor: The factor to apply to the character length to obtain the
column width
:param int decimals: The number of decimal places to assume for floats: Should be the
same as the number of decimals displayed in the Excel
:param bool index: Whether the DataFrame's index is inserted as a separate column (if
index=False in df.to_xlsx() set index=False here!)
"""
Changelog
Go here to checkout the complete changelog.
License
This is under MIT License
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
excel-write-1.0.4.tar.gz
(4.7 kB
view hashes)
Built Distribution
Close
Hashes for excel_write-1.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1da41a4f81bc6b899d9b464e8a77ed3317e31fab81302d1c8d60fe8e8180a2ba |
|
MD5 | 721accf7af903ce0eb1591a6845df78d |
|
BLAKE2b-256 | 9d45963f566fbb03334dd0834f98990e00c6e75a0b7ded610e002f3dee191f3c |