Hi all, having trouble using this script created by @Dimitar_Venkov could anyone help? also how could i go about exporting to excel as well. I’m in Dynamo 1.0 & Revit 2015, this an API issue?Thanks
Fixed. Line 10 variable spelt wrong. Could anyone help me change this to export to excel?
You change file extension to .csv/.xls for excel.
Words Up
Greate job, I’m trying to do do the same but it seems I missed something
Best Regards,
Hi @JeffT currently your connecting String to the code block. You need to connect “Watch” node list to codeblock.
Yes that was mistake thanks, man, but I change it now , it looks the same I believe I’m missing something
Best Regards,
@JeffT You have to specify file name with extension .csv/.xls for excel. Currently your just feeding the folder.
Hi Jeff, looks fine to me! Perhaps try copying python code again?
import clr
clr.AddReference('RevitAPI')
from Autodesk.Revit.DB import *
schedule = UnwrapElement(IN[0])
path = IN[1]
name = IN[2]
try:
exp_opt = ViewScheduleExportOptions()
schedule.Export(path, name, exp_opt)
OUT = "Done"
except: OUT = "Nope"
Export Schedule(s).dyn (9.4 KB)
Jeff i have attached script but I have been using dynamo 1.0.0 so not sure if this be a problem. This allows you to choose between exporting 1 or multiple schedules. hope this helps
@Lknapton
what’s up, man.
can I ask one question regarding the same issue ,
the script working perfectly but if i’m using this way of numbaring (01-01),(02-07),(05-03) the result in excel shown as date is there is any way to cnvert it in this script before export it
check the photo please
Best Regards,
Hi @JeffT,
You add this { " "} before feeding your Door Number to excel. Its because By default Excel cell format is set to General. See Below an example how to modify your graph. Good Luck!
@JeffT Next time if you have any query start a new thread please. This topic belongs to someone and also your query is off topic. Thanks
Code is working great. I have a question though…
if I want to export only One schedule and without the schedule headers which part of the code needs to modify?
Start a new post with what you have already tried attached as a screenshot, linking back to this post as required.
hi @Lknapton how do I use the code if I want to export one schedule only?
a code block maybe where the I can type the exact name of the schedule and only that schedule will be exported.
Please start a new post with what you have already tried attached as a screenshot, linking back to this post as required, and make sure to read the forum guidelines first:
Additional tip: you can reply to the post that interests you in a linked topic by clicking on “Share a link to this post” / “New Topic”:
hi @Lknapton , i’m trying this script and it works with me but, still i want to export more than one schedule to one excel file , could you help ?
I’m not a python expert, but here’s a post for exporting scheduled to txt files, hope this helps…