Excel
Creating Excel Files in Rust With rust_xlsxwriter Crate
Create Excel files in Rust with rust_xlsxwriter: typed cells, formats, dates, constant memory mode for large files, and reading workbooks with calamine.
7 min read
Library
Everything you need to level up your coding skills.
Excel
Reading Excel in Ruby With Roo and Caxlsx for Writing
Read xlsx files in Ruby with Roo, including headers, typed cells, dates and streaming, and write workbooks with Caxlsx, with notes for Rails uploads.
7 min read
Excel
Writing Excel Files in Go With Excelize Step by Step
Write and read Excel files in Go with Excelize: create a workbook, typed cells and styles, the stream writer for big exports and a row iterator.
7 min read
Excel
Reading Excel Files in R With readxl Without Surprises
Read Excel files in R with readxl: list sheets, set ranges and column types, handle dates, blanks and names, and write workbooks with writexl or openxlsx.
7 min read
Excel
Reading Excel Files in PHP With PhpSpreadsheet Efficiently
Read and write Excel in PHP with PhpSpreadsheet: load sheets, typed cells and dates, read filters and chunks for memory, exports and formula injection.
7 min read
Excel
Using EPPlus or ClosedXML for Excel in C Sharp Projects
Choose between EPPlus and ClosedXML for reading and writing xlsx in C Sharp: licensing, API, performance, formulas and when to use the Open XML SDK instead.
8 min read
Excel
Reading and Writing Excel in Java With Apache POI Safely
Read and write Excel in Java with Apache POI: cell types, DataFormatter, formulas, streaming with SXSSF and event readers, and zip safety limits.
7 min read
Excel
Reading Excel in the Browser With SheetJS Without a Server
Parse an uploaded Excel file in the browser with SheetJS: read it, pick a sheet, convert to JSON, handle dates, limits and security, then export a workbook.
7 min read
YAML
Writing YAML From Python Without Ugly Output or Surprises
PyYAML safe_dump sorts keys, escapes Unicode and quotes multiline strings with blank lines. The options and a block-string representer that fix each default.
6 min read
YAML
Loading YAML in Python With PyYAML safe_load Explained
What yaml.safe_load returns, how to open files correctly, why the C loader is six times faster and the type surprises that come with PyYAML.
6 min read
YAML
Fixing YAML Indentation Errors With a Linter and Editor
A messy file with nine findings, reported by yamllint line by line, then repaired with yq and a project config. The workflow that finds and fixes indentation.
7 min read
YAML
A Cheat Sheet of YAML Syntax for Everyday Config Files
One page of YAML syntax: scalars, quoting, collections, block strings, anchors, documents, comments and the values that change type. Copy-ready snippets.
6 min read
Get new articles by email
We send one email when a new article is published. No spam.