Getting Started

pip install excelbird

A brief disclaimer

Excelbird is in early development. There are bugs. Changes are being made several times a week. All provided code examples should work, and if errors are encountered, raise an issue on the project’s Github or reach out to dev @ ryayoung.com for a quicker response.

Prerequisite Knowledge

Layout Tree Structure

Your First Book

Styling

Python Expressions

Lazy References and Expr

Builtin Excel Functions

Gaps and Spacing

Schema: a simple data tool

• Prerequisite Knowledge
  • Prerequisites (for this tutorial)
  • Key terms
  • Naming things
  • Objects and Classes
    • Magic Methods
  • Inline If-Else (Ternary)
    • Excelbird Example
  • List Comprehensions
    • Comprehension Inline If-Else
  • Iterable Unpacking
    • What about keyword arguments?
• Layout Tree Structure
  • 1D Vector
  • 2D Vector
  • Unstructured Container
  • Worksheet
• Writing Your First Book
  • An HTML Layout
  • Excelbird Layout
  • Writing your first Book
  • Auto-open
  • Sibling Types
    • Transpose
  • Stacks
    • Nested Stacks
  • Series Headers
  • Frames
    • Pandas Integration
    • Automatic Iterable Unpacking
    • Subscripting/Slicing
    • Filter/Reorder Elements
    • Assignment
• Styling
  • First, a fun example
  • Styling an Excelbird Workbook
  • Colors
  • Styling Headers
  • Borders
    • Border Syntax
      • Sides
      • Style
  • Margin/Padding
  • Excel Theme Color Grid
• Expressions / Cell References
  • Python Expressions
  • Expressions with Vectors
    • Mixed Lengths
    • Mixed Types
      • Dimensionality
      • Flow Direction
  • A more practical example
  • Operators
    • Python’s Built-In sum()
    • OR(), and NOT()
    • MOD() and %
    • Range ‘:’
  • Other ways to reference a range
    • .range()
    • .loc
• Expr: The Lazy Expression
  • Global Identifiers and Lazy Evaluation
  • The ‘Expr’ Element
• Builtin Excel Functions
• Spacing
• Schema: a simple data tool
  • Creating a Schema
• Schema Examples
  • A more realistic use-case
  • Create a schema that knows how to read its input data