1

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

Theorp
  • 151
  • 8

1 Answers1

1

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. enter image description here

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

Ahmmed
  • 1,038
  • 1
  • 5
  • 13