CSV
Previewing a CSV Upload Before Committing Any Changes
Preview a CSV import safely: inspect the file, then run the real import in a transaction that rolls back to count creates, updates and errors.
7 min read
Library
Everything you need to level up your coding skills.
CSV
Designing a CSV Import Screen Users Can Succeed With
What a CSV import screen needs so users succeed: a template, clear limits, column mapping, a preview, plain-language errors and a count before commit.
7 min read
CSVGuide
CSV Import and Export Features in Applications Done Right
Build CSV import and export into an application: staged imports with dry runs, streamed and background exports, column names, round trips and safety.
19 min read
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
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
Get new articles by email
We send one email when a new article is published. No spam.