Library of functions with utilities for the popular xlsx Python module openpyxl
Project description
Openpyxl_utilities
This project consists of a library with functionalities to work with the popular module openpyxl (mainly used to read and write xlsx and xls files from Python) more efficiently. It was kickstarted when I found out openpyxl package does not includes sorting fucntionalities to create xlsx files already sorted (the only option available was to set a sorting button to sort the rows inside Microsoft Excel, not creating the file already sorted).
Prerequisites
This script is written in Python 3.6 using the following non-standard modules:
Installing
First, make sure you have the prerequisites installed using the following command:
$pip freeze
If the list of installed modules does not includes openpyxl==2.5 or higher, run the following command:
$pip install openpyxl
Once the prerequisites are fullfiled, install the module with the following command:
$pip install openpyxl_utilities
If no errors are given, you can already import the module as any other module. To test if everything was correctly installed, run test.py, no error should rise.
$python test.py
If you are sure everything was installed correctly but there were errors, feel free to open an issue and let me help you get it working. n.n
List of functions (up to dated with version 1.0)
- list_values
- adjust_col_width
- print_sheet
- empty_row
- max_length_of_column
- transpose
- sort_sheet_by
- apply_format
- col_to_num
- num_to_col
Authors
- Sebastián MatÃas Carreira
Acknowledgments
- Felipe Prenholato - @chronossc : For his work on openpyxl, core module of these functions
- Nicolás Fusaro - @mnfusaro : For his help in QA and debugging.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for openpyxl_utilities-0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4d23446e6773c132c245e6d35ce8a7b565287e24877305d93134a9c7f167ffaf |
|
MD5 | 5c53d283e4b4bfc9fb3749585ed5220c |
|
BLAKE2b-256 | afc8f4a1b3e93220d6413a880b98b18c6951fad374f52ac5204ca19e3e16d1a4 |