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
Tag
how-to
590 posts
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
Excel
Using EPPlus or ClosedXML for Excel in C Sharp Projects
Choose between EPPlus and ClosedXML for reading and writing xlsx in C Sharp: licensing, API, performance, formulas and when to use the Open XML SDK instead.
8 min read
Excel
Reading and Writing Excel in Java With Apache POI Safely
Read and write Excel in Java with Apache POI: cell types, DataFormatter, formulas, streaming with SXSSF and event readers, and zip safety limits.
7 min read
Excel
Reading Excel in the Browser With SheetJS Without a Server
Parse an uploaded Excel file in the browser with SheetJS: read it, pick a sheet, convert to JSON, handle dates, limits and security, then export a workbook.
7 min read
YAML
Writing YAML From Python Without Ugly Output or Surprises
PyYAML safe_dump sorts keys, escapes Unicode and quotes multiline strings with blank lines. The options and a block-string representer that fix each default.
6 min read
YAML
Loading YAML in Python With PyYAML safe_load Explained
What yaml.safe_load returns, how to open files correctly, why the C loader is six times faster and the type surprises that come with PyYAML.
6 min read
XML
Sorting XML Elements for Stable Output and Clean Diffs
Sort XML records by a key with XSLT or lxml so two exports of the same data produce the same file, including numeric keys and nested children.
6 min read
XML
Merging XML Config Files in Git Without Manual Conflicts
Two branches each add a dependency to the same pom.xml and Git reports a conflict. See why, then use the union merge driver and a manual rule that works.
6 min read
XML
Pretty Printing XML for Cleaner Git History and Reviews
A one-line XML file turns every change into one giant diff. Two ways to fix it, a textconv diff driver and a formatted file in the repo, with real output.
7 min read
XML
Diffing XML Ignoring Attribute Order and Layout Noise
Make a line diff of two XML files show real changes only, by canonicalizing both sides, then use xmldiff when you need structural edit actions.
6 min read
XML
Checking Feed Health With a Daily Script and Clear Alerts
A feed health check that tests the fetch, status, content type, well-formedness, item count and freshness, run on eight scenarios with its output.
6 min read