Search for Data in Excel - table

#1

Hey everybody,

I would like to search for a few entries in my Excel - table. I get from a other Excel - File the relative Humidity und the Temperatur, but I have Problems with these Excel - table.

I would like to have the yellow cells in the Excel - table. Unfortunately, I have no approach. Has anyone ever done something like that? I would be really grateful for help. I’ve been sitting there for a while and think about it, but without result.

I created the excel table myself and could possibly change it structurally if necessary.

best regards

0 Likes

#2

Hello. Can you upload your excel file? It would be easier to test if you could.

0 Likes

#3

of course, thanks!

Temperaturauswirkung.xlsx (16.2 KB)

0 Likes

#4

Sorry was gone for the weekend. Try this graph:
temperaturfromexcel.dyn (22.8 KB) - Dynamo 2.0.x

0 Likes

#5

Hey, thank you for your help. Your method of reading the table is very elegant!

But I have the Problem, that i can not find ,List.IndexOf´´ , is it in a special package? I only have ,IndexOf´´ and I am not sure that this is the right commend.

0 Likes

#6

List.IndexOf is the standard out of the box node. I am using Dynamo 2.0.2 but it should work with any IndexOf that comes with your version of Dynamo.

0 Likes