Hello All,
Good day.
I’m creating sheets in Revit using Dynamo with data coming from Excel. Everything works correctly until the final step, where Dynamo reports that the sheet number already exists in the model while creating New sheets. In reality, there are no sheets in my project. I even purged the model and restarted Revit, but the issue persists.
Revit displays a message asking me to delete the sheet, and I manually delete it and check the confirmation box when the error appears. However, I’m still unable to click OK and proceed. Because of this, Dynamo cannot complete the final step of the sheet creation process.
Does anyone have any idea what could be the reason for this issue? and what could be the easiest fix?
As a New User i am not able to attach all the snaps. hence only attached a snap for the error.
**
**
Can you share your Dynamo script, at least Images to check what’s going on? besides try to save your file after delete the sheet, some times deleted objects can still alive in the memory cache, save can sometimes syncronize the internal DB’s tables!
I would suggest you share your dynamo script or a image of it, though i will add that maybe you need to add a ability to check what drawings are already in your revit file and only create new sheets.
Preview the data in the List.Transpose and List.GetItemAtIndex nodes - you’ll likely notice the issue at that point.
Assuming the format of the excel data is “sheet name” in column A and “sheet number” in column B you’re passing a list of lists into the sheet name, and the first name and number into sheet number.
List.Transpose after Data.ImportExcel followed by List.FirstItem which feeds into the sheet name input and a List.LastItem which feeds into the sheet number input.
The issue is you are feeding in the transposed list for Sheet Name whereas you should be feeding in the indexed data of your name, which i suspect is at index 0 of the transposed data.
