How to read same cell values from every sheet in a workbook

[Anonymous]

Hi there,
I would like to read particular cell values (same location) from every single worksheet in a particular workbook. So far I can only read particular cell values in just one sheet using the technique described here:  Extracting data from specific Excel cells. For some reason (I still have an issue pending on this forum about it) I cannot cycle through all the sheets having selected 'All Sheets' in the tFileInputExcel component.
Now I'm trying a second technique setting up my process as shown in the diagram attached. The question I have are:
1. How can I get the cell value (using Excel cell reference such as A1) from the sheet in the workbook that I am referencing so I can actually output that value in tLogRow
2. Is it possible that I can use this technique to get Excel cell values from all the sheets in the workbook
Thanks,
Facoda

[Anonymous]

I'm not sure I understand. Increasing the row just duplicates the cell output. For example, if I cycle through 2 Sheets and 1 cell on each sheet then I just get 2 copies of the same value = 4 rows. That's if I put 2 rows in the FixedFlowInput?

[Anonymous]

Hi Jlolling,
The actual solution that I need that is perfect for what I want to do is here:  https://community.talend.com/t5/Design-and-Development/Extracting-data-from-specific-Excel-cells-tut...
But I can only get the solution to select the specific cells on the first sheet (even if I select 'All Sheets' on the tFileInputExcel component) the whole solution does not cycle through all the sheets in the entire workbook.
Actually, in the screenshot below it looks like the 'All Sheets' selection is working as it is cycling through a significant amount of rows. 
However, the tFixedFlowInput is only returning one row it would seem.
Maybe I need to use another component rather than the tFixedFlowInput? 
Any suggestions?
Thanks,
Facoda

[Anonymous]

I guess you see it more complex as it is actually.
Every input row of the component addresses one cell and it does not matter in which sheet it is.
If you have 3 sheets with 4 cells you have to define 4 rows in the tFixedFlowInput and because of the iteration through the tFileExcelSheetList you get in the end 12 rows.
The component unfortunately does not support a cell range. To digger the values of cell ranges you should use the tFileExcelSheetInput.

I'm not sure I understand. Increasing the row just duplicates the cell output. For example, if I cycle through 2 Sheets and 1 cell on each sheet then I just get 2 copies of the same value = 4 rows. That's if I put 2 rows in the FixedFlowInput?
Hello,
I am having the exact same issue and I don't understand how to select multiple cells.
I tried using an inline table in tFixedFlowInput, but I get that error :

Exception in component tFileExcelReferencedCellInput_2
java.lang.IllegalArgumentException: Row index must >= 1

Have you found a solution?