Excel
Reading Excel Files in Node With exceljs Step by Step
Read and write xlsx in Node.js with exceljs: load a workbook, read typed cells, handle formulas and dates, stream large sheets and avoid common traps.
7 min read
Tag
how-to
590 posts
Excel
Using Parameters in a Database Query From Excel Safely
Drive a database query from cells in Excel with Power Query parameters, bind values instead of pasting text, and avoid SQL injection and stale dates.
7 min read
Excel
Connecting Excel to SQL Server With Power Query and ODBC
Connect Excel to SQL Server with the built in connector or ODBC: choose Windows or SQL authentication, encryption, a native query and read only access.
6 min read
Excel
Connecting Excel to MySQL With the Official Connector
Connect Excel to MySQL with Connector/NET or Connector/ODBC, create a read only user, run a query with Power Query and fix authentication and SSL errors.
6 min read
Excel
Connecting Excel to PostgreSQL With ODBC Step by Step
Install the psqlODBC driver, create a data source, connect Excel to PostgreSQL with a read only role, run a query and fix the usual bitness and SSL problems.
7 min read
YAML
Comments in YAML and What Parsers Do With Them in Practice
YAML allows comments with a hash, but most parsers throw them away when they load and save. What survives a round trip in PyYAML, ruamel.yaml and yq.
6 min read
XML
Incremental XML Feed Imports by Last Modified and ETag
Fetch a feed only when it changed: ETag and Last-Modified headers, a 304 response, a state table, and what to do when the server ignores them.
6 min read
XML
Handling Compressed XML Downloads Without Surprises
A gzip file, gzip transfer encoding and unlabeled gzip behave differently in requests and urllib. Sniff the bytes, stream 36.6 MB at 21 MB, and guard bombs.
6 min read
XML
Importing Product Feeds for Shopping Platforms With Checks
Check a Merchant-style product feed before loading it: required fields, price format, availability values, GTIN check digits, duplicate ids and links.
6 min read
XML
Calling a SOAP Service From Python With zeep and a WSDL
Call a SOAP service from Python with zeep: load the WSDL, call an operation, get typed results, handle a Fault, see the request envelope,.
7 min read
JSON
Mock Data Generators for JSON Tests Demos and Load
Generate JSON test data with Faker, Hypothesis, SQL and jq: seeds for repeatable runs, collisions, and a property test that found real bugs.
6 min read
JSON
Comparing JSON Ignoring Volatile Fields in Python Tests
Compare JSON documents in tests while ignoring ids and timestamps: strip keys, DeepDiff exclusions, placeholders that keep relations, jq del, float tolerance.
6 min read