I am trying to create a way to export our existing schedules to an excel file. I was able to but this, even though it is laid out all on top of each schedule, and the columns have different values. I am ok with this for now but would prefer to get a blank row at every exported schedule. Is there a way to add this to the combined list?
I am just figuring this out so what I did was very basic. Happy to hear any recommendations to improve and simplify the script further. I would eventually try and work this out to have the specific columns to specific value (Lengths, Counts, Area), but for now, adding a blank row after every schedule would clean it up a bit for clarity.
The data input for an Excel file is a two dimensional list - a list of lists. Each inner list is a row.
If you insert a nested empty list you will get a blank row.
Example graph below with simplified flow. Excuse the export node - not a happy camper in R2026. I was able to export to csv. Also List.Combine node inserts a null at the end so it needs a clean.
I don’t know if there’s a particular reason you want all of them on the same page, but I would also suggest writing each schedule to a separate sheet as an alternative.
Thanks @Nick_Boyts - I will need the data into one file so the Estimators can eventually link it directly to their ordering software.
I actually have considered having the schedules into different sheets, this is something I will have to discuss with the estimators. Also, can I automate the excel sheet generation via Dynamo? Cheers
Thanks @RevitRobot I have considered putting the data into a combination schedule as well, but these are existing schedules that we use and a lot of different categories with different fields and calculated fields so I figured it will be doubling the work with uncertain result.
Yes, you will need to match the amount of Schedules with the amount of Sheet names that you put as an input to the Excel node. The easiest would be to use List.Count and then use a Code Block with:
Resulting in "Sheet " + [1..#List.Count(list)..1] if you want Sheet 1, Sheet 2, Sheet 3 etc. alternatively you can just get all the Schedule names and then put that into the Sheet name input
Really appreciate the help @RevitRobot ! This gets me really close to the end goal, which is also to create separate columns for Lengths, Area & Count values which usually sits at as the end column (3rd column) of the schedules, the first two columns are typical Item code & description to all schedule. I would prefer these to be 3rd (lengths) , 4th (Area) or 5th column (Count) in the spreadsheet eventually so I dont need to fix this within excel. I do think would be a different approach instead of just getting the schedules into one list. I still need to do a lot of digging but do you think that would be possible with this setup? Cheers
Ah so now we’re going to bend your mind even further.
you can also create a master ‘schedule’ within Dynamo. You’ve been basically doing that already, by merging the data. However you can also grab the elements from the schedule and read individual data (such as parameters) and add that to your schedule
This becomes a bit tricky with your current setup unless each schedule has the same parameters added to the end of them.
Is it possible to provide the desired end result of 2 Schedules into ExcelSheets in a screenshot? Then it would be easier to advice on the script to accomplish this
Thank you for taking the time mate, Screenshots attached for reference. One screenshot is what it looks like in revit and the preferred format when exported to excel. The first two columns (Item code and Description are relatively fixed. The 3rd column from the revit schedule has a variable unit of measure, which is should be in similar Unit columns thats why it ended up with 5 columns. Hopefully that makes sense. Thank you again for your time @RevitRobot
As per your recommendation, I will setup the Length, Area and Count to be a Shared Parameter that will be the same to all Schedules if that makes it easier to control within Dynamo. Cheers
For this purpose I would really create a master Multi-Category schedule (so don’t select a Category when creating a schedule) and add blank lines per Category.
Shared parameters aren’t neccessary per se, BUT if you DO go down that road, make sure to name them differently to easily distuinguish the parameter in Dynamo. An element with two “Area” parameters will grab just one of them which isn’t always the correct one.
I agree that shared parameters wont be required as I have calculated fields on most of these schedule. I’m just not sure yet how I would combine those fields within a multi category schedule.
Thank you again for a very helpful feedback @RevitRobot . Cheers
