Excel
Excel REF NAME and VALUE Errors Explained for Developers
What #REF!, #NAME? and #VALUE! mean when a script writes the formulas, with the usual causes, how to find the cell and the fixes in openpyxl and Excel.
7 min read
Tag
error-fix
93 posts
ExcelGuide
Understanding Excel Errors When Data Comes From Code
A map of Excel errors seen when scripts write or read workbooks: file and format messages, cell error codes, library exceptions and a debugging order.
19 min read
CSV
Fixing DuckDB CSV Type Detection That Guessed Wrong
When the DuckDB CSV sniffer picks the wrong type, override it by column, read as text and cast, or narrow the candidate types. A test file shows each guess.
8 min read
Excel
Pivot Table Refresh Errors and Missing Fields in Excel
Fix field name is not valid, reference is not valid, fields that vanish after refresh, old items that stay, lost formatting and new rows that never appear.
6 min read
CSV
Fixing Expected Columns but Found Errors in SQLite Imports
SQLite prints expected N columns but found M and loads the row anyway, with exit status zero. See each import message and what it did to the data.
7 min read
JSON
When JSONB Is the Wrong Choice and Typed Columns Win
Signs that a PostgreSQL JSONB column should be real columns, what the workarounds cost, and a step-by-step migration that keeps the data and adds constraints.
8 min read
XML
Testing Feed Compatibility Before a Schema Change Ships
Which XSD edits break old documents, which break old consumers, and a script that tests six changes both ways against saved samples before you ship.
6 min read
CSV
Fixing Data Truncated Warnings in a MySQL CSV Load
LOAD DATA LOCAL clips long strings and out of range numbers to the nearest value and only warns. See each warning, the checks that find them, and the fix.
9 min read
XML
Common XSD Validation Errors Explained With the Fix for Each
Ten XSD validation messages from libxml2, exactly as printed, what each one means in the document and the smallest change that makes it validate.
7 min read
CSV
Fixing Incorrect Date Value Errors in a MySQL CSV Import
MySQL rejects a US date with error 1292 on a server load and stores a zero date on a LOCAL load. See both, the STR_TO_DATE fix, and how to find zero dates.
9 min read
CSV
MySQL Error 1290 The Server Is Running With secure file priv
Error 1290 blocks LOAD DATA INFILE and INTO OUTFILE outside one directory. Find the allowed path, move the file there, or switch to LOCAL and know the cost.
6 min read
YAML
Finding Tab Characters Hiding in a YAML File Quickly
Find tabs and non-breaking spaces in YAML with grep, cat -A and git grep, fix them with sed or expand, and keep them out with editor settings and a hook.
6 min read