To merge several similar Excel Files in one stream, you can read out a directory with the the wildcard:
.*\.xlsx
For large XLSX Files use the “Apache POI Streaming” engine (not “Apache POI”)
Notes about using Pentaho Data Integration and Apache Hop as Non-Programmer
To merge several similar Excel Files in one stream, you can read out a directory with the the wildcard:
.*\.xlsx
For large XLSX Files use the “Apache POI Streaming” engine (not “Apache POI”)