Practical Recipes
Copy-ready starting points for focused spreadsheet tasks and production workflows.
Updated
What you will learn
- Start from a focused solution instead of a blank file.
- Follow links to the concept explanation behind the recipe.
XLSX
Read selected columns
Project only the fields needed by an import.
Open guide →SecurityRead an encrypted workbook
Pass the open password through ReaderOptions.
Open guide →MediaExtract workbook images
Inventory anchors and extract media safely.
Open guide →DatabaseImport products by SKU
Use update and unique_by options with failed rows.
Open guide →QueueQueue a large import
Use a durable filesystem or PDO worker.
Open guide →ReportsCreate a pivot summary
Build a source sheet and attach a native pivot.
Open guide →SecurityProtect a finance report
Combine encryption, workbook, and sheet protection.
Open guide →EmailEmail a daily report
Generate a workbook and deliver a MIME attachment.
Open guide →HTTPDownload XLSX in a browser
Set binary headers and clean temporary output.
Open guide →ReliabilityResume a failed import
Persist a manifest and restart idempotently.
Open guide →TemplatesCreate an import template
Generate examples, instructions, and validation.
Open guide →TestingTest XLSX output
Round-trip values and validate package integrity.
Open guide →Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.
Open an issue