I’m currently facing an issue with Exporting data from Dynamo to Excel,(to specific rows and columns) and I could use some guidance on how to proceed. Specifically, I need assistance with the following aspects:
Exporting Multiple Schedules : I have several schedules in my Revit project containing data that I need to export to Excel .I want to export few schedules to a separate sheet (tab) & few more schedules to a separate sheets in Excel and ensure that the data is organized neatly into specific rows and columns.
Automatically Adding Rows: Additionally, I want automatically to add rows if the existing ones are not sufficient to accommodate all the exported data (as few schedules may need more rows than the sheet already has got allotted in it for that particular schedule. This should also be done as the other data rows in excel should not be overwrite while exporting a schedule to specific cell). How can I set up dynamo nodes to perform this task.
Note: We do not know the exact row and column number of the excel in which a particular schedule should be exported to before hand, as the data in Excel may vary now and then. So the script we are running needs to read the excel workbook’s all sheets before running the exporting command in order to find and set the exact cell rows and columns that we need to exported to, for the data present in the schedules.
Could someone please advise me on the best approach to achieve this, would be greatly appreciated.
Thank you in advance for your help…
The best first step is to share what you have and which step you are stuck at.
All of the above is possible in Dynamo, but we are not a free work forum. Many of these things likely have similar topics also if you need somewhere to begin.
Step 1 can be addressed using the bimorph nodes custom package with the bumblebee package for exporting multiple worksheets in a file. The second step is harder and will likely need some evidence of solving step 1 before people can help with it.
Amigo @inabathinasaikrishna buenas.
Diferent software and element types, but same structure and logic, once you have the list of name schedules, and the content in other list configure your node Data.ExportToExcel like this:
Please find the Revit Schedule Images, Dynamo Script, Excel Workbook Files we are using to export Revit Schedules to Export at Specific Rows.
We Need Output As Explained As first message, As of now we reached to level Shown in dynamo script. We exported all schedules with 123 text in schedule name to 123 sheet/tab in excel & with roof text to roof tab in excel workbook, but we are unable to export those schedules at exact rows & columns by adding new rows as required if needed. Please review.
Amigo @inabathinasaikrishna buenas. srry for the delay, if you ask my opinion I think you have chosen an unpaved road, exporting schedules to a “.csv” is a native feature of revit since the first versions. then you can use power query to import this “.csv” to a data model if that is your goal.
but how i am to judge your workflow, anyway this is how we learn dynamo so here is the alternative: firs a little back ground, Basicly Schedules are a kind of family (feature, method, not sure how to call it) that alows to user manage and create a report of parameters names and values of elements in a category, there are very powerfull, unfortunately I am not sure if there is a way to export the final content of each schedule using dynamo, maybe it exists in some package or in the default node library of revit but I don’t know it, I tried to ask for its parameters but I only got the schedule’s own settings.
So the alternative is to get Parameters and parameter values for each element in category, but you will get brut information, not in the clean and organized state it is in the schedule so you will have to clean and organize again the information you get, that’s why I say it’s the hard way, I hope you find the information useful and good luck!
