Skip to content

Tutorials

Learn how to use xltemplate effectively with these step-by-step guides.

Available Tutorials

Getting Started

Your first xltemplate workflow: create a template, populate it with data, and save the result.

Summarizing DataFrames

Create a multi-sheet template with conditional formatting and populate it with plotnine DataFrames.

Schema Extraction

Extract hierarchical column schemas from templates and create matching MultiIndex DataFrames.

Coming Soon

  • Working with Named Ranges
  • Advanced Formula Preservation