Dynamically Generating Excel Templates with Cross-Sheet Dropdown Validation Using ExcelJS in Next.js API Routes
I recently needed to implement a workflow where users download an Excel template, fill it in, and upload it back for processing. The key requirements were: Template contents vary per project (member lists and file lists are fetched dynamically) Dropdown cells should reference data in other sheets as their options The Excel file should be generated server-side in a Next.js API route ExcelJS handles all of this. This post covers how. ...