Excel Export resetting formula in excel?

Joe.ashton · January 2, 2019, 12:23pm

Hi,

I’m doing a simple export to excel. The general set-up is, I export the data into a sheet and then on a lovely formatted sheet I do Countifs to get some information about the model.

It all works about from when I rerun the script this happens:

The node i’m using for exporting is this one, I attempted the Bumble version but couldnt export the data out correctly.

The reason why I’m using countifs and not just doing the working out in dynamo is that Formatting the data in excel can be a pain. I was hoping this was a way around it.

Any ideas? Thanks!

m.rijsmus · January 2, 2019, 12:47pm

did you think about exporting to a blanc excel sheet and do you calculations in another one refering to the first?

Joe.ashton · January 2, 2019, 12:59pm

I believe thats what I’m doing.

So the data is being exported to a sheet called “Dynamo Exports” and the CountIf looking at that sheet. When I re-export it loses the link.

Its almost like the excel sheet is deleted and then remade with all the data in it.

m.rijsmus · January 2, 2019, 1:06pm

there might be another way, using two excel files

maltheshkathare · January 2, 2019, 1:22pm

Hi Joe,
The way to use exported Excel files is better explained in this link below

How to Create a Project Dashboard using Revit, Dynamo, and Excel by Archsmarter

Regards,
Malthesh

jacob.small · January 2, 2019, 1:57pm

Try setting this to false:

Joe.ashton · January 4, 2019, 11:55am

Thanks for all the help guys, I attempted to set it to false but it wouldnt then replace the data on re-run.

I ended up using Bumblebee exporter. The reason why it wasn’t working before is that I was extracting the category using Element.Category and didnt notice it wasn’t a string. Converting it to a string made it work great.

For those in similar situation I used this set-up