Hi All,
I am new to the Dynamo operations, Here what I am is trying to get an output is, I have around 12 parameters which are associated with project title properties such as sheet number, sheet name and other shared parameters etc.
I want to extract them all and make a cross check with my MIDP in excel format. I want to see the result as false or true. I appreciate if you can provide a script if you have already or give me an idea to use the possible nodes to make it. Thanks
the only idea is to switch to PyRevit.
you can create there tables, they look nice like
The part you will find hard is aligning your sheets in excel to revit - what constituted a match? If your sheet numbers do not match in some way that dynamo can work with them the problem is flawed at the outset.
My advice is that hopefully your Revit sheet number matches in revit and excel. If so, read the excel file in dynamo and isolate that column. Using the list.indexof node to find out which row your revit sheet matches, then with that row index you can then ask the excel table the value in other columns. You can then compare this to the various sheet properties to identify which match and dont match. The core goal here is to align your excel rows to revit sheets, and from there comparison between their data is possible.
You’re going to have to at least share an attempt at this for people to feel inclined to help you I’d say.
Sure, i will do that…Thanks Gavin
