Is it possible add and rename Excel worksheet by GH script?

Anyone know a simple trick (code/script) that is able to add and rename the worksheet in an existing Excel file? So through GH do this action? Thank you in advance!

Replies to This Discussion

Permalink Reply by Stephen Maher on March 22, 2016 at 10:40am

Hi Luciano,

You may want to check out this discussion. Lots of good content there (as can be expected from Anders).
Also note that openpyxl is not fully compatible with IronPython. So I'd stick with the built-in .NET integration or the xldr module.

Best,
/SPM

Permalink Reply by Luciano on March 22, 2016 at 2:10pm

Thank you Stephen, i'll give it a look!

Permalink Reply by konrad k sobon on March 23, 2016 at 12:53pm

If you don't want to rely on any external modules and instead want to write your own implementation you could look under the hood of a plug-in called Bumblebee by David Mans.

There is also a version of that plug-in written for Dynamo that is also an Open Source project with source available here: https://github.com/ksobon/Bumblebee

A particular line of code that you would need to add new worksheets to Excel can be found in this code at line 166: https://github.com/ksobon/Bumblebee/blob/master/_nodes/Write%20Exce...

Good luck!

RSS