How to read a specific cell out of a table

[JuLa]

Hello together,

Reading more than 100 Excel-files I have to extract two specific cells out of the “Header” of the tables (Excel Reader (XLS)) and add this two strings to every row in the table. See file attached. The reading of all Excel files with similar structure (shown in the attachment) using a loop structure is no problem, but I don’t know how to get the two strings out of the header. I tried to use a Java snippet but can’t find a solution to get only the both strings, that fits!

Has somebody an idea, what could be a proper solution?

Greetings
Jürgen

[izaychik63]

JuLa, it is not clear if your data always has same location (same cells). If yes you can extract them by Row and Column filters nodes.

[JuLa]

Hello izaychik63,

yes, the data have always the same location!! And you’re right, using Row and Column filter nodes is the easiest way to filter the data. As is often the case…. the simplest solution is best. My thoughts were to complicated!

Jürgen