Hi all, I have an excel workbook with multiple sheets. There is a table in each of the sheets that has the same starting (anchor) point but the starting row and also the number of rows in each table can be different per sheet. Example of sheets below and test data in attachment. Is there a way to find the anchor point (the word Anchor highlighted in green) and then dynamically read the number of rows the table? I need to read the full table area (i.e. from col.A to col.Q. I could hardcode the number of rows each table will have but i’m conscious that the number rows on each sheet each month could change. Sheet 1: Read data from row 3 to row 7 [image] Sheet 2: Read data from row 7 to row 15 [image] Knime question.xlsx (14.4 KB) Thanks in advance. Pete

Here is a version with the old Row Filter. I add a more general treatment in case of more than one block of data in a sheet (see sheet topic 3 in the Excel file in the data folder for the workflow). excel_area_1.knwf (113,4 Ko) To have a valid workflow, I make it doing something : here writing a table (in the data folder too) for each blocks and sheets. Of course this has to be adpated especialy if all the blocks have the same specifications. Note that I use some Missing value node to propagate the fusionned cell in Excel. Best, Joel

Find row in table based on a text value and count rows in the table

KNIME Analytics Platform

JPollet October 10, 2024, 10:46am 10

Done !

Joel

1 Like