Read Excel data in dynamo


Here i need to filter the sheet parameters and parameters from excel which comes equal. but unfortunately it only taking one value.

Hi @midhun736,

Try changing your list levels in your == node to L2 and L1 with the arrows (next to the input) and set the lacing to cross product.

1 Like


Thnx for the reply. its showing error

hi @midhun736 set the top list level to list level 2

2 Likes

Try list.Contains node instead of == .

1 Like

Hi,

Try this:

1 Like

Those methods are not the cleanest.

To find a list of elements into a list of elements from excel, the best combination that works for me is to use index of, and then get item at index.

Hope it helps

3 Likes