Excel Batch Loader (Export)

Spring Boot 3 app that streams huge XLSX files with low memory and inserts into MySQL using JDBC batches.

Quick start

1. Create table: see src/main/resources/schema-export.sql
2. Configure DB in src/main/resources/application.yml
3. Put .xlsx files into the folder given by app.input-dir
4. Run:

mvn -q -DskipTests spring-boot:run

Notes

• Uses fastexcel-reader (SAX) → tiny memory footprint
• Adjust app.batch-size (2000–5000 good start)
• Keep rewriteBatchedStatements=true in JDBC URL for MySQL