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 [image]

You change file extension to .csv/.xls for excel. :+1:

@Lknapton Words Up Greate job, I’m trying to do do the same but it seems I missed something Best Regards, [image]

Hi @JeffT currently your connecting String to the code block. You need to connect “Watch” node list to codeblock.

@Kulkul Yes that was mistake thanks, man, but I change it now , it looks the same I believe I’m missing something [image] 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 Great man, it’s amazing job it’s working Best Regards :slight_smile:

@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 [image] [image] 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! [image]

@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 :slight_smile:

Exporting Schedule to text file/excel

Developers

Yna_Db November 6, 2017, 12:23pm 21

Topic		Replies	Views
How to export multiple Schedules to Excel? Revit	35	30773	August 25, 2020
Exporting Schedules to Excel via csv Revit python	17	2341	July 28, 2023
Still looking for a way to Export Schedule to Excel. How about this way? Revit revit , excel , dynamo	7	3365	August 1, 2021
Batch Export Schedules Revit excel , dynamo	6	2922	October 16, 2019
Export Revit schedules into one Excel spreadsheet and separate sheets/tabs Revit	1	1005	October 21, 2019

Exporting Schedule to text file/excel

Related topics