XML
Writing a Basic XSD Schema That Rejects Bad Orders
Build an XSD for an orders file step by step: sequence, pattern, enumeration, optional elements, required attributes and a decimal with attributes.
7 min read
Tag
quality
52 posts
XMLGuide
Validating XML Against an XSD Schema Step by Step Guide
How to check XML files against an XSD: write the schema, run xmllint and lxml, read the errors, add Schematron for business rules, and test changes safely.
18 min read
Excel
Making Excel Exports Open Cleanly Every Time on Any PC
Stop repair prompts, garbled accents and wrong columns when exports open in Excel: legal characters, sheet names, time zones, NaN, BOM and separators.
7 min read
Excel
Validating Row Counts After an Excel Import Step by Step
Prove an Excel import lost nothing by counting rows at the source, the stage and the target, adding control totals, and reconciling rejects in one query.
8 min read