Adding Counts and Totals to Excel

bumblebee
excel

#1

Here are some methods to get a count and total from a list that’s to be written to Excel. Then add that list to the front using List.AddItemToFront .

(Edit: image updated)

 


#2

I don’t think you can do it this way. The way Dynamo interops with Excel is that values written to cells are formatted as Strings. I would be surprised if that worked for setting the Formula. If you were to add a formula to a range would need a method called Range.Formula = “=SUM(B2:B4)” or whatever that formula was. Give it a try, but I am not sure that’s possible with the OOTB nodes.


#3

It totally works. I was sharing what I learned.

18_547x167_3EC7B7BC


#4

oh nice, I didn’t think that Excel was that smart to pick it out, but i guess I was wrong. Nice one!


#5

 

In real life:


#6

Here is a working sample. It uses Bumblebee, too.Screen Shot 01-19-16 at 01.38 PM


#7

Published as a Package: “Excel Sum String”

Screen Shot 01-20-16 at 02.03 PM Excel Sum String