How to export multiple Schedules to Excel?


#1

Hi All,
I’m trying to export schedules to excell. I have about 20 schedules of all building components. I can Export all of them using this graph:


It creates separate Excell files named by Schedule Names.
The question is: How to create one single Excell file, where all exported revit schedules would be on different worksheets?


#2

You’ll have to show the Python code. We can’t tell you what to change if we can’t see what’s happening in the first place. :wink:
And please be sure to use Preformatted Text </> when you paste your code.


#3

Thanks for quick answer. But… how to show the Python code?


#4

Right-click the Python node and select “Edit”.


#5

Sorry, don’t know how to do it


#6

ok, got it
image


#7

I would try using the out of the box node for writing to Excel. You can specify the sheet name that way and write all your schedules to a single file.


#8

I’ve tried, but didn’t success. Problem is i think that it still doesn’t create separate worksheets - only separate files.


#9

Here is how it works with the OOTB node:
http://dictionary.dynamobim.com/#/Office/Excel/Action/WriteToFile


And with Bumblebee:


#10

Look into the posts @Yna_Db gave you.

The OOTB Excel node has to take lines of data, not just schedule views. You should be able to easily retrieve this with the Schedule.GetData node from Bimorph.

EDIT: Using Bimorph to easily export schedules to Excel.


#11

I answered a similar question before:


#12

Awsome! thank all of you!
From my part I created graph like this:


#13

i try to use OOTB nodes only, seems only ScheduleView.Fields available, any way to achieve similar result of Schedule.GetData of BimorphNodes? Python or custom node


#14

Hi comunity,

I’m sorry to return this topic, but I create the same nodes and my name list is all empty.
Any idea?

Tks for assist.


#15

Might be the lacing, maybe consider making all the lists visible as you can’t really tell where it’s currently going wrong.


#16

Hi,

Resending the nodes. I don’t understand why return a empty list after the bool filter.


#17

Look at the results from the all elements of type (line 7) and schedulable fields name (line 7) they are not the same and do not match the search command of “string start with”

I would try to put the all elements output in the node “element.name” and filter that results by the “string start with” node.


#18

Look at the Bumblebee Pkg. They have a “BB Data” node that can take it straight to Excel by also including its own “Write Excel” node. Here’s how it can be used…


#19

Hi all,

I believe my question is not clear. I would like to export Schedule View direct from revit, keeping the sum of elements and organization with filters. When I perform the traditional export, the dynamo creates an excell without grouping and filtering the families. Listing all items without categorizing, filtering and adding. I know that in excell it would be possible to do this without effort, but it is not the goal.

Description / Count / Level

Does anyone know if it’s possible to export this way?


#20

Try the schedule nodes from Bimorph.