How to read alot data from excel using dynamo

1

image
image770×483 20.2 KB

Hi,
For the sake of this qn lets say my database is the picture attached. What dynamo node can return a number when the input is lets say material 1 and cost, or material 5 and standard length?

Keep in mind that those materials are around 100+ and the parameters (cost etc) are around 30 so using the built it dynamo node for reading excel data.

2

The dataset isn’t very large, the ootb Import Excel node can handle it fine. Then you can add some filtering logic from its output.

3

If it was large what would be suitable?

4

SQL. At that point you would typically store them in a battle-tested database, SQL server for example.

2 Likes
5

I’ve managed to use the open xml excel node for this with 2000 rows and 60 columns - no need to get into real database formats like sql just yet.

1 Like