@Konrad_K_Sobon Hi Is there any chance we can can add clear sheet before import into Write excel node? or some possible connection with clear excel? I can not clear and write excel in one script…using player… Appreciate your feedback or advice, [image]

Might not work, but have you tried using the write to excel node twice - once with all null values and once with the correct data? If you wire things correctly to rely on order (one code block containing both the output from the first write to excel node as a unwired output and the file path for you…

You have to add a Transaction.End node after the Clear contents node. Have a look at this Code, it might help you[ Exporta pro Excel.dyn (47.3 KB) ](http://)

It is configured to a portuguese version of Excel, you can use google translator for the words you don’t recognize.

thanks a lot will test if can do clear and write in one go…

So feeding nulls into the spreadsheet and overwriting it’s contents with blank data and then feeding the correct data didn’t work? I’ll look into this Monday as I swear I did this before.

Try using the ‘wait for’ passthrough node from clockwork?

Bumblebee - how to clear excel before import

Developers

Michal_Dengusiak June 11, 2017, 5:25pm 3

I need to be able to run this in one click,

How to Clean all data in an excel Spreadsheet from dynamo

Topic		Replies	Views
Clearing Data From Excel Before Writing New Data Packages archi-lab , bumblebee , excel	0	927	October 30, 2017
Clear sheet in Excel Packages bumblebee , excel	5	1527	July 18, 2016
How to Clean all data in an excel Spreadsheet from dynamo	3	1737	May 14, 2019
Cannot Clear Excel Contents with Bumblebee Node Revit archi-lab , excel	8	1446	May 12, 2020
BB - Excel Clear Contents - Revit 2015 bumblebee , excel	4	2726	February 22, 2017

Bumblebee - how to clear excel before import

Related topics