Clear sheet in Excel

Packages
,
1

Hi there, does anybody know of a way I can clear all contents from an Excel sheet from within Dynamo?

2

use Bumblebee package and a node called Clear Content

4 Likes
3

Hi ,
I am new to dynamo. I could not get the Clear Contents node to work. The help is not very useful, could you give me more onfo? Thanks

4

https://konradsobon.gitbooks.io/bumblebee-primer/content/420%20clear_contents.html

5

Also,

SheetName input…unless you have specifically changed the name of the worksheet I am almost certain that its “Sheet1” and not “sheet1”. Check your spelling.

cellRange input…this is an Excel plug-in, so I don’t think its hard to imagine that you would use Excel based range syntax: “A1:B1” instead of “A1…B1”.

6

Thanks,

I made these changes, and closed Excel as that link says, but still doesn’t work…

Pasted image897Ă—360 35.9 KB