XML
Reading Excel XML Spreadsheet 2003 Files With Python
The old Excel XML Spreadsheet 2003 format is plain XML with Worksheet, Row, Cell and Data elements. Read it with lxml, handle Index gaps and types.
7 min read
Library
Everything you need to level up your coding skills.
XML
Flattening Hierarchical XML for Excel Users With Python
Turn orders with repeating items into a workbook a spreadsheet user can filter: one sheet per level linked by order id, or one wide sheet, plus the checks.
6 min read
XML
Opening XML Files in Excel Without Mangled Data or Loss
What happens when you open an XML file in Excel, the choices it offers, why leading zeros and long numbers change, and a safer route that keeps text as text.
5 min read
XML
Exporting Excel Data as XML With a Schema and What Blocks It
Excel exports XML only through an XML map built from a schema. The 65,536 row cap, the constructs that block export, and a script that does the same job.
6 min read
XML
Importing XML Into Excel With an XML Map Step by Step
How Excel maps XML elements to cells with an XML map, what the XML Source pane does, how append and overwrite work, and why repeating data is the hard part.
6 min read
XMLGuide
Moving XML Into and Out of Spreadsheets Without Losing Data
How to get XML into a spreadsheet and back: XML maps, opening files, flattening, the 2003 format, scripts, types and the checks that catch silent loss.
17 min read
XML
Reading Government Open Data in XML With a USGS Feed
Read a real public QuakeML feed from the USGS: two namespaces, nested value elements, depth in meters, magnitude types, and checks that catch a wrong unit.
6 min read
XML
Building Your Own XML Sitemap From a Table in Python and SQL
Generate sitemap files from a PostgreSQL table with a streaming writer: 117,002 URLs in 0.6 seconds, split at 50,000 per file, with an index and validation.
6 min read
XML
Parsing an Atom Feed Into a Database With Safe Upserts
Load an Atom feed into PostgreSQL by entry id with insert or update, read links, categories and html content correctly, and compare lxml with feedparser.
7 min read
XML
Debugging an XSLT Transform That Outputs Nothing or Too Much
Five stylesheets that output nothing or the whole file as text, with the cause of each: a namespace, a built-in rule, an absolute path, and a literal id.
7 min read
XMLGuide
XSLT and XQuery for Real Transformations Step by Step
A working guide to XSLT 1.0, 3.0 and XQuery on the same files: templates, grouping, enrichment, JSON output, parameters, debugging, speed and which to pick.
19 min read
XMLGuide
Parsing XML in Java C Sharp and Other Typed Languages
One XML file and one task in eight languages, with each output, the defaults that change your data, and how each treats absent, empty and bad values.
17 min read
Get new articles by email
We send one email when a new article is published. No spam.