I’ve been using the awesome Bumblebee package to create a better excel output. Our designers want a one second exporter that takes into account blank lines and ideally some formatting.
I’ve hit a roadblock however: I would like to autofit the columns of the created excel.
My knowledge of python is limited but it seems like Bumblebee is using the Microsoft.Office.Interop classes. I found there’s a function worksheet.Columns.AutoFit(); that one can call to autofit columns but I have no idea how to fit that into the graph. Would you recommand making a new python node for this or should I try to slip it into the Bumblebee node?
Any hints on how to get this project started would be very appreciated.
I have no prior Python experience but have scripted in PHP so I understand basic programming logic. This seems like a fun project to start out with.
A I_Export Schedule.dyn (56.3 KB)