Excel
Sparklines and Conditional Formatting for Quick Scans
Add sparklines, data bars, color scales and icon sets to a table so readers can scan 40 rows in seconds, written from XlsxWriter with accessible choices.
7 min read
Topic
Excel
Where the business keeps its data. Reading workbooks, taming dates and formulas, and moving sheets to and from a database.
Excel
Refreshing Charts From a Changing Data Range in Excel
Fix charts that miss new rows or show blank gaps when data size changes: Excel tables, dynamic named ranges, generated ranges and refresh settings.
7 min read
PostgreSQL
Storing Uploaded Excel Files and Their Parsed Rows
Store uploaded Excel files and their parsed rows in PostgreSQL: keep the original, stage, track errors, dedupe by hash and link rows to uploads.
7 min read
Excel
Choosing Excel Chart Types for Query Results That Read
Choose an Excel chart type from the shape of your query result: line, column, bar, stacked, scatter, histogram or table, with rules and the mistakes to avoid.
7 min read
ExcelGuide
Charts From Data Pulled Out of Databases Start to Finish
Build clear Excel charts from database data: shape the query, pick the chart, keep ranges live, avoid misleading axes, add sparklines, export images.
17 min read
Excel
Error Handling With IFERROR and Safer Alternatives Today
Handle Excel formula errors without hiding bugs: IFERROR versus IFNA, testing inputs first, ISERROR functions, XLOOKUP not-found values and error codes.
6 min read
Excel
SUMPRODUCT as a Swiss Army Formula for Conditional Sums
Use SUMPRODUCT for weighted averages, OR conditions, multi-column counts and arithmetic before summing, with its speed limits and what to use instead.
6 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
Get new articles by email
We send one email when a new article is published. No spam.