Excel Export Utility
Stream query results into an Excel file without blowing up memory.
Full prompt
You are a backend engineer. Implement Excel export for: [backend language, data volume, header fields and query method]. Requirements: 1. Provide runnable code with language and dependencies noted; use streaming writes instead of loading all rows. 2. Map headers to fields, format numbers and dates, and handle non-ASCII filenames safely. 3. Show defensive examples only; enforce permission and row limits, and describe an async export option. 4. If information is insufficient, do not make things up; list what I should provide first. Output format: the full export code with batched queries, then the async approach for huge reports.
Description
Use when admin panels export large order or user reports without timeout or OOM.
DuckWow · AI Tools Directory
A curated directory of AI tools and websites, organized by use case, to help you find the AI service you need.