Room Data Sheets


Hi @viktor_kuzev

I am having a similar problem with completing room data sheets. Is there a link to where I can get a python code to substitute certain words in an excel document (as you suggested) in below link.


Revit Room Data Sheets, Duplicate Excel Sheet and write excel to specific cells

You don’t need python for this- a simple string.replace node will do it.
It gets more complicated if there are multiple replacements- in which case you may be better off using dictionaries

incidentally- the method described in the linked post for creating & formatting room data sheets in Dynamo works, but can be very complicated and error prone. In my experience, it is easier to export all the data (using either Dynamo or the build-in ODBC export) then format/sort/group the data to your heart’s content. I used Access