Helper functions for .xlsx files
Project description
Xlsx filetype utility functions
autofit_columns: Autofit all columns from dataframe written to xlsxfile with xlsxwriter
def autofit_columns(dataframe, worksheet, padding=1.1, index=True):
"""
:param dataframe: Base dataframe written to xlsx workbook
:param worksheet: Sheet in xlsx workbook to be formatted
:param padding: Optional, padding amount
:param index: Optional, Index true/false in dataframe. Defaults true, use false for non-indexed dataframe outputs.
:return: formatted worksheet
"""
Example Call
import pandas as pd
import numpy as np
from xlsxutility import autofit_columns
df = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]),
columns=['a', 'b', 'c'])
writer = pd.excelwriter("some_path",engine='xlsxwriter')
df.to_excel(writer)
autofit_columns(df,writer.sheets['Sheet1'],index=False)
align_cells: Horizontally or vertically align all cells in given dataframe.
Note - If using in conjunction with autofit_columns this must be called first, or the default width (1) will overwrite.
def align_cells(dataframe,workbook,worksheet, align='center'):
"""
:param dataframe: Reference Dataset, Pandas Dataframe
:type dataframe: Pandas Dataframe
:param workbook: Xlsxwriter workbook
:param worksheet: Xlsxwriter worksheet (must be within workbook)
:param align (optional):Defaults to horizontal center. Alignment types Horizontal: (left / center/ right / fill / justify / center_across / distributed) or Vertical: (top, vcenter, bottom, vjustify, vdistributed)
"""
Example Call
import pandas as pd
import numpy as np
from xlsxutility import align_cells
df = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]),
columns=['a', 'b', 'c'])
writer = pd.excelwriter("some_path",sheet_name='Example',engine='xlsxwriter')
df.to_excel(writer)
align_cells(df,writer,writer.sheets['Example'],'center')
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
xlsxutility-1.1.tar.gz
(2.9 kB
view hashes)
Built Distribution
Close
Hashes for xlsxutility-1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fa8fb5544107d97546a472883e663ffd2204c995306dadd3f55d92f00d7a0f2c |
|
MD5 | ae5016af67f95121db5048ae1c7451df |
|
BLAKE2b-256 | f136c3b68a8890d26c06fa9fb9f38294c883e10accd7a727881509eac2db9499 |