That node in particular is relatively fickle. Most people are using a Python version that skips the need to place a view on a sheet to actually create them.
Have a look at this link: https://forum.dynamobim.com/t/excel-...on-sheets/5307
I tried to avoid Python scripts since I don't have any experience with Python Language, but this script is pretty straight forward and it worked. Thanks!!!
This is great! nice post and link!
I just went through this myself. Check out these post that helped me get the job done.
Create new sheet each time dynamo runs and place elements on sheet
Move View Titles (this cannot be done)
Placing views on a sheet
I would note that to make all of this work easily you may need to move your title-block to 0,0. My firms was about 11/512" off from this point making it impossible to get things to line up. I ended up having dynamo draw a line starting from 0,0 to somewhere else (Only way I could figure out how to move the title block accurately). Sucks if you want to incorporate into existing projects but everything now lines up perfectly.