How to read an 2 dimensional / 3 dimensional excel table by using Pentaho Data Integration 8.1 (Spoon)?


Dear stackoverflow members,

I have to solve one task by using Pentaho data integration and excel. The most difficult part seems to be how to import the data. Basically the aim is to import a 2 dimensional table or 3 dimensional table coming out from an excel file and put the data into one database table.

Restrictions: 1. I can not change the layout of the excel file 2. The same layout is in every excel sheet

Ps. The question how to read a excel matrix with unidentified number of columns n ?

enter image description here

I have tried to use excel input component but considering this component I should provide a known number of columns. In my case I do not know how many columns should I take because it can be changed.


Answers: