ExcelTableKit Documentation

ExcelTableKit is a Python library that acts as a high-level abstraction layer over openpyxl for styling tables in .xlsx files.

Instead of dealing directly with openpyxl internals like PatternFill, Border, Side, Font, and Alignment, ExcelTableKit lets you define a cell range as a table object and apply styles to it declaratively in just a few lines of code.

from exceltablekit import ExcelManager, ExcelStyle

excel = ExcelManager("report.xlsx")
excel.set_table("A1", "D10")
excel.define_header(rows=1)

style = ExcelStyle(excel)
style.set_header_background("1F4E79")
style.set_header_font(bold=True, hex_color="FFFFFF")
style.set_background("E8F4FD")
style.set_border()
style.auto_fit_columns()

Getting Started

• Installation
  • Requirements
  • Install from PyPI
  • Verify the installation
  • Install for development
• Quickstart
  • Basic workflow
  • Styling the body
  • Styling the header
  • Working with an existing file and a specific sheet
  • Creating a new sheet inside an existing file
  • Applying a style to the whole table at once
  • Using the CLI

User Guide

• ExcelManager
  • Opening and creating files
  • Defining the table
  • Defining header rows
  • Low-level style application
  • Utility methods
  • Error handling
• ExcelStyle
  • Creating an ExcelStyle instance
  • Body styling
  • Header styling
  • Column auto-fit
  • Available border styles
  • Error handling
• Tables, Cells, and Ranges
  • Overview
  • Cell
  • Table
  • Column and row limits
  • Column letter ↔ number conversion
• Command-Line Interface
  • Available commands
  • info
  • style
  • Examples
  • What the style command does

API Reference

• API Reference
  • ExcelManager
  • ExcelStyle
  • Cell
  • Table
  • Constants and Types
  • Errors

Project

• Changelog