Reputation: 151
In pentaho data integration, how do I import a list of xlsx files that are in the same folder?
note: the number of columns are always the same
Upvotes: 1
Views: 729
Reputation: 1048
If your excel column name and sheet name are always same then you can use THIS solution. Here I have take all xlsx file from source folder and convert one-by-one file as csv.
But if your excel columnname and sheet name are dynamic or you need some dynamic solution. Then you can use my another stackoverflow solution from Here
Upvotes: 1