Generating Excel Templates and Importing the Data - Using simple servlet and Apache POI.
- Keep this as lightweight as possible, no need to add frameworks unless it solves complexity.
- Only Servlet (no JSP), keep everything (js and css) in index.html only
- Validate mime type of file on client side if possible
- Use POI only for reading, no need to generate templates using POI, keep the templates as resources within code