I recent downloaded the updated version of the Excel to Revit script made by Brendan Cassidy. The script is great as it recognises the UK BS1192 naming standards and automatically updates your drawing sheets within Revit from excel. The script works fine with a blank excel sheet but I am trying to incorporate it into my firm’s own drawing register but I am having no luck trying to filter out the null fields out.
I asked Brendan on what he thought the problem was and his reply was:
‘I think it is probably because it is bringing null values in from the lower empty cells, What happens is if their has been a edited cell at some point it still brings it in but as a null value, so I probably need to add some way of checking for this and eliminating these null values’
Can anyone tell me how best to filter these fields out? I have attached a dummy copy of our drawing register / Revit template and the script I am using to populate my drawing sheets within Revit
Drawing Register.xlsx (27.1 KB)
Sheet Creation From Excel v0.4.dyn (55.9 KB)
Excel to Revit Test.rvt (1.8 MB)