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?