Excel file helper for creating, updating, and querying data using pandas.
Project description
📊 excel_utils
A lightweight and intuitive Python utility library for working with Excel (.xlsx) files using pandas and openpyxl. Designed to simplify reading, writing, updating, and analyzing Excel files in just a few lines of code.
✅ Features
- 📁 Create new Excel files with custom columns
- ➕ Append rows to existing Excel files
- 📖 Read and filter data from Excel
- ✏️ Update or delete specific rows and cells
- 📊 Compute basic summary statistics for numeric columns
- 🧹 Clear data while optionally keeping headers
- 🔤 Rename and sort columns
- 🔍 Show all available utility functions with
show_functions()
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
exceltool_2025-0.1.0.tar.gz
(3.6 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file exceltool_2025-0.1.0.tar.gz.
File metadata
- Download URL: exceltool_2025-0.1.0.tar.gz
- Upload date:
- Size: 3.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.10.11
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5426c0152d9b1ef584d985b1cdb41a6e1e91693e8357c35d2d4c316d3e5f9763
|
|
| MD5 |
eaac28ac0be127c7b584abd5f2dc55ee
|
|
| BLAKE2b-256 |
4f839213f72f51e738d6ba57672198e5f19c69ffe8bbeee9390df00e3a86843c
|
File details
Details for the file exceltool_2025-0.1.0-py3-none-any.whl.
File metadata
- Download URL: exceltool_2025-0.1.0-py3-none-any.whl
- Upload date:
- Size: 4.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.10.11
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
7fb676394822234635575167394e34610a5b5e5a8ae3a8c82b2d1c65e4ab4994
|
|
| MD5 |
aa70bdf82696eb84fee11703c906077f
|
|
| BLAKE2b-256 |
098e4ff31b71eb335704e63c28005bb7c733a527e63dd5bdb6ad67b2e18a69a3
|
