Creating Beautiful Spreadsheets With Data and Templates
summary
A small Clojure library turns plain data into formatted .xlsx files by applying an actual Excel workbook as a template and filling ranges, formulas and charts; two entry points render-to-file and render-to-stream take a map (worksheets → row-replacements) and produce multi-sheet workbooks. Example pulls Yahoo Finance history, creates one sheet per holding, clones chart series for year‑to‑date percent change, preserves formulas and cell formatting, and produces usable files (LibreOffice mostly compatible).
AI-written summary · about
chapters (10)
- 0:00Introduction
- 1:06Why Excel
- 2:37Excel Language
- 3:15What Makes Excel Awesome
- 6:41Spreadsheet Methods
- 17:03Creating a New Sheet
- 21:48Creating a Structure
- 27:30Creating a Chart
- 29:14Derivative Chart
- 30:35Data is API
related talks
39mPython & Spreadsheets: 2017 Edition
34mHomoiconic spreadsheets: What, How & Why
35mConstructing a DSL for Composable Reports in Haskell
58mProductivity Revolution in Excel
24mExtracting data from Excel with Python
38mBuilding a Grammar for Statistical Graphics in Clojure
06m#ProjectLincoln
02h 52mFrom Spreadsheets to DataFrames