Is there a way to format excel so that it auto adjustes the width of the columns and the number of decimal digits to two?
i tryed looking at the Bumblebee package but i couldn’t find a way to solve that.
Thanks!
Adjusting the number of decimal places can be done in Dynamo using fairly regular nodes, but getting Excel to cooperate with these may require you to convert your numbers to strings before pushing to Excel.
This thread looks into rounding values:
http://dynamobim.org/forums/topic/rounding-values/
As for formatting column widths, no idea, however I regularly output information to an Excel template file I made, with pre-adjusted columns widths and they always stay 100% consistent.
2 Likes
Bumblebee doesn’t support that functionality yet. Please post a request here: https://github.com/ksobon/Bumblebee/issues
@oliver.green That seems to be the easiest way to handle this at the moment. Just format it in Dynamo before writing to Excel. +1
2 Likes